string(1669) "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 'scarlet%' OR sw.word = '' OR sw.word LIKE 'violet%') 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 (0) AND p.indexed = 1) group by p.products_id order by p.products_sort_order, score desc, pd.products_name"
string(1655) "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 'scarlett%' OR sw.word LIKE 'starlet%') 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 (0) AND p.indexed = 1) group by p.products_id order by p.products_sort_order, score desc, pd.products_name"
Wyświetlanie od 0 do 0 (z 0 pozycji)
Stron: 0
Wyświetlanie od 0 do 0 (z 0 pozycji)
Stron: 0
Niestety nie znaleziono produktu! 1. Sprawdź poprawność zapytania i spróbuj ponownie.
2. Ogranicz szukane słowa do jednego lub dwóch.
3. Podaj ogólną nazwę produktu, którego szukasz lub skorzystaj z
wyszukiwania zaawansowanego.
4. Jeżeli używałeś filtrów ogranicz ilość wybranych opcji.
Oferujemy:
Gry Planszowe, Karciane i Bitewne oraz wiele innych dostepnych w naszym sklepie w niskich cenach, zapraszamy do zakupów.