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 '-40, 20' at line 1
select pd.products_name, p.products_price, pd.products_viewed, p.products_image, pd.products_description_head, p.products_id, p.manufacturers_id, p.products_stamm_nr, p.products_designyear, p.products_price, p.products_brutto_uvp, p.products_tax_class_id, m.manufacturers_name, IF(s.status, MIN(pa.options_values_price), NULL) as specials_new_products_price, MIN(pa.options_values_price) as final_price, p.products_date_added, pa.options_values_id, COUNT(DISTINCT pa.options_values_id) as variants, COUNT(DISTINCT pa.options_values_price) as options_values_prices_available from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id, products_attributes pa where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id IN(1285,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1321,1322,1323,1324,1325,1326,1327,1333,1379,1385,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1446,1447,1448,1449,1453,1458,1903,1969,1971,1976,1978,1979,1981,2094,2103) and p.products_id = pa.products_id group by p.products_id order by (pd.products_viewed_last_month + pd.products_viewed_current_month) desc, pd.products_name limit -40, 20
[TEP STOP]
|
