Настройка на бисквитките
Подаръци за дете
SELECT products.*, images.*, seo.*, tags.count_in_group as weight1, products.product_count_frankytabs as weight2 FROM products, images, tags, seo WHERE product_id = tag_owner_id AND product_published = 1 AND product_image_id = image_id AND product_seo_id = seo_id AND tag_type = 3 AND product_in_stock != 0 AND tag_name = 'дете' GROUP BY tag_owner_id ORDER BY CASE WHEN product_position < 50 THEN weight1 ELSE 99999999999 END ASC, CASE WHEN product_position > 49 THEN weight1 ELSE weight1 END ASC, CASE WHEN product_position < 50 THEN weight1 ELSE 99999999999 END ASC, CASE WHEN product_position > 49 THEN weight1 ELSE weight2 END ASC, CASE product_in_stock WHEN 0 THEN 0 WHEN 1 THEN 1 WHEN 2 THEN 2 WHEN 3 THEN 1 ELSE 0 END DESC, product_new DESC, product_mdate DESC
'podachj4_podarime.products.product_id' isn't in GROUP BY