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"
> sort by : collection / date / increasing price / decreasing price / product nameAll brands / Gsus Sindustries / JUNK de LUXE / Loreak Mendian / Ontour / RVLT RevolutionAll collections / Fall-Winter 2011/2012

> see all products on different pages
jacket/coat - Gsus Sindustries SWEEPERSoldesSold OutGsus SindustriesSWEEPER80.98 € 269.95 €
jacket/coat - JUNK de LUXE JASPER BLAZER PENSoldesSold OutJUNK de LUXEJASPER BLAZER PEN74.97 € 249.9 €
jacket/coat - JUNK de LUXE HALE COATSoldesSold OutJUNK de LUXEHALE COAT74.7 € 249 €
jacket/coat - Loreak Mendian TOLOSA JAPARA WAXSoldesLoreak MendianTOLOSA JAPARA WAX67.47 € 224.9 €
jacket/coat - Ontour POINTERSoldesOntourPOINTER59.98 € 199.95 €
jacket/coat - RVLT Revolution BRICESoldesSold OutRVLT RevolutionBRICE58.47 € 194.9 €
jacket/coat - Loreak Mendian FEDERICO WOOLSoldesSold OutLoreak MendianFEDERICO WOOL53.7 € 179 €
jacket/coat - Gsus Sindustries ROBIN HOODSoldesGsus SindustriesROBIN HOOD47.98 € 159.95 €
jacket/coat - Gsus Sindustries PRIVATESoldesSold OutGsus SindustriesPRIVATE47.98 € 159.95 €
jacket/coat - RVLT Revolution ALVINSoldesSold OutRVLT RevolutionALVIN44.7 € 149 €
jacket/coat - Ontour SABOTAGE AW11SoldesOntourSABOTAGE AW1135.98 € 119.95 €

> see all products on different pages

up