Invalid query create temporary table old_data select id FROM moskau WHERE ((type & 2)=2) order by date desc LIMIT 0,100; SELECT *, DATE_FORMAT(date + INTERVAL 2 HOUR, '%d.%m.%Y') as fdate, DATE_FORMAT(`update` + INTERVAL 2 HOUR, '%d.%m.%Y %H:%i') as updated, DATE_FORMAT(date + INTERVAL 2 HOUR, '%Y%m%d') as cdate FROM moskau WHERE id in (select id from old_data) ORDER BY date DESC