Slide 30
Slide 30 text
SELECT elements.id, elements.fieldLayoutId, elements.uid, elements.enabled,
elements.archived, elements.dateCreated, elements.dateUpdated, elements_i18n.slug,
elements_i18n.uri, elements_i18n.enabled AS enabledForSite, entries.sectionId,
entries.typeId, entries.authorId, entries.postDate, entries.expiryDate,
content.id AS contentId, content.title, content.field_body
FROM (
SELECT elements.id AS elementsId, elements_i18n.id AS elementsI18nId,
content.id AS contentId
FROM elements
INNER JOIN entries ON entries.id = elements.id
INNER JOIN elements_i18n ON elements_i18n.elementId = elements.id
INNER JOIN content ON content.elementId = elements.id
WHERE elements_i18n.siteId=1 AND content.siteId=1 AND elements_i18n.enabled='1'
ORDER BY postDate DESC
LIMIT 100
) subquery
INNER JOIN entries ON entries.id = subquery.elementsId
INNER JOIN elements ON elements.id = subquery.elementsId
INNER JOIN elements_i18n ON elements_i18n.id = subquery.elementsI18nId
INNER JOIN content ON content.id = subquery.contentId
ORDER BY postDate DESC