SELECT article.* FROM cms_articles as article, cms_data as checkbox, cms_data as ordering WHERE article.article_id=checkbox.article_id AND checkbox.name='menu-link' AND CAST(checkbox.value AS UNSIGNED)='1' AND article.article_id=ordering.article_id AND ordering.name='menu-order' AND article.parent_id='263' AND article.section_id='6' ORDER BY checkbox.value, CAST(ordering.value AS UNSIGNED)
