SELECT DISTINCT C.label as marca, C.rowid as id FROM bks_categorie C LEFT JOIN bks_categories_extrafields Ce ON (C.rowid = Ce.fk_object) LEFT JOIN bks_categorie_product Cp ON (C.rowid = Cp.fk_categorie) LEFT JOIN bks_product P ON (Cp.fk_product = P.rowid) LEFT JOIN bks_product_extrafields Pe ON (P.rowid = Pe.fk_object) WHERE C.fk_parent = 619 AND Ce.mostrar_tienda = 'SI' AND Ce.menu = 'SI' AND Pe.moto_aplic = 'SI' AND Pe.mostrar_en_tienda = 'SI' Order by ordenmenu
bkportal
