SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new FROM `mc148_product` p LEFT JOIN `mc148_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2) LEFT JOIN `mc148_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `mc148_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2) LEFT JOIN `mc148_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 8 AND tr.`id_state` = 0) LEFT JOIN `mc148_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `mc148_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `mc148_category` cat ON (cat.`id_category` = p.`id_category_default`) WHERE 1 AND p.`active` = 1 AND p.`show_price` = 1 AND cat.`active` = 1 AND p.`id_product` IN (1, 2, 6, 9, 12, 16, 19, 23, 27, 30, 34, 42, 45, 48, 51, 54, 57, 60, 63, 66, 69, 73, 76, 79, 82, 85, 88, 91, 95, 98, 101, 104, 108, 112, 115, 118, 121, 125, 129, 132, 136, 139, 142, 145, 149, 153, 156, 160, 163, 166, 169, 173, 176, 180, 183, 186, 190, 193, 196, 199, 202, 205, 208, 211, 214, 217, 220, 223, 226, 229, 232, 235, 238, 241, 244, 247, 250, 253, 256, 259, 262, 266, 270, 273, 276, 279, 282, 285, 288, 291, 294, 298, 301, 304, 308, 311, 314, 318, 321, 324, 327, 331, 386, 1658, 1659, 1748, 1749, 1750, 1866, 1867, 1868, 1869, 2181, 2295, 2296, 2297, 2298, 2299, 2318, 2320, 2321, 2322, 2323, 2324, 2325, 2326, 2327, 2329, 2330, 2331, 2341, 2342) AND p.`id_product` IN ( SELECT cp.`id_product` FROM `mc148_category_group` cg LEFT JOIN `mc148_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) ORDER BY p.`price` DESC LIMIT 0, 6
Conseils et guide
d’achat
  • Qualité des images
  • Choix des dimensions
  • Délai de livraison
  • Une bibliothèque d'images à votre disposition
  • .....
Evaluations de misscouettes.com