Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.abbreviation AS abbreviation_3,
  t0.url AS url_4,
  t0.issn AS issn_5,
  t0.doi AS doi_6,
  t0.ceased AS ceased_7,
  t0.email AS email_8,
  t0.cover_image AS cover_image_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.deleted AS deleted_12,
  t0.deleted_at AS deleted_at_13,
  t0.group_id AS group_id_14,
  t15.id AS id_16,
  t15.name AS name_17,
  t15.created AS created_18,
  t15.updated AS updated_19,
  t15.deleted AS deleted_20,
  t15.deleted_at AS deleted_at_21
FROM
  journals t0
  INNER JOIN journal_groups t15 ON t0.group_id = t15.id
WHERE
  t0.url = ?
  AND t0.deleted = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.abbreviation AS abbreviation_3, t0.url AS url_4, t0.issn AS issn_5, t0.doi AS doi_6, t0.ceased AS ceased_7, t0.email AS email_8, t0.cover_image AS cover_image_9, t0.created AS created_10, t0.updated AS updated_11, t0.deleted AS deleted_12, t0.deleted_at AS deleted_at_13, t0.group_id AS group_id_14, t15.id AS id_16, t15.name AS name_17, t15.created AS created_18, t15.updated AS updated_19, t15.deleted AS deleted_20, t15.deleted_at AS deleted_at_21 FROM journals t0 INNER JOIN journal_groups t15 ON t0.group_id = t15.id WHERE t0.url = 'ijog' AND t0.deleted = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.type AS type_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11
FROM
  pages t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.type AS type_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11 FROM pages t0 WHERE t0.url = 'journal-publication-ethics' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.ordering AS ordering_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.journal_id AS journal_id_12,
  t13.id AS id_14,
  t13.title AS title_15,
  t13.abbreviation AS abbreviation_16,
  t13.url AS url_17,
  t13.issn AS issn_18,
  t13.doi AS doi_19,
  t13.ceased AS ceased_20,
  t13.email AS email_21,
  t13.cover_image AS cover_image_22,
  t13.created AS created_23,
  t13.updated AS updated_24,
  t13.deleted AS deleted_25,
  t13.deleted_at AS deleted_at_26,
  t13.group_id AS group_id_27,
  t0.parent_id AS parent_id_28,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.url AS url_32,
  t29.body AS body_33,
  t29.keywords AS keywords_34,
  t29.description AS description_35,
  t29.ordering AS ordering_36,
  t29.created AS created_37,
  t29.updated AS updated_38,
  t29.deleted AS deleted_39,
  t29.deleted_at AS deleted_at_40,
  t29.journal_id AS journal_id_41,
  t29.parent_id AS parent_id_42
FROM
  journal_pages t0
  INNER JOIN journals t13 ON t0.journal_id = t13.id
  LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id
WHERE
  (
    t0.deleted = ?
    AND t0.journal_id = ?
  )
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.ordering AS ordering_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.journal_id AS journal_id_12, t13.id AS id_14, t13.title AS title_15, t13.abbreviation AS abbreviation_16, t13.url AS url_17, t13.issn AS issn_18, t13.doi AS doi_19, t13.ceased AS ceased_20, t13.email AS email_21, t13.cover_image AS cover_image_22, t13.created AS created_23, t13.updated AS updated_24, t13.deleted AS deleted_25, t13.deleted_at AS deleted_at_26, t13.group_id AS group_id_27, t0.parent_id AS parent_id_28, t29.id AS id_30, t29.title AS title_31, t29.url AS url_32, t29.body AS body_33, t29.keywords AS keywords_34, t29.description AS description_35, t29.ordering AS ordering_36, t29.created AS created_37, t29.updated AS updated_38, t29.deleted AS deleted_39, t29.deleted_at AS deleted_at_40, t29.journal_id AS journal_id_41, t29.parent_id AS parent_id_42 FROM journal_pages t0 INNER JOIN journals t13 ON t0.journal_id = t13.id LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id WHERE (t0.deleted = 0 AND t0.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047') ORDER BY t0.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.ordering AS ordering_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.journal_id AS journal_id_12,
  t13.id AS id_14,
  t13.title AS title_15,
  t13.abbreviation AS abbreviation_16,
  t13.url AS url_17,
  t13.issn AS issn_18,
  t13.doi AS doi_19,
  t13.ceased AS ceased_20,
  t13.email AS email_21,
  t13.cover_image AS cover_image_22,
  t13.created AS created_23,
  t13.updated AS updated_24,
  t13.deleted AS deleted_25,
  t13.deleted_at AS deleted_at_26,
  t13.group_id AS group_id_27,
  t0.parent_id AS parent_id_28,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.url AS url_32,
  t29.body AS body_33,
  t29.keywords AS keywords_34,
  t29.description AS description_35,
  t29.ordering AS ordering_36,
  t29.created AS created_37,
  t29.updated AS updated_38,
  t29.deleted AS deleted_39,
  t29.deleted_at AS deleted_at_40,
  t29.journal_id AS journal_id_41,
  t29.parent_id AS parent_id_42
FROM
  journal_pages t0
  INNER JOIN journals t13 ON t0.journal_id = t13.id
  LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id
WHERE
  (
    t0.deleted = ?
    AND t0.journal_id = ?
  )
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.ordering AS ordering_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.journal_id AS journal_id_12, t13.id AS id_14, t13.title AS title_15, t13.abbreviation AS abbreviation_16, t13.url AS url_17, t13.issn AS issn_18, t13.doi AS doi_19, t13.ceased AS ceased_20, t13.email AS email_21, t13.cover_image AS cover_image_22, t13.created AS created_23, t13.updated AS updated_24, t13.deleted AS deleted_25, t13.deleted_at AS deleted_at_26, t13.group_id AS group_id_27, t0.parent_id AS parent_id_28, t29.id AS id_30, t29.title AS title_31, t29.url AS url_32, t29.body AS body_33, t29.keywords AS keywords_34, t29.description AS description_35, t29.ordering AS ordering_36, t29.created AS created_37, t29.updated AS updated_38, t29.deleted AS deleted_39, t29.deleted_at AS deleted_at_40, t29.journal_id AS journal_id_41, t29.parent_id AS parent_id_42 FROM journal_pages t0 INNER JOIN journals t13 ON t0.journal_id = t13.id LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id WHERE (t0.deleted = 0 AND t0.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047') ORDER BY t0.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.ordering AS ordering_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.journal_id AS journal_id_12,
  t13.id AS id_14,
  t13.title AS title_15,
  t13.abbreviation AS abbreviation_16,
  t13.url AS url_17,
  t13.issn AS issn_18,
  t13.doi AS doi_19,
  t13.ceased AS ceased_20,
  t13.email AS email_21,
  t13.cover_image AS cover_image_22,
  t13.created AS created_23,
  t13.updated AS updated_24,
  t13.deleted AS deleted_25,
  t13.deleted_at AS deleted_at_26,
  t13.group_id AS group_id_27,
  t0.parent_id AS parent_id_28,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.url AS url_32,
  t29.body AS body_33,
  t29.keywords AS keywords_34,
  t29.description AS description_35,
  t29.ordering AS ordering_36,
  t29.created AS created_37,
  t29.updated AS updated_38,
  t29.deleted AS deleted_39,
  t29.deleted_at AS deleted_at_40,
  t29.journal_id AS journal_id_41,
  t29.parent_id AS parent_id_42
FROM
  journal_pages t0
  INNER JOIN journals t13 ON t0.journal_id = t13.id
  LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id
WHERE
  (
    t0.deleted = ?
    AND t0.journal_id = ?
  )
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.ordering AS ordering_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.journal_id AS journal_id_12, t13.id AS id_14, t13.title AS title_15, t13.abbreviation AS abbreviation_16, t13.url AS url_17, t13.issn AS issn_18, t13.doi AS doi_19, t13.ceased AS ceased_20, t13.email AS email_21, t13.cover_image AS cover_image_22, t13.created AS created_23, t13.updated AS updated_24, t13.deleted AS deleted_25, t13.deleted_at AS deleted_at_26, t13.group_id AS group_id_27, t0.parent_id AS parent_id_28, t29.id AS id_30, t29.title AS title_31, t29.url AS url_32, t29.body AS body_33, t29.keywords AS keywords_34, t29.description AS description_35, t29.ordering AS ordering_36, t29.created AS created_37, t29.updated AS updated_38, t29.deleted AS deleted_39, t29.deleted_at AS deleted_at_40, t29.journal_id AS journal_id_41, t29.parent_id AS parent_id_42 FROM journal_pages t0 INNER JOIN journals t13 ON t0.journal_id = t13.id LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id WHERE (t0.deleted = 0 AND t0.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047') ORDER BY t0.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.ordering AS ordering_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.journal_id AS journal_id_12,
  t13.id AS id_14,
  t13.title AS title_15,
  t13.abbreviation AS abbreviation_16,
  t13.url AS url_17,
  t13.issn AS issn_18,
  t13.doi AS doi_19,
  t13.ceased AS ceased_20,
  t13.email AS email_21,
  t13.cover_image AS cover_image_22,
  t13.created AS created_23,
  t13.updated AS updated_24,
  t13.deleted AS deleted_25,
  t13.deleted_at AS deleted_at_26,
  t13.group_id AS group_id_27,
  t0.parent_id AS parent_id_28,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.url AS url_32,
  t29.body AS body_33,
  t29.keywords AS keywords_34,
  t29.description AS description_35,
  t29.ordering AS ordering_36,
  t29.created AS created_37,
  t29.updated AS updated_38,
  t29.deleted AS deleted_39,
  t29.deleted_at AS deleted_at_40,
  t29.journal_id AS journal_id_41,
  t29.parent_id AS parent_id_42
FROM
  journal_pages t0
  INNER JOIN journals t13 ON t0.journal_id = t13.id
  LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id
WHERE
  (
    t0.deleted = ?
    AND t0.journal_id = ?
  )
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.ordering AS ordering_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.journal_id AS journal_id_12, t13.id AS id_14, t13.title AS title_15, t13.abbreviation AS abbreviation_16, t13.url AS url_17, t13.issn AS issn_18, t13.doi AS doi_19, t13.ceased AS ceased_20, t13.email AS email_21, t13.cover_image AS cover_image_22, t13.created AS created_23, t13.updated AS updated_24, t13.deleted AS deleted_25, t13.deleted_at AS deleted_at_26, t13.group_id AS group_id_27, t0.parent_id AS parent_id_28, t29.id AS id_30, t29.title AS title_31, t29.url AS url_32, t29.body AS body_33, t29.keywords AS keywords_34, t29.description AS description_35, t29.ordering AS ordering_36, t29.created AS created_37, t29.updated AS updated_38, t29.deleted AS deleted_39, t29.deleted_at AS deleted_at_40, t29.journal_id AS journal_id_41, t29.parent_id AS parent_id_42 FROM journal_pages t0 INNER JOIN journals t13 ON t0.journal_id = t13.id LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id WHERE (t0.deleted = 0 AND t0.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047') ORDER BY t0.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.ordering AS ordering_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.journal_id AS journal_id_12,
  t13.id AS id_14,
  t13.title AS title_15,
  t13.abbreviation AS abbreviation_16,
  t13.url AS url_17,
  t13.issn AS issn_18,
  t13.doi AS doi_19,
  t13.ceased AS ceased_20,
  t13.email AS email_21,
  t13.cover_image AS cover_image_22,
  t13.created AS created_23,
  t13.updated AS updated_24,
  t13.deleted AS deleted_25,
  t13.deleted_at AS deleted_at_26,
  t13.group_id AS group_id_27,
  t0.parent_id AS parent_id_28,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.url AS url_32,
  t29.body AS body_33,
  t29.keywords AS keywords_34,
  t29.description AS description_35,
  t29.ordering AS ordering_36,
  t29.created AS created_37,
  t29.updated AS updated_38,
  t29.deleted AS deleted_39,
  t29.deleted_at AS deleted_at_40,
  t29.journal_id AS journal_id_41,
  t29.parent_id AS parent_id_42
FROM
  journal_pages t0
  INNER JOIN journals t13 ON t0.journal_id = t13.id
  LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id
WHERE
  (
    t0.deleted = ?
    AND t0.journal_id = ?
  )
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.ordering AS ordering_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.journal_id AS journal_id_12, t13.id AS id_14, t13.title AS title_15, t13.abbreviation AS abbreviation_16, t13.url AS url_17, t13.issn AS issn_18, t13.doi AS doi_19, t13.ceased AS ceased_20, t13.email AS email_21, t13.cover_image AS cover_image_22, t13.created AS created_23, t13.updated AS updated_24, t13.deleted AS deleted_25, t13.deleted_at AS deleted_at_26, t13.group_id AS group_id_27, t0.parent_id AS parent_id_28, t29.id AS id_30, t29.title AS title_31, t29.url AS url_32, t29.body AS body_33, t29.keywords AS keywords_34, t29.description AS description_35, t29.ordering AS ordering_36, t29.created AS created_37, t29.updated AS updated_38, t29.deleted AS deleted_39, t29.deleted_at AS deleted_at_40, t29.journal_id AS journal_id_41, t29.parent_id AS parent_id_42 FROM journal_pages t0 INNER JOIN journals t13 ON t0.journal_id = t13.id LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id WHERE (t0.deleted = 0 AND t0.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047') ORDER BY t0.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.ordering AS ordering_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.journal_id AS journal_id_12,
  t13.id AS id_14,
  t13.title AS title_15,
  t13.abbreviation AS abbreviation_16,
  t13.url AS url_17,
  t13.issn AS issn_18,
  t13.doi AS doi_19,
  t13.ceased AS ceased_20,
  t13.email AS email_21,
  t13.cover_image AS cover_image_22,
  t13.created AS created_23,
  t13.updated AS updated_24,
  t13.deleted AS deleted_25,
  t13.deleted_at AS deleted_at_26,
  t13.group_id AS group_id_27,
  t0.parent_id AS parent_id_28,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.url AS url_32,
  t29.body AS body_33,
  t29.keywords AS keywords_34,
  t29.description AS description_35,
  t29.ordering AS ordering_36,
  t29.created AS created_37,
  t29.updated AS updated_38,
  t29.deleted AS deleted_39,
  t29.deleted_at AS deleted_at_40,
  t29.journal_id AS journal_id_41,
  t29.parent_id AS parent_id_42
FROM
  journal_pages t0
  INNER JOIN journals t13 ON t0.journal_id = t13.id
  LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id
WHERE
  (
    t0.deleted = ?
    AND t0.journal_id = ?
  )
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.ordering AS ordering_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.journal_id AS journal_id_12, t13.id AS id_14, t13.title AS title_15, t13.abbreviation AS abbreviation_16, t13.url AS url_17, t13.issn AS issn_18, t13.doi AS doi_19, t13.ceased AS ceased_20, t13.email AS email_21, t13.cover_image AS cover_image_22, t13.created AS created_23, t13.updated AS updated_24, t13.deleted AS deleted_25, t13.deleted_at AS deleted_at_26, t13.group_id AS group_id_27, t0.parent_id AS parent_id_28, t29.id AS id_30, t29.title AS title_31, t29.url AS url_32, t29.body AS body_33, t29.keywords AS keywords_34, t29.description AS description_35, t29.ordering AS ordering_36, t29.created AS created_37, t29.updated AS updated_38, t29.deleted AS deleted_39, t29.deleted_at AS deleted_at_40, t29.journal_id AS journal_id_41, t29.parent_id AS parent_id_42 FROM journal_pages t0 INNER JOIN journals t13 ON t0.journal_id = t13.id LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id WHERE (t0.deleted = 0 AND t0.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047') ORDER BY t0.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.ordering AS ordering_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.journal_id AS journal_id_12,
  t13.id AS id_14,
  t13.title AS title_15,
  t13.abbreviation AS abbreviation_16,
  t13.url AS url_17,
  t13.issn AS issn_18,
  t13.doi AS doi_19,
  t13.ceased AS ceased_20,
  t13.email AS email_21,
  t13.cover_image AS cover_image_22,
  t13.created AS created_23,
  t13.updated AS updated_24,
  t13.deleted AS deleted_25,
  t13.deleted_at AS deleted_at_26,
  t13.group_id AS group_id_27,
  t0.parent_id AS parent_id_28,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.url AS url_32,
  t29.body AS body_33,
  t29.keywords AS keywords_34,
  t29.description AS description_35,
  t29.ordering AS ordering_36,
  t29.created AS created_37,
  t29.updated AS updated_38,
  t29.deleted AS deleted_39,
  t29.deleted_at AS deleted_at_40,
  t29.journal_id AS journal_id_41,
  t29.parent_id AS parent_id_42
FROM
  journal_pages t0
  INNER JOIN journals t13 ON t0.journal_id = t13.id
  LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id
WHERE
  (
    t0.deleted = ?
    AND t0.journal_id = ?
  )
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.ordering AS ordering_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.journal_id AS journal_id_12, t13.id AS id_14, t13.title AS title_15, t13.abbreviation AS abbreviation_16, t13.url AS url_17, t13.issn AS issn_18, t13.doi AS doi_19, t13.ceased AS ceased_20, t13.email AS email_21, t13.cover_image AS cover_image_22, t13.created AS created_23, t13.updated AS updated_24, t13.deleted AS deleted_25, t13.deleted_at AS deleted_at_26, t13.group_id AS group_id_27, t0.parent_id AS parent_id_28, t29.id AS id_30, t29.title AS title_31, t29.url AS url_32, t29.body AS body_33, t29.keywords AS keywords_34, t29.description AS description_35, t29.ordering AS ordering_36, t29.created AS created_37, t29.updated AS updated_38, t29.deleted AS deleted_39, t29.deleted_at AS deleted_at_40, t29.journal_id AS journal_id_41, t29.parent_id AS parent_id_42 FROM journal_pages t0 INNER JOIN journals t13 ON t0.journal_id = t13.id LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id WHERE (t0.deleted = 0 AND t0.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047') ORDER BY t0.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.ordering AS ordering_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.journal_id AS journal_id_12,
  t13.id AS id_14,
  t13.title AS title_15,
  t13.abbreviation AS abbreviation_16,
  t13.url AS url_17,
  t13.issn AS issn_18,
  t13.doi AS doi_19,
  t13.ceased AS ceased_20,
  t13.email AS email_21,
  t13.cover_image AS cover_image_22,
  t13.created AS created_23,
  t13.updated AS updated_24,
  t13.deleted AS deleted_25,
  t13.deleted_at AS deleted_at_26,
  t13.group_id AS group_id_27,
  t0.parent_id AS parent_id_28,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.url AS url_32,
  t29.body AS body_33,
  t29.keywords AS keywords_34,
  t29.description AS description_35,
  t29.ordering AS ordering_36,
  t29.created AS created_37,
  t29.updated AS updated_38,
  t29.deleted AS deleted_39,
  t29.deleted_at AS deleted_at_40,
  t29.journal_id AS journal_id_41,
  t29.parent_id AS parent_id_42
FROM
  journal_pages t0
  INNER JOIN journals t13 ON t0.journal_id = t13.id
  LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id
WHERE
  (
    t0.deleted = ?
    AND t0.journal_id = ?
  )
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.ordering AS ordering_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.journal_id AS journal_id_12, t13.id AS id_14, t13.title AS title_15, t13.abbreviation AS abbreviation_16, t13.url AS url_17, t13.issn AS issn_18, t13.doi AS doi_19, t13.ceased AS ceased_20, t13.email AS email_21, t13.cover_image AS cover_image_22, t13.created AS created_23, t13.updated AS updated_24, t13.deleted AS deleted_25, t13.deleted_at AS deleted_at_26, t13.group_id AS group_id_27, t0.parent_id AS parent_id_28, t29.id AS id_30, t29.title AS title_31, t29.url AS url_32, t29.body AS body_33, t29.keywords AS keywords_34, t29.description AS description_35, t29.ordering AS ordering_36, t29.created AS created_37, t29.updated AS updated_38, t29.deleted AS deleted_39, t29.deleted_at AS deleted_at_40, t29.journal_id AS journal_id_41, t29.parent_id AS parent_id_42 FROM journal_pages t0 INNER JOIN journals t13 ON t0.journal_id = t13.id LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id WHERE (t0.deleted = 0 AND t0.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047') ORDER BY t0.ordering ASC;