Sort aborted<BR><BR>select * from tourportal_offers where cityID like'%' AND hType like'%'  order by update_date desc limit 0, 100000 FOR UPDATE