produits d'une catégorie
string(609) "SELECT T.*, M.prmark_name, M.prmark_id, Coll.prcoll_name_en, Coll.prcoll_id
FROM mysape_products_types T
JOIN mysape_products_collections Coll ON T.prtype_collection = Coll.prcoll_id
JOIN mysape_products_marks M ON T.prtype_mark = M.prmark_id
WHERE T.prtype_category = 'e587af0d23adb09e4a0e5e70f29a77dc'
AND T.prtype_active =1
AND T.prtype_deleted =0
AND Coll.prcoll_active =1
AND Coll.prcoll_deleted =0
AND M.prmark_active =1
AND M.prmark_deleted =0
ORDER BY T.prtype_name asc"
up