SQL statement (several tables are jointly queried together to obtain the data from several to ten pieces)

  mysql, question

1. If there are four tables A, B, C and D respectively, A, B, C and D are linked together, such as:(a innerjoin b by a.id = b.aid) innerjoin c by b.id = c.bid) innerjoin d by c.id = d.cid where condition one AND condition two ...;The above is sorted by time. Data from Articles 11 to 20 are obtained. How should sql statements be written?

MySQL:
Select * from (select … from ((a innerjoin b by a.id = b.aid) innerjoin c by b.id = c.bid) innerjoin d by c.id = d.cid where condition one AND condition two …) as table LIMIT 11,10