SELECT ju_articles.article_code,ju_articles.article_title,ju_articles.article_title_2,ju_articles.abstract,ju_articles.abstract_2,ju_articles.full_text, ju_articles.related_issue,ju_articles.doi,ju_articles.article_order,ju_articles.full_text_file,ju_articles.full_text_size,ju_articles.publish_date, ju_articles.page_from,ju_articles.page_to,ju_articles.ar_osubject,ju_articles.article_type, ju_volume.vi_code,ju_volume.vi_title AS vol_title,ju_volume.vi_title_2 AS vol_title_2, ju_issue.vi_year AS vi_year,ju_issue.vi_title AS issue_title,ju_issue.vi_title_2 AS issue_title_2,ju_issue.original_issue, ju_issue.page_from AS issue_from_page,ju_issue.page_to AS issue_to_page,ju_issue.vi_month AS vi_month, ju_article_types.type_name_1,ju_article_types.type_name_2 FROM ju_articles LEFT JOIN ju_volume_issue ju_issue ON ju_issue.vi_code = ju_articles.related_issue LEFT JOIN ju_volume_issue ju_volume ON ju_volume.vi_code = ju_issue.parent_code LEFT JOIN ju_article_types ON ju_article_types.type_code = ju_articles.article_type WHERE ju_articles.related_issue = 1499 AND ju_articles.journal_code = 40 AND ju_articles.article_type >= 0 ORDER BY ju_articles.article_order,ju_articles.page_from,ju_articles.article_code