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/10' or (impressionsday>todayimpressions and impressionsdate='2010/09/10')) and bannerid in (select bannerid from xlaABMiBannersZones where zoneid=7) and startdate<='2010/09/10' and enddate>='2010/09/10' order by status desc,internalhits;