MYSQL ERROR REPORT
- 19/03/2024 07:03:39
---------------------------------------
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, 0' at line 65

select distinct

p.products_id,

p.products_fsk18,

pd.products_name,

pd.products_short_description,

p.products_image,

p.products_price,

p.products_model,

p.products_vpe,

p.products_quantity,

p.products_vpe_status,

p.products_vpe_value,

p.products_tax_class_id,

p.products_date_added,

m.manufacturers_name

from products p

left join manufacturers m

on p.manufacturers_id = m.manufacturers_id

left join products_description pd

on p.products_id = pd.products_id,

categories c,

products_to_categories p2c

WHERE pd.language_id = '1'

and c.categories_status=1

and p.products_id = p2c.products_id

and c.categories_id = p2c.categories_id

and products_status = '1'





and p.products_date_added > '2024.03.09'

order

by

p.products_date_added DESC LIMIT -0, 0
---------------------------------------
Server Name : www.karcher-german-technics.com.ua
Remote Address: 54.242.75.224
Referer : https://www.karcher-german-technics.com.ua/novinki.html
Requested : /products_new.php
Trace Back : products_new.php:226(vam_db_queryarray(1) {; [0]=>; &string(2057) "select distinct; ; p.products_id,; ; p.products_fsk18,; ; pd.products_name,; ; pd.products_short_description,; ; p.products_image,; ; p.products_price,; ; p.products_model,; ; p.products_vpe,; ; p.products_quantity,; ; p.products_vpe_status,; ; p.products_vpe_value, ; ; p.products_tax_class_id,; ; p.products_date_added,; ; m.manufacturers_name; ; from products p; ; left join manufacturers m; ; on p.manufacturers_id = m.manufacturers_id; ; left join products_description pd; ; on p.products_id = pd.products_id,; ; categories c,; ; products_to_categories p2c ; ; WHERE pd.language_id = '1'; ; and c.categories_status=1; ; and p.products_id = p2c.products_id; ; and c.categories_id = p2c.categories_id; ; and products_status = '1'; ; ; ; ; ; and p.products_date_added > '2024.03.09' ; ; order; ; by; ; p.products_date_added DESC LIMIT -0, 0"; }; ) => inc/vam_db_query.inc.php:34(vam_db_errorarray(3) {; [0]=>; &string(2057) "select distinct; ; p.products_id,; ; p.products_fsk18,; ; pd.products_name,; ; pd.products_short_description,; ; p.products_image,; ; p.products_price,; ; p.products_model,; ; p.products_vpe,; ; p.products_quantity,; ; p.products_vpe_status,; ; p.products_vpe_value, ; ; p.products_tax_class_id,; ; p.products_date_added,; ; m.manufacturers_name; ; from products p; ; left join manufacturers m; ; on p.manufacturers_id = m.manufacturers_id; ; left join products_description pd; ; on p.products_id = pd.products_id,; ; categories c,; ; products_to_categories p2c ; ; WHERE pd.language_id = '1'; ; and c.categories_status=1; ; and p.products_id = p2c.products_id; ; and c.categories_id = p2c.categories_id; ; and products_status = '1'; ; ; ; ; ; and p.products_date_added > '2024.03.09' ; ; order; ; by; ; p.products_date_added DESC LIMIT -0, 0"; [1]=>; &int(1064); [2]=>; &string(152) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, 0' at line 65"; }; )
==========================================================================