Я ниразу не "тыжпрограммист"
уже скурил весь весь инет. Понял, что - ни хрена не понял.
Я в этих кодах - дуб дубом.
Полазил и по форуму, нашел похожие запросы. но дело в том, что я пытался что-то поменять и не фига не получается. Либо ошибка, либо одно из двух.
http://prestashop-forum.ru/index.php?action=helpadmin;help=see_member_ip
SELECT a.`id_product`, b.name as name, `reference`, a.price as price, sa.active as active, shop.name as shopname, a.id_shop_default, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` as sav_quantity, sa.`active`
FROM `ps_product` a
LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)
LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product`)
LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1 AND sav.id_shop_group = 0 )
JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)
LEFT JOIN `ps_shop` shop ON (shop.id_shop = a.id_shop_default)
LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default)
LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = a.`id_product`)
GROUP BY sa.id_product
ORDER BY a.`id_product` ASC;
пробовал этот код. Тупо копипаста - выдает ошибку.
Далее нашел этот код - не рабочий
http://prestashop-forum.ru/index.php?action=helpadmin;help=see_member_ip
SELECT
p.id_product,
pa.reference,
pl.name,
GROUP_CONCAT(DISTINCT(pal.name) SEPARATOR ", ") as combination,
p.price,
pq.quantity
FROM ps_product p
LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product)
LEFT JOIN ps_stock_available pq ON (p.id_product = pq.id_product AND pa.id_product_attribute = pq.id_product_attribute)
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute)
LEFT JOIN ps_attribute_lang pal ON (pac.id_attribute = pal.id_attribute)
WHERE pl.id_lang = 1 /* id нужного языка*/
AND pal.id_lang = 1 /*id нужного языка*/
GROUP BY pa.reference
ORDER BY p.id_product, pac.id_attribute;