string(1845) "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 'zew%' OR sw.word LIKE 'cthulhu%') 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 (521,565,975,1217,1242,1434,1435,1436,1437,1443,1444,1445,1446,1849,2163,2240,2486,2664,2791,2792,3090,3091,3092,3093,3145,3240,3241,3713,3900,3982,4182,4668,4916,5183,5185,5186,5949,6135,6288,6510,6701,6711,6712,6843,7640,7680) AND p.indexed = 1) group by p.products_id order by p.products_sort_order"
Pliki cookies i pokrewne im technologie umożliwiają poprawne działanie strony i pomagają dostosować ofertę do Twoich potrzeb. Możemy wykorzystywać pliki cookies własne oraz naszych partnerów w celach analitycznych i marketingowych, również w celu dopasowania treści reklamowych do Twoich preferencji. Możesz zaakceptować wykorzystanie wszystkich tych plików lub dostosować użycie plików do swoich preferencji.