cPath
keywords
order by
sort
page
od
cena_od
cena_do
age_from
size
color
category
character
brand

» Bandai

Bandai


1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT p.products_image, pd.products_name, pd' at line 1

select count(p.products_id) as total SELECT p.products_image, pd.products_name, pd.products_description, p.products_recent_sales, p.products_sort_order, p2c.categories_id, p.products_id, p.products_tv, p.products_delivery, p.products_novinka, p.manufacturers_id, p.products_price, IFNULL(pp.products_tax_class_id, p.products_tax_class_id) AS products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products_to_categories p2c, products p LEFT JOIN products_prices pp ON pp.products_id = p.products_id AND pp.language_id = '10' LEFT JOIN specials s on p.products_id = s.products_id, products_description pd, manufacturers m WHERE p.products_id = p2c.products_id AND pd.products_name <> '' AND p.products_status = 1 AND p2c.categories_id <> 199 AND p2c.categories_id <> 89 AND p2c.categories_id <> 651 AND p2c.categories_id <> 626 AND p2c.categories_id <> 466 AND p2c.categories_id <> 649 AND p2c.categories_id <> 462 AND p2c.categories_id <> 469 AND p2c.categories_id <> 464 AND p2c.categories_id <> 460 AND p2c.categories_id <> 633 AND p2c.categories_id <> 467 AND p2c.categories_id <> 463 AND p2c.categories_id <> 470 AND p2c.categories_id <> 652 AND p2c.categories_id <> 459 AND p2c.categories_id <> 461 AND p2c.categories_id <> 766 AND p2c.categories_id <> 521 AND p2c.categories_id <> 472 AND p2c.categories_id <> 655 AND p2c.categories_id <> 394 AND p2c.categories_id <> 523 AND p2c.categories_id <> 468 AND p2c.categories_id <> 307 AND p2c.categories_id <> 653 AND p2c.categories_id <> 522 AND p2c.categories_id <> 445 AND p2c.categories_id <> 520 AND p2c.categories_id <> 471 AND p2c.categories_id <> 465 AND p2c.categories_id <> 654 AND p2c.categories_id <> 650 AND p2c.categories_id <> 409 AND p2c.categories_id <> 429 AND p2c.categories_id <> 668 AND p2c.categories_id <> 204 AND p2c.categories_id <> 712 AND p2c.categories_id <> 74 AND p2c.categories_id <> 764 AND p2c.categories_id <> 767 AND p2c.categories_id <> 768 AND p2c.categories_id <> 769 AND p.products_price > 0 AND pd.products_id = p.products_id AND pd.language_id = '10' AND p.manufacturers_id = m.manufacturers_id AND m.manufacturers_id IN (184)

[TEP STOP]