string(1644) "select distinct p.products_image, m.manufacturers_id, p.products_id, p.products_quantity, pd.products_name, pd.products_description, p.products_price, p.profit, p.ask_for_price, p.products_tax_class_id, p.products_date_available, p.products_shipment, if (s.status > 0 and s.begins_date <= now() and (isnull(s.expires_date) or s.expires_date = "0000-00-00 00:00:00" or s.expires_date > now()), s.specials_new_products_price, p.products_price * ((100+p.profit)/100)) * if (p.products_tax_class_id > 0 and tr.tax_rate, (100+tr.tax_rate)/100, 1) as final_price from products p inner join products_description pd on p.products_id = pd.products_id left outer join manufacturers m on m.manufacturers_id = p.manufacturers_id left outer join specials s on s.status>0 AND p.products_id = s.products_id left outer join zones_to_geo_zones za on za.zone_country_id in (170, 0) and (za.zone_id in (187, 0) or za.zone_id IS NULL) left outer join tax_rates tr on p.products_tax_class_id = tr.tax_class_id and za.geo_zone_id = tr.tax_zone_id left outer join products_to_categories p2c on (p.products_id = p2c.products_id) left outer join categories c on (p2c.categories_id = c.categories_id) JOIN (SELECT si.products_id, SUM(si.weight) as score FROM search_word sw LEFT JOIN search_index si ON sw.word_id = si.word_id WHERE sw.language_id = 1 AND (sw.word LIKE 'viticulture%') GROUP BY si.products_id) sh ON p.products_id = sh.products_id where p.products_status > 0 and pd.language_id = 1 and c.invisible = 0 and (1 AND p.products_id IN (1707,2111,2171,2487,2592,2926,2927,4997,6206) AND p.indexed = 1) group by p.products_id order by p.products_sort_order"