MySQL Error!
MySQL error in file: /engine/ajax/catalog/site/prodoffers_s.php at line 187
Error Number: 1064
The Error returned was:
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 '1,6,102,46,98,87,61,71,104,47,37,67,90,68,45,21,51,7,82,44,11,74,43,69,13,35,63,' at line 1
SQL query:
SELECT v.id, v.name, v.sef_name, v.phone, v.city_id, v.adresse, v.comment, v.vendor_type, v.payments, v.pickup_descr, v.delivery_descr, v.image, v.phone, v.site, v.balance, gv.id as `id_gv`, gv.price * c.rate AS r_price, gv.price, gv.price_old * c.rate AS rl_price, gv.price2 * c.rate AS r2_price, gv.price_old, gv.price2, gv.currency_id, gv.status, gv.descr, v.work_days, v.work_time, gv.vendor_id, gv.date, AVG(r.rating) as rating, gv.arenda, gv.in_agreement, v.noncash, gv.good_url, gv.warranty, gv.country, gv.delivery, gv.pickup FROM `catalog_vendors` v inner join `catalog_goods_vendors` gv on (gv.vendor_id = v.id) inner join `catalog_currency` c on (gv.currency_id = c.id) left join `catalog_vendor_ratings` r on (r.vendor_id = v.id AND r.status = '1') WHERE gv.good_id = '342' AND (gv.price > '0' OR `in_agreement` = '1' OR gv.price_old > '0' OR gv.price2 > '0') AND v.status = '1' AND gv.approve = '1' AND v.vendor_type = '1' AND v.not_show_price NOT LIKE '%5%' GROUP BY v.id ASC ORDER BY FIELD(v.city_id, ,1,6,102,46,98,87,61,71,104,47,37,67,90,68,45,21,51,7,82,44,11,74,43,69,13,35,63,84,99,49,55,30,19,80,56,62,78,59,42,57,103,86,12,91,77,105,10,83,40,92,16,36,38,60,20,23,54,73,76,17,65,100,14,9,34,48,24,89,50,31,41,64,72,95,28,66,88,29,26,27,106,33,58,39,85,93,94,18,81,22,79,101,15,70,96,75,32,97,52,53), rating DESC