select loadid from ( select loadid from dialer_lead_duplicates join pending_dialer_loads using(loadid) where brokerid in (1028) and date(datecreated)=date(20080508) group by requestid, year(datecreated), month(datecreated), day(datecreated), hour(datecreated) ) as tmp_table group by loadidQuery 2: Gives me 207 records
Select LoadId,BrokerId from (Select brokerId, LoadId from dialer_lead_duplicates join pending_dialer_loads using(loadid) where date(datecreated) = '2008-05-08' group by requestid, year(datecreated), month(datecreated), day(datecreated), hour(datecreated) ) as tmp_table group by LoadId having brokerid = 1028