Настройка на бисквитките
Подаръци за жена, приятелка
SELECT products.*, images.*, seo.* , (t1.count_in_group + t2.count_in_group) as weight1, products.product_count_frankytabs as weight2 FROM products, images, tags as t1, tags as t2, seo WHERE product_id = t1.tag_owner_id AND product_id = t2.tag_owner_id AND product_published = 1 AND product_image_id = image_id AND product_seo_id = seo_id AND t1.tag_type = 3 AND t2.tag_type = 3 AND product_in_stock != 0 AND t1.tag_name = 'жена' AND t2.tag_name = 'приятел' GROUP BY product_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, product_position, 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_number' isn't in GROUP BY