SELECT t1.entity_id, t1.`level`, t2.`value`, group_concat(t4.sku separator ',') as skus FROM catalog_category_entity AS t1LEFT JOIN catalog_category_entity_varchar AS t2 ON t2.entity_id=t1.entity_idLEFT JOIN catalog_category_PRoduct AS t3 ON t3.category_id=t1.entity_idLEFT JOIN catalog_product_entity AS t4 ON t4.entity_id=t3.product_idWHERE t1.`level`>=2 AND t2.attribute_id=41 AND t2.store_id=0GROUP BY t1.entity_id
