Re: MySQL 8
SELECT INSERTION_ID, CREATED, I.PROF_ID, Z.POSTCODE, I.CATEGORY_ID, I.AREA_ID, TITLE, DESCRIPTION, IS_OFFER, IS_PAID, MAX_DISTANCE, I.IS_VERIFIED, DELETE_ON, P.NAME as PROF_NAME, EMAIL, C.NAME as CATEGORY_NAME, A.NAME as AREA_NAME FROM insertion I INNER JOIN ZIP_CODE Z ON I.ZIP_ID = Z.ZIP_ID INNER JOIN PROFESSOR P ON I.PROF_ID = P.PROF_ID INNER JOIN INSERTION_CATEGORY C ON I.CATEGORY_ID = C.CATEGORY_ID INNER JOIN INSERTION_AREA A ON I.AREA_ID = A.AREA_ID WHERE I.IS_VERIFIED = TRUE AND INSERTION_ID <= (select min(INSERTION_ID) from (select 0 as INSERTION_ID, '1970-01-01 00:00:00.000000' as CREATED
union select INSERTION_ID, CREATED from insertion order by INSERTION_ID desc limit 101)) ORDER BY I.CREATED DESC LIMIT 10
Error: Every derived table must have its own alias