Есть такой запрос:
CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT SQL_BUFFER_RESULT
- section.`id` id_section,
- section.`name` name_section,
- section.`pos` pos_section,
- section.`url_link` url_link_section,
- subsection.`id` id_subsection,
- subsection.`id_section` id_section_2,
- subsection.`name` name_subsection,
- subsection.`pos` pos_subsection,
- subsection.`url_link` url_link_subsection,
- page.`id` id_page,
- page.`id_section` id_section_3,
- page.`id_subsection` id_subsection_2,
- art.`id` id_article,
- art.`id_page` art_id_page,
- art.`name` name_article,
- art.`url_link` art_url_link
- FROM `sections` section
- LEFT JOIN `subsections` subsection ON subsection.`id_section` = section.`id`
- LEFT JOIN `pages` page ON page.`id_section` = section.`id`
- LEFT JOIN `articles` art ON art.`id_page` = page.`id`
- AND (page.`id_subsection` = subsection.`id` OR page.`id_subsection` = '0')
- ORDER BY section.`pos`, subsection.`pos`, art.`date`