MYSQL ERROR REPORT
- 28/03/2024 17:03:01
---------------------------------------
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 ')
and p2c.categories_id = '136'
GROUP BY p.pr...' at line 48
select distinct p.products_id,
p.products_fsk18,
p.products_shippingtime,
p.products_model,
pd.products_name,
p.products_ean,
p.products_price,
p.products_tax_class_id,
m.manufacturers_name,
p.products_quantity,
p.products_image,
p.products_weight,
pd.products_short_description,
pd.products_description,
p.products_id,
p.manufacturers_id,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id
,
if(ISNULL(s.specials_new_products_price), 0, 1) AS specials_price_sort_flag,
if(ISNULL(s.specials_new_products_price), 0, (1-s.specials_new_products_price/p.products_price)) AS specials_price_discount,
COUNT(*) AS ordered_count,
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,
IF(p.products_quantity > 0, 1, 0) AS products_on_stock_flag,
IF(p.products_shippingtime > 0, 1, 0) AS products_shippingtime_flag
from
products p
left join specials s
on p.products_id = s.products_id
left join manufacturers m
on p.manufacturers_id = m.manufacturers_id
join products_description pd
on p.products_id = pd.products_id
join products_to_categories p2c
on p.products_id = p2c.products_id
left join orders_products op on (p.products_id = op.products_id)
where
p.products_status = '1'
/* and p.products_quantity > 0 */
and pd.language_id = '1'
and p.manufacturers_id in ()
and p2c.categories_id = '136'
GROUP BY p.products_id ORDER BY products_on_stock_flag desc, p.products_ordered desc, p.products_price ASC
---------------------------------------
Server Name : xn--80adnhbq3g0a.xn--p1ai
Remote Address: 52.55.55.239
Referer :
Requested : /products_filter.php?cPath=686_136&cat=136&f100005%5B0%5D=Fischer&f100005%5B1%5D=
Trace Back : #0 vam_db_error(select distinct p.products_id,
p.products_fsk18,
p.products_shippingtime,
p.products_model,
pd.products_name,
p.products_ean,
p.products_price,
p.products_tax_class_id,
m.manufacturers_name,
p.products_quantity,
p.products_image,
p.products_weight,
pd.products_short_description,
pd.products_description,
p.products_id,
p.manufacturers_id,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id
,
if(ISNULL(s.specials_new_products_price), 0, 1) AS specials_price_sort_flag,
if(ISNULL(s.specials_new_products_price), 0, (1-s.specials_new_products_price/p.products_price)) AS specials_price_discount,
COUNT(*) AS ordered_count,
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,
IF(p.products_quantity > 0, 1, 0) AS products_on_stock_flag,
IF(p.products_shippingtime > 0, 1, 0) AS products_shippingtime_flag
from
products p
left join specials s
on p.products_id = s.products_id
left join manufacturers m
on p.manufacturers_id = m.manufacturers_id
join products_description pd
on p.products_id = pd.products_id
join products_to_categories p2c
on p.products_id = p2c.products_id
left join orders_products op on (p.products_id = op.products_id)
where
p.products_status = '1'
/* and p.products_quantity > 0 */
and pd.language_id = '1'
and p.manufacturers_id in ()
and p2c.categories_id = '136'
GROUP BY p.products_id ORDER BY products_on_stock_flag desc, p.products_ordered desc, p.products_price ASC , 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 ')
and p2c.categories_id = '136'
GROUP BY p.pr...' at line 48) called at [/home/buyskiing/web/вашилыжи.рф/public_html/inc/vam_db_query.inc.php:34]
#1 vam_db_query(select distinct p.products_id,
p.products_fsk18,
p.products_shippingtime,
p.products_model,
pd.products_name,
p.products_ean,
p.products_price,
p.products_tax_class_id,
m.manufacturers_name,
p.products_quantity,
p.products_image,
p.products_weight,
pd.products_short_description,
pd.products_description,
p.products_id,
p.manufacturers_id,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id
,
if(ISNULL(s.specials_new_products_price), 0, 1) AS specials_price_sort_flag,
if(ISNULL(s.specials_new_products_price), 0, (1-s.specials_new_products_price/p.products_price)) AS specials_price_discount,
COUNT(*) AS ordered_count,
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,
IF(p.products_quantity > 0, 1, 0) AS products_on_stock_flag,
IF(p.products_shippingtime > 0, 1, 0) AS products_shippingtime_flag
from
products p
left join specials s
on p.products_id = s.products_id
left join manufacturers m
on p.manufacturers_id = m.manufacturers_id
join products_description pd
on p.products_id = pd.products_id
join products_to_categories p2c
on p.products_id = p2c.products_id
left join orders_products op on (p.products_id = op.products_id)
where
p.products_status = '1'
/* and p.products_quantity > 0 */
and pd.language_id = '1'
and p.manufacturers_id in ()
and p2c.categories_id = '136'
GROUP BY p.products_id ORDER BY products_on_stock_flag desc, p.products_ordered desc, p.products_price ASC ) called at [/home/buyskiing/web/вашилыжи.рф/public_html/includes/application_top.php:210]
#2 vamDBquery(select distinct p.products_id,
p.products_fsk18,
p.products_shippingtime,
p.products_model,
pd.products_name,
p.products_ean,
p.products_price,
p.products_tax_class_id,
m.manufacturers_name,
p.products_quantity,
p.products_image,
p.products_weight,
pd.products_short_description,
pd.products_description,
p.products_id,
p.manufacturers_id,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id
,
if(ISNULL(s.specials_new_products_price), 0, 1) AS specials_price_sort_flag,
if(ISNULL(s.specials_new_products_price), 0, (1-s.specials_new_products_price/p.products_price)) AS specials_price_discount,
COUNT(*) AS ordered_count,
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,
IF(p.products_quantity > 0, 1, 0) AS products_on_stock_flag,
IF(p.products_shippingtime > 0, 1, 0) AS products_shippingtime_flag
from
products p
left join specials s
on p.products_id = s.products_id
left join manufacturers m
on p.manufacturers_id = m.manufacturers_id
join products_description pd
on p.products_id = pd.products_id
join products_to_categories p2c
on p.products_id = p2c.products_id
left join orders_products op on (p.products_id = op.products_id)
where
p.products_status = '1'
/* and p.products_quantity > 0 */
and pd.language_id = '1'
and p.manufacturers_id in ()
and p2c.categories_id = '136'
GROUP BY p.products_id ORDER BY products_on_stock_flag desc, p.products_ordered desc, p.products_price ASC ) called at [/home/buyskiing/web/вашилыжи.рф/public_html/includes/classes/split_page_results.php:52]
#3 splitPageResults->splitPageResults(select distinct p.products_id,
p.products_fsk18,
p.products_shippingtime,
p.products_model,
pd.products_name,
p.products_ean,
p.products_price,
p.products_tax_class_id,
m.manufacturers_name,
p.products_quantity,
p.products_image,
p.products_weight,
pd.products_short_description,
pd.products_description,
p.products_id,
p.manufacturers_id,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id
,
if(ISNULL(s.specials_new_products_price), 0, 1) AS specials_price_sort_flag,
if(ISNULL(s.specials_new_products_price), 0, (1-s.specials_new_products_price/p.products_price)) AS specials_price_discount,
COUNT(*) AS ordered_count,
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,
IF(p.products_quantity > 0, 1, 0) AS products_on_stock_flag,
IF(p.products_shippingtime > 0, 1, 0) AS products_shippingtime_flag
from
products p
left join specials s
on p.products_id = s.products_id
left join manufacturers m
on p.manufacturers_id = m.manufacturers_id
join products_description pd
on p.products_id = pd.products_id
join products_to_categories p2c
on p.products_id = p2c.products_id
left join orders_products op on (p.products_id = op.products_id)
where
p.products_status = '1'
/* and p.products_quantity > 0 */
and pd.language_id = '1'
and p.manufacturers_id in ()
and p2c.categories_id = '136'
GROUP BY p.products_id ORDER BY products_on_stock_flag desc, p.products_ordered desc, p.products_price ASC , 0, 21, p.products_id) called at [/home/buyskiing/web/вашилыжи.рф/public_html/includes/modules/product_listing.php:56]
#4 include(/home/buyskiing/web/вашилыжи.рф/public_html/includes/modules/product_listing.php) called at [/home/buyskiing/web/вашилыжи.рф/public_html/products_filter.php:404]