Od 1 do 40 (z 307 produktów)
-
Sortuj
1146 - Table 'powert_php7_motocyklista.specials' doesn't exist
SELECT p.*, pd.*, m.*, c.*,
IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) AS final_price,
p.products_quantity AS in_stock,
IF(s.status, 1, 0) AS is_special,
IF(f.status, 1, 0) AS is_featured,
(SELECT GROUP_CONCAT(DISTINCT pa.options_values_id SEPARATOR '||') from products_attributes pa where pa.products_id=p.products_id group by p.products_id) as attri,
(SELECT GROUP_CONCAT(DISTINCT pov.products_options_values_name order by products_options_values_id SEPARATOR '||') from products_options_values pov left join products_attributes pa on pov.products_options_values_id=pa.options_values_id where pa.products_id=p.products_id and pov.language_id = 1) as attri_value
FROM
products p
LEFT JOIN specials s ON p.products_id = s.products_id
LEFT JOIN featured f ON p.products_id = f.products_id
INNER JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id
INNER JOIN products_to_categories p2c
LEFT JOIN categories c ON p2c.categories_id = c.categories_id
WHERE p.products_status = 1 AND c.categories_status = 1 AND p.products_id = p2c.products_id AND pd.products_id = p2c.products_id AND pd.language_id = 1 AND p2c.categories_id = 290 GROUP BY p.products_id ORDER BY pd.products_name
[TEP STOP]