SELECT TOP 1 * FROM xlaABMbanners WHERE (((status=1 Or status=0) AND impressions>0 AND hits2) OR ((status=1 Or status=0) AND impressions=0) OR (impressions>0 AND paymenttype=2 AND clicks'2010/09/09' or (impressionsday>todayimpressions and impressionsdate='2010/09/09')) and bannerid in (select bannerid from xlaABMiBannersZones where zoneid=2) and startdate<='2010/09/09' and enddate>='2010/09/09' order by status desc,internalhits;