Select ordinata per data e per id

[piero.mac]

prova usando una if....

select *,
if(id in (3,4,5), 2, 1) as ord
FROM tabella
order by user_regdate desc, ord
limit .....