select oxlogs.oxuserid, oxlogs.oxshopid from oxuser, oxlogs
left join oxorder on oxorder.oxuserid = oxlogs.oxuserid
where oxuser.oxid = oxlogs.oxuserid
and oxlogs.oxshopid = 'oxbaseshop'
and oxorder.oxuserid is null
AND ( oxuser.oxcreate >= '2012-05-25 12:27:09' AND oxuser.oxcreate <= '2012-05-25 14:27:09' )
GROUP BY oxuser.oxid
