Od 1 do 40 (z 122 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 in (109, 109, 587, 588, 120, 456, 455, 125, 121, 123, 122, 454, 126, 127, 459, 458, 457, 460, 453, 129, 128, 118, 119, 110, 112, 116, 113, 117, 114, 111, 115) GROUP BY p.products_id ORDER BY pd.products_name
[TEP STOP]