Товары для сада, дачи, огорода

est
MYSQL QUERY ERROR REPORT
 - 29/03/2024 04:03:20
---------------------------------------
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 '&language=ru HTTP/1.1' at line 8

select distinct p.products_image, p.products_images, p.products_images_2, m.manufacturers_name, p.products_weight, p.products_model, pd.products_name,  IF(p.products_quantity > '0', '1', '0') as amount, p.products_price_3, p.products_quantity, p.counted_star_rating, p.admin_star_rating, p.products_id, p.manufacturers_id, p.products_price, pd.products_info, p.products_sort_order, p.products_tax_class_id, IF(s.status  AND s.start_date<=NOW(), 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_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c  
         left join categories_links_to_categories cl2c on cl2c.categories_id = c.categories_id 
                        where  p.products_status = '1' 
                          and p.products_id = p2c.products_id 
                          and pd.products_id = p2c.products_id 
                          and pd.language_id = '1' 
                          and (c.parent_id ='410'  or c.parent_id ='691' or c.parent_id ='402' or c.parent_id ='670' or c.parent_id ='690' or c.parent_id ='669' or c.parent_id ='666' or c.parent_id ='668' or c.parent_id ='667' or c.parent_id ='697' or c.parent_id ='665' or c.parent_id ='626' or c.parent_id ='645' or c.parent_id ='664' or c.parent_id ='586' or p2c.categories_id = '410' or cl2c.parent_id = '410')
                          and p2c.categories_id = c.categories_id order by amount desc, p.products_sort_order ASC, pd.products_viewed_two_weeks desc, pd.products_name  limit 96, 48&language=ru HTTP/1.1
---------------------------------------
Server Name   : sameto.com.ua
Remote Address: 34.204.3.195
Referer       : https://sameto.com.ua/dlja-doma-i-sada-sad-i-ogorod/c-324_410.html?page=3&row_by_page=48&language=ru
Requested     : /sad-i-ogorod/c-324_410.html?page=3&row_by_page=48&language=ru