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 (681)