ZpětSELECT p_freepost AS p_freepost, p_seodescription AS p_seodescription, p_name AS p_name, p_id, p_seo AS p_seo, pg_p1 FROM products INNER JOIN products_have_cat ON products_have_cat.phc_productsid = products.p_id LEFT JOIN products_category ON products_category.pc_id = products_have_cat.phc_categoryid LEFT JOIN products_gifts ON products_gifts.pg_p2 = products.p_id LEFT JOIN products_variants ON products_variants.pv_productsid = products.p_id LEFT JOIN makers ON makers.m_id = products.p_makerid LEFT JOIN stores ON products_variants.pv_storeid = stores.s_id LEFT JOIN products_category_have_groups ON products_category.pc_id = products_category_have_groups.pc_categoryid WHERE p_makerid NOT IN (106,426) AND p_id NOT IN(67220,67221,67222,67223,67224,67225) AND pv_storeid NOT IN (2) AND m_seo='garda' AND pc_status = 1 AND p_status=1 AND phc_categoryid = 54 AND phc_subcategoryid = 271 AND phc_subsubcategoryid = 228 AND phc_subsubsubcategoryid = 717 AND p_hidden = 0 AND (pc_groupid IS NULL) GROUP BY p_id ORDER BY p_sequence, s_days, p_orders DESC, p_id DESC LIMIT 0,20