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 ') AND bansizes.sizeid=bangrp.bansize AND NOT bansizes.sizelabel = 'autres' and ' at line 1
SQL : SELECT bangrp.banid,bangrp.bantype,bangrp.progid,'4597' as affid,bangrp.banurl,bangrp.bandestinurl,bangrp.bansize,bansizes.sizelabel,bangrp.custom_clicktag_var,bangrp.ecpm, bangrp.geoallowed,bangrp.geoforbidden, capfrequency, captime FROM bangrp,bansizes WHERE bangrp.bantype IN ('flash','gif') AND bangrp.bansize = 24 and progid in () AND bansizes.sizeid=bangrp.bansize AND NOT bansizes.sizelabel = 'autres' and bangrp.banlock = 0 order by bangrp.ecpm desc;