-MySQL 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 ') ) ORDER BY article.name LIMIT 0, 20' at line 26
SELECT SQL_CALC_FOUND_ROWS article.id, article.name, article.alternate_product, aa.name as articleavailbility, ac.name as articlecondition, article.published, article.fkproducer, article.eid, article.pid, article.price1 AS pricenetto, ROUND(article.price1 * (100 + IF(1=1, vatrate.rate, 19)) / 100, 2) AS pricebrutto, article.oldprice AS oldpricenetto, ROUND(article.oldprice * (100 + IF(1=1, vatrate.rate, 19)) / 100, 2) AS oldpricebrutto, article.description, article.available, IFNULL(bo.count, 0) + IFNULL(b.count, 0) AS basketcount, aa.rule, article.isbundle FROM v_article article LEFT OUTER JOIN vatrate ON vatrate.id = article.vatrate LEFT OUTER JOIN basket b ON b.fkarticle = article.id AND b.fkcontractor = '' LEFT OUTER JOIN backlog bo ON bo.fkarticle = article.id AND bo.fkcontractor = '' LEFT OUTER JOIN v_articleavailability aa ON aa.id = article.fkarticleavailability LEFT OUTER JOIN v_articlecondition ac ON ac.id = article.fkarticlecondition WHERE article.published = 1 AND article.isvip=0 AND article.isdealer =0 AND article.id IN (SELECT fkarticle FROM articlexcategory WHERE fkarticlecategory IN (10000,199,258,259,948,10309,10551,10676,10677,10780,10781,11202,11203,11321,11440,11441,11581,11592,11593,246,247,248,249,250,251,252,253,254,255,256,257,744,925,960,1001,10299,10307,10346,10347,10348,10349,10399,10546,10547,10561,10592,10652,10653,10743,10873,10988,11147,11255,11256,11266,280,291,894,914,917,918,953,1036,1133,10023,10024,10025,10027,10028,10029,10031,10039,10040,10042,10043,10044,10046,10048,10051,10055,10402,10403,10404,10405,10446,10587,10588,10589,10590,10591,10659,10660,10662,10666,10667,10668,10669,10674,10711,10712,10713,10714,10715,10716,10717,10718,10719,10720,10721,10722,10723,10776,10857,10858,10859,10860,10861,10862,10863,10864,10866,10867,10869,10994,11005,11006,11008,11058,11059,11097,11137,11138,11212,11241,11273,11314,11328,11567,11609,364,365,366,367,368,369,370,371,372,840,974,10350,10355,10440,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,10319,10693,10797,10887,11369,10098,10284,10415,10416,10417,10418,10419,10422,10423,10424,10425,10426,10427,) ) ORDER BY article.name LIMIT 0, 20