Hallo liebe Entwickler,
es ist ein SQL-Fehler aufgetreten:
Sequence:
Array
(
[sqn_id] => 374
[sqn_title] => Frontend - Shop - Suchergebnisse
[sqn_application] => shop
[sqn_area] => produkte
[sqn_mode] => suchergebnisse
[sqn_headtitle] => FRONTEND_SHOP_SEARCHRESULTS
[sqn_description] =>
[sqn_keywords] =>
[sqn_logrequired] => no
[sqn_cachelifetime] => 60
[mxs] =>
)
Datei:
/var/www/html/sites/avinos-wein.de/_general/classes/Tools/Creole/classes/creole/drivers/mysql/MySQLConnection.php
Zeile:
204
Native Error:
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 '-20, 10' at line 136
User Info:
SELECT
SQL_CALC_FOUND_ROWS
pro.*,
ctg.ctg_template,
IF(buys.buys IS NOT NULL, buys.buys, 0) / IF(views.views IS NOT NULL, views.views, 100000) + IF(views.views > 30 AND buys.buys > 0, 1, 0) pro_customerinterestrate,
ROUND((IF(ccc.cmp_id, ccc.cxp_price, pro.pro_price) / pro.pro_volume),2) pro_priceperliter,
reviews.pro_average,
reviews.pro_averagecount,
IF(ccc.cmp_id, pro.pro_price, NULL) pro_cmp_price,
IF(ccc.cmp_id, ccc.cxp_price, pro.pro_price) pro_price,
IF(ccc.cmp_id, DATEDIFF(ccc.cmp_end, NOW()), 0) pro_cmp_restdays,
IF(pxa.pxa_id, 1, NULL) pro_awards,
IF(pro.pro_limit > 0, 1, 0) pro_available FROM
av_products pro LEFT JOIN
av_categories ctg
ON
pro.ctg_id = ctg.ctg_id
LEFT JOIN
av_types typ
ON
pro.typ_id = typ.typ_id
LEFT JOIN
av_grades grd
ON
pro.grd_id = grd.grd_id
LEFT JOIN
av_growers gro
ON
pro.gro_id = gro.gro_id
LEFT JOIN
av_countries cnt
ON
pro.cnt_id = cnt.cnt_id
LEFT JOIN
av_areas are
ON
pro.are_id = are.are_id
LEFT JOIN
av_sites sit
ON
pro.sit_id = sit.sit_id
LEFT JOIN
(
SELECT
pro_id,
COUNT(*) views
FROM
av_statistics stt
WHERE
stt_action = 'VIEW'
AND
DATE(stt_datetime) > DATE(NOW() - INTERVAL 2 MONTH)
GROUP BY
pro_id
) views
ON
pro.pro_id = views.pro_id
LEFT JOIN
(
SELECT
pro_id,
COUNT(*) buys
FROM
av_statistics stt
WHERE
stt_action = 'BUY'
AND
DATE(stt_datetime) > DATE(NOW() - INTERVAL 2 MONTH)
GROUP BY
pro_id
) buys
ON
pro.pro_id = buys.pro_id
LEFT JOIN
(
SELECT
pro_id,
COUNT(*) pro_averagecount,
AVG(rvw_rating) pro_average
FROM
av_reviews rvw
WHERE
rvw_status = 'aktiv'
GROUP BY
pro_id
) reviews
ON
pro.pro_id = reviews.pro_id
LEFT JOIN
(
SELECT
cmp.*,
cxp.cxp_price,
cxp.pro_id
FROM
av_campaigns cmp
LEFT JOIN
av_x_cmp_pro cxp
ON
cmp.cmp_id = cxp.cmp_id
AND
cmp_start <= NOW()
AND
cmp_end >= NOW()
) ccc
ON
pro.pro_id = ccc.pro_id
LEFT JOIN
av_x_pro_awa pxa
ON
pro.pro_id = pxa.pro_id
LEFT JOIN
av_x_pro_grp pxg
ON
pro.pro_id = pxg.pro_id
LEFT JOIN
av_grapes grp
ON
pxg.grp_id = grp.grp_id WHERE
pro_status = 'ACTIVE'
AND
pro_hide = 'NO'
AND
(
pro_start <= NOW()
OR
pro_start IS NULL
)
AND
(
pro_end >= NOW()
OR
pro_start IS NULL
) GROUP BY
pro.pro_id ORDER BY
pro_available DESC, pro_customerinterestrate ASC LIMIT -20, 10
Freundliche Grüße,
das System