gistfile1.sql

'SELECT `lessons`.`id` * 1 + 0 AS `id`,
`spaces`.`id` AS `published_space_id`
FROM lessons
LEFT JOIN readings on lessons.id = readings.lesson_id AND lessons.draft = 0
LEFT JOIN sections on readings.section_id = sections.id AND sections.hidden = 0
LEFT JOIN manuals on manuals.id = sections.manual_id AND manuals.draft = 0
LEFT JOIN assets_spaces as manual_assets ON manual_assets.asset_id = manuals.id AND manual_assets.asset_type = "Manual"
LEFT JOIN spaces ON manual_assets.space_id = spaces.id'