produits d'une catégorie

string(611) "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 = '311c0c4a7dbf86ed5715b38ae99c10fb' 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_price desc"


> see all products on different pages
jacket/coat - Ontour RIVAOntourRIVA60 € 120 €
jacket/coat - Fenchurch STEWART JACKETFenchurchSTEWART JACKET59.5 € 119 €
jacket/coat - WeSC BALKERWeSCBALKER115 €
jacket/coat - WeSC FINLANDWeSCFINLAND40 € 80 €

> see all products on different pages

up