| 1 | SELECT `Issue`.`id`, `Issue`.`year`, `Issue`.`month`, `Issue`.`volume`, `Issue`.`number`, `Issue`.`cover_file_name`, `Issue`.`editorial_board_file_name`, `Issue`.`half_title_file_name`, `Issue`.`about_file_name`, `Issue`.`instructions_file_name`, `Issue`.`reviewers_file_name`, `Issue`.`toc_file_name`, `Issue`.`full_file_name`, `Issue`.`cover_pdf_file_name`, `Issue`.`published`, `Issue`.`current`, `Issue`.`ahead_of_print`, `Issue`.`supplement`, `Issue`.`article_count`, `Issue`.`position`, `Issue`.`created`, `Issue`.`modified`, (CONCAT(`Issue`.`year`, ', Volume ', `Issue`.`volume`, ', ', IF(`Issue`.`supplement` = 1, 'Supplement', 'Issue'), ' ', `Issue`.`number`)) AS `Issue__title` FROM `tatd_dergi`.`issues` AS `Issue` WHERE `Issue`.`current` = '1' AND `Issue`.`published` = '1' ORDER BY `Issue`.`position` DESC LIMIT 1 | | 1 | 1 | 1 |
| 2 | SELECT `Issue`.`id`, `Issue`.`year`, `Issue`.`month`, `Issue`.`volume`, `Issue`.`number`, `Issue`.`cover_file_name`, `Issue`.`editorial_board_file_name`, `Issue`.`half_title_file_name`, `Issue`.`about_file_name`, `Issue`.`instructions_file_name`, `Issue`.`reviewers_file_name`, `Issue`.`toc_file_name`, `Issue`.`full_file_name`, `Issue`.`cover_pdf_file_name`, `Issue`.`published`, `Issue`.`current`, `Issue`.`ahead_of_print`, `Issue`.`supplement`, `Issue`.`article_count`, `Issue`.`position`, `Issue`.`created`, `Issue`.`modified`, (CONCAT(`Issue`.`year`, ', Volume ', `Issue`.`volume`, ', ', IF(`Issue`.`supplement` = 1, 'Supplement', 'Issue'), ' ', `Issue`.`number`)) AS `Issue__title` FROM `tatd_dergi`.`issues` AS `Issue` WHERE `Issue`.`published` = '1' ORDER BY `Issue`.`year` ASC, `Issue`.`volume` ASC, `Issue`.`number` ASC LIMIT 1 | | 1 | 1 | 1 |
| 3 | SELECT `Article`.`id`, `Article`.`issue_id`, `Article`.`category_id`, `Article`.`language`, `Article`.`title`, `Article`.`authors`, `Article`.`affiliations`, `Article`.`affiliations_tur`, `Article`.`keywords`, `Article`.`abstract`, `Article`.`notes`, `Article`.`body`, `Article`.`body_tur`, `Article`.`references`, `Article`.`conflict_of_interest`, `Article`.`peer_review`, `Article`.`committee_approval`, `Article`.`contributions`, `Article`.`financial_disclosure`, `Article`.`informed_consent`, `Article`.`acknowledgments`, `Article`.`first_page`, `Article`.`last_page`, `Article`.`author_name`, `Article`.`author_email`, `Article`.`author_address`, `Article`.`editor_name`, `Article`.`editor_email`, `Article`.`pdf_file_name`, `Article`.`pdf_tur_file_name`, `Article`.`doi`, `Article`.`pmid`, `Article`.`published`, `Article`.`published_at`, `Article`.`created`, `Article`.`modified`, (IF(`Article`.`last_page` > 0, CONCAT(`Article`.`first_page`, '-', `Article`.`last_page`), `Article`.`first_page`)) AS `Article__pages`, `Issue`.`id`, `Issue`.`year`, `Issue`.`month`, `Issue`.`volume`, `Issue`.`number`, `Issue`.`cover_file_name`, `Issue`.`editorial_board_file_name`, `Issue`.`half_title_file_name`, `Issue`.`about_file_name`, `Issue`.`instructions_file_name`, `Issue`.`reviewers_file_name`, `Issue`.`toc_file_name`, `Issue`.`full_file_name`, `Issue`.`cover_pdf_file_name`, `Issue`.`published`, `Issue`.`current`, `Issue`.`ahead_of_print`, `Issue`.`supplement`, `Issue`.`article_count`, `Issue`.`position`, `Issue`.`created`, `Issue`.`modified`, (CONCAT(`Issue`.`year`, ', Volume ', `Issue`.`volume`, ', ', IF(`Issue`.`supplement` = 1, 'Supplement', 'Issue'), ' ', `Issue`.`number`)) AS `Issue__title` FROM `tatd_dergi`.`articles` AS `Article` LEFT JOIN `tatd_dergi`.`issues` AS `Issue` ON (`Article`.`issue_id` = `Issue`.`id`) WHERE `Article`.`id` = 500 ORDER BY `Article`.`first_page` ASC, `Article`.`last_page` ASC LIMIT 1 | | 1 | 1 | 1 |
| 4 | SELECT `Figure`.`id`, `Figure`.`article_id`, `Figure`.`type`, `Figure`.`title`, `Figure`.`title_tur`, `Figure`.`description`, `Figure`.`description_tur`, `Figure`.`position`, `Figure`.`image_file_name`, `Figure`.`image_tur_file_name`, `Figure`.`created`, `Figure`.`modified` FROM `tatd_dergi`.`images` AS `Figure` WHERE `Figure`.`type` = '0' AND `Figure`.`article_id` = (500) | | 0 | 0 | 1 |
| 5 | SELECT `Table`.`id`, `Table`.`article_id`, `Table`.`type`, `Table`.`title`, `Table`.`title_tur`, `Table`.`description`, `Table`.`description_tur`, `Table`.`position`, `Table`.`image_file_name`, `Table`.`image_tur_file_name`, `Table`.`created`, `Table`.`modified` FROM `tatd_dergi`.`images` AS `Table` WHERE `Table`.`type` = '1' AND `Table`.`article_id` = (500) | | 0 | 0 | 0 |
| 6 | SELECT (SUM(`ArticleLog`.`log_count`)) AS `ArticleLog__total_count` FROM `tatd_dergi`.`article_logs` AS `ArticleLog` WHERE `ArticleLog`.`log_id` = 500 LIMIT 1 | | 1 | 1 | 12 |
| 7 | SELECT (SUM(`PdfLog`.`log_count`)) AS `PdfLog__total_count` FROM `tatd_dergi`.`pdf_logs` AS `PdfLog` WHERE `PdfLog`.`log_id` = 500 LIMIT 1 | | 1 | 1 | 5 |
| 8 | SELECT `Article`.`id`, `Article`.`language`, `Article`.`abstract`, `Article`.`body`, `Article`.`body_tur`, `Article`.`title` FROM `tatd_dergi`.`articles` AS `Article` WHERE `Article`.`published` = '1' AND `Article`.`id` != 500 AND `Article`.`issue_id` = 17 AND `Article`.`first_page` <= 82 AND `Article`.`last_page` <= 85 ORDER BY `Article`.`first_page` DESC, `Article`.`last_page` DESC LIMIT 1 | | 1 | 1 | 1 |
| 9 | SELECT (SUM(`ArticleLog`.`log_count`)) AS `ArticleLog__total_count` FROM `tatd_dergi`.`article_logs` AS `ArticleLog` WHERE `ArticleLog`.`log_id` = 499 LIMIT 1 | | 1 | 1 | 14 |
| 10 | SELECT (SUM(`PdfLog`.`log_count`)) AS `PdfLog__total_count` FROM `tatd_dergi`.`pdf_logs` AS `PdfLog` WHERE `PdfLog`.`log_id` = 499 LIMIT 1 | | 1 | 1 | 6 |
| 11 | SELECT `Article`.`id`, `Article`.`language`, `Article`.`abstract`, `Article`.`body`, `Article`.`body_tur`, `Article`.`title` FROM `tatd_dergi`.`articles` AS `Article` WHERE `Article`.`published` = '1' AND `Article`.`id` != 500 AND `Article`.`issue_id` = 17 AND `Article`.`first_page` >= 82 AND `Article`.`last_page` >= 85 ORDER BY `Article`.`first_page` ASC, `Article`.`last_page` ASC LIMIT 1 | | 1 | 1 | 1 |
| 12 | SELECT (SUM(`ArticleLog`.`log_count`)) AS `ArticleLog__total_count` FROM `tatd_dergi`.`article_logs` AS `ArticleLog` WHERE `ArticleLog`.`log_id` = 501 LIMIT 1 | | 1 | 1 | 11 |
| 13 | SELECT (SUM(`PdfLog`.`log_count`)) AS `PdfLog__total_count` FROM `tatd_dergi`.`pdf_logs` AS `PdfLog` WHERE `PdfLog`.`log_id` = 501 LIMIT 1 | | 1 | 1 | 6 |