vopros v teme...

Est' Forum.

Pri razbivke na stanitsy (vyvod n topikov na stranitsu) voznukaet nekaya problema.
Pri vyvode pervoj stranitsy problem net
SELECT top 10 M_id, parent, datein, thread, update
FROM messages
order by update desc, datein desc, thread desc, parent

odnako pri vyvode vtoroj stranitsy otveta na dozhdat'sya

SELECT TOP 10 M_id, thread, parent, author, subject, email, host, datein, update
FROM messages
where M_id not in (
SELECT top 10 M_id
FROM messages
ORDER BY update desc, datein desc, thread desc, parent
)
ORDER BY update desc, datein desc, thread desc, parent

prichem s odnim ORDER BY vse rabotaet, s dvumya nikak...

Naskol'ko ya ponyal Access _ochen'_ medlenno obrabatyvaet vlozhennye zaprosy (v baze > 10 000 zapisej)

V MySQL eto reshaetsya ochen' prosto

SELECT top 10 M_id, parent, datein, thread, update
FROM messages
order by update desc, datein desc, thread desc, parent LIMIT 10, 10;