Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sortorder AS sortorder_3,
  t0.version AS version_4,
  t0.content_id AS content_id_5,
  t6.id AS id_7,
  t6.content_type AS content_type_8,
  t6.status AS status_9,
  t6.created_at AS created_at_10,
  t6.modified_at AS modified_at_11,
  t6.published_at AS published_at_12,
  t6.depublished_at AS depublished_at_13,
  t6.title AS title_14,
  t6.list_format AS list_format_15,
  t6.author_id AS author_id_16,
  t0.parent_id AS parent_id_17,
  t0.type
FROM
  bolt_field t0
  INNER JOIN bolt_content t6 ON t0.content_id = t6.id
WHERE
  t0.content_id = ?
  AND t0.type IN (
    'generic', 'select', 'number', 'email',
    'set', 'templateselect', 'embed',
    'markdown', 'checkbox', 'filelist',
    'imagelist', 'date', 'file', 'html',
    'data', 'image', 'hidden', 'textarea',
    'slug', 'text', 'block', 'collection',
    'article', 'redactor'
  )
ORDER BY
  t0.sortorder ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = 41 AND t0.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') ORDER BY t0.sortorder ASC;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  bolt_field_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = 881;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      LOWER(value_14)
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.content_type AS content_type_1,
          b0_.status AS status_2,
          b0_.created_at AS created_at_3,
          b0_.modified_at AS modified_at_4,
          b0_.published_at AS published_at_5,
          b0_.depublished_at AS depublished_at_6,
          b0_.title AS title_7,
          b0_.list_format AS list_format_8,
          b1_.id AS id_9,
          b1_.name AS name_10,
          b1_.sortorder AS sortorder_11,
          b1_.version AS version_12,
          b2_.id AS id_13,
          b2_.value AS value_14,
          b2_.locale AS locale_15,
          b1_.type AS type_16
        FROM
          bolt_content b0_
          LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
          AND b1_.type IN (
            'generic', 'select', 'number', 'email',
            'set', 'templateselect', 'embed',
            'markdown', 'checkbox', 'filelist',
            'imagelist', 'date', 'file', 'html',
            'data', 'image', 'hidden', 'textarea',
            'slug', 'text', 'block', 'collection',
            'article', 'redactor'
          )
          LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
        WHERE
          b0_.content_type = ?
          AND b0_.status = ?
          AND b1_.name = ?
        ORDER BY
          b1_.sortorder ASC
      ) dctrn_result_inner
    ORDER BY
      LOWER(value_14) ASC
  ) dctrn_result
LIMIT
  1

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, LOWER(value_14) FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b1_.id AS id_9, b1_.name AS name_10, b1_.sortorder AS sortorder_11, b1_.version AS version_12, b2_.id AS id_13, b2_.value AS value_14, b2_.locale AS locale_15, b1_.type AS type_16 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'knipsels' AND b0_.status = 'published' AND b1_.name = 'date' ORDER BY b1_.sortorder ASC) dctrn_result_inner ORDER BY LOWER(value_14) ASC) dctrn_result LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.content_type AS content_type_1,
          b0_.status AS status_2,
          b0_.created_at AS created_at_3,
          b0_.modified_at AS modified_at_4,
          b0_.published_at AS published_at_5,
          b0_.depublished_at AS depublished_at_6,
          b0_.title AS title_7,
          b0_.list_format AS list_format_8
        FROM
          bolt_content b0_
          LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
          AND b1_.type IN (
            'generic', 'select', 'number', 'email',
            'set', 'templateselect', 'embed',
            'markdown', 'checkbox', 'filelist',
            'imagelist', 'date', 'file', 'html',
            'data', 'image', 'hidden', 'textarea',
            'slug', 'text', 'block', 'collection',
            'article', 'redactor'
          )
          LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
        WHERE
          b0_.content_type = ?
          AND (
            (
              (
                b2_.value >= ?
                AND b2_.value <= ?
              )
              AND b1_.parent_id IS NULL
              AND b1_.name = ?
            )
            AND b0_.status = ?
          )
        ORDER BY
          b0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'knipsels' AND (((b2_.value >= '[\"2016-01-01 00:00\"]' AND b2_.value <= '[\"2016-12-31 00:00\"]') AND b1_.parent_id IS NULL AND b1_.name = 'date') AND b0_.status = 'published') ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      LOWER(value_14)
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.content_type AS content_type_1,
          b0_.status AS status_2,
          b0_.created_at AS created_at_3,
          b0_.modified_at AS modified_at_4,
          b0_.published_at AS published_at_5,
          b0_.depublished_at AS depublished_at_6,
          b0_.title AS title_7,
          b0_.list_format AS list_format_8,
          b1_.id AS id_9,
          b1_.name AS name_10,
          b1_.sortorder AS sortorder_11,
          b1_.version AS version_12,
          b2_.id AS id_13,
          b2_.value AS value_14,
          b2_.locale AS locale_15,
          b1_.type AS type_16
        FROM
          bolt_content b0_
          LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
          AND b1_.type IN (
            'generic', 'select', 'number', 'email',
            'set', 'templateselect', 'embed',
            'markdown', 'checkbox', 'filelist',
            'imagelist', 'date', 'file', 'html',
            'data', 'image', 'hidden', 'textarea',
            'slug', 'text', 'block', 'collection',
            'article', 'redactor'
          )
          LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
        WHERE
          b0_.content_type = ?
          AND b0_.status = ?
          AND b1_.name = ?
        ORDER BY
          b1_.sortorder ASC
      ) dctrn_result_inner
    ORDER BY
      LOWER(value_14) ASC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, LOWER(value_14) FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b1_.id AS id_9, b1_.name AS name_10, b1_.sortorder AS sortorder_11, b1_.version AS version_12, b2_.id AS id_13, b2_.value AS value_14, b2_.locale AS locale_15, b1_.type AS type_16 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'knipsels' AND b0_.status = 'published' AND b1_.name = 'date' ORDER BY b1_.sortorder ASC) dctrn_result_inner ORDER BY LOWER(value_14) ASC) dctrn_result LIMIT 50;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.content_type AS content_type_1,
          b0_.status AS status_2,
          b0_.created_at AS created_at_3,
          b0_.modified_at AS modified_at_4,
          b0_.published_at AS published_at_5,
          b0_.depublished_at AS depublished_at_6,
          b0_.title AS title_7,
          b0_.list_format AS list_format_8
        FROM
          bolt_content b0_
          LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
          AND b1_.type IN (
            'generic', 'select', 'number', 'email',
            'set', 'templateselect', 'embed',
            'markdown', 'checkbox', 'filelist',
            'imagelist', 'date', 'file', 'html',
            'data', 'image', 'hidden', 'textarea',
            'slug', 'text', 'block', 'collection',
            'article', 'redactor'
          )
          LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
        WHERE
          b0_.content_type = ?
          AND b0_.status = ?
          AND b1_.name = ?
        ORDER BY
          LOWER(b2_.value) ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'knipsels' AND b0_.status = 'published' AND b1_.name = 'date' ORDER BY LOWER(b2_.value) ASC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.slug AS slug_3,
  t0.name AS name_4,
  t0.sortorder AS sortorder_5
FROM
  bolt_taxonomy t0
  INNER JOIN bolt_taxonomy_content ON t0.id = bolt_taxonomy_content.taxonomy_id
WHERE
  bolt_taxonomy_content.content_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.slug AS slug_3, t0.name AS name_4, t0.sortorder AS sortorder_5 FROM bolt_taxonomy t0 INNER JOIN bolt_taxonomy_content ON t0.id = bolt_taxonomy_content.taxonomy_id WHERE bolt_taxonomy_content.content_id = 213;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_5
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.content_type AS content_type_1,
          b0_.status AS status_2,
          b0_.created_at AS created_at_3,
          b0_.modified_at AS modified_at_4,
          b0_.published_at AS published_at_5,
          b0_.depublished_at AS depublished_at_6,
          b0_.title AS title_7,
          b0_.list_format AS list_format_8,
          b1_.id AS id_9,
          b1_.value AS value_10,
          b1_.locale AS locale_11,
          b2_.id AS id_12,
          b2_.name AS name_13,
          b2_.sortorder AS sortorder_14,
          b2_.version AS version_15,
          b2_.type AS type_16
        FROM
          bolt_content b0_
          LEFT JOIN bolt_field b2_ ON b0_.id = b2_.content_id
          AND b2_.type IN (
            'generic', 'select', 'number', 'email',
            'set', 'templateselect', 'embed',
            'markdown', 'checkbox', 'filelist',
            'imagelist', 'date', 'file', 'html',
            'data', 'image', 'hidden', 'textarea',
            'slug', 'text', 'block', 'collection',
            'article', 'redactor'
          )
          LEFT JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id
        WHERE
          b0_.content_type = ?
          AND (
            (
              (
                b1_.value >= ?
                AND b1_.value <= ?
              )
              AND b2_.parent_id IS NULL
              AND b2_.name = ?
            )
            AND b0_.status = ?
          )
        ORDER BY
          b2_.sortorder ASC
      ) dctrn_result_inner
    ORDER BY
      published_at_5 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b1_.id AS id_9, b1_.value AS value_10, b1_.locale AS locale_11, b2_.id AS id_12, b2_.name AS name_13, b2_.sortorder AS sortorder_14, b2_.version AS version_15, b2_.type AS type_16 FROM bolt_content b0_ LEFT JOIN bolt_field b2_ ON b0_.id = b2_.content_id AND b2_.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') LEFT JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id WHERE b0_.content_type = 'knipsels' AND (((b1_.value >= '[\"2016-01-01 00:00\"]' AND b1_.value <= '[\"2016-12-31 00:00\"]') AND b2_.parent_id IS NULL AND b2_.name = 'date') AND b0_.status = 'published') ORDER BY b2_.sortorder ASC) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 20;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_5
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.content_type AS content_type_1,
          b0_.status AS status_2,
          b0_.created_at AS created_at_3,
          b0_.modified_at AS modified_at_4,
          b0_.published_at AS published_at_5,
          b0_.depublished_at AS depublished_at_6,
          b0_.title AS title_7,
          b0_.list_format AS list_format_8,
          b1_.id AS id_9,
          b1_.value AS value_10,
          b1_.locale AS locale_11,
          b2_.id AS id_12,
          b2_.name AS name_13,
          b2_.sortorder AS sortorder_14,
          b2_.version AS version_15,
          b2_.type AS type_16
        FROM
          bolt_content b0_
          LEFT JOIN bolt_field b2_ ON b0_.id = b2_.content_id
          AND b2_.type IN (
            'generic', 'select', 'number', 'email',
            'set', 'templateselect', 'embed',
            'markdown', 'checkbox', 'filelist',
            'imagelist', 'date', 'file', 'html',
            'data', 'image', 'hidden', 'textarea',
            'slug', 'text', 'block', 'collection',
            'article', 'redactor'
          )
          LEFT JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id
        WHERE
          b0_.content_type = ?
          AND (
            (
              (
                b1_.value >= ?
                AND b1_.value <= ?
              )
              AND b2_.parent_id IS NULL
              AND b2_.name = ?
            )
            AND b0_.status = ?
          )
        ORDER BY
          b2_.sortorder ASC
      ) dctrn_result_inner
    ORDER BY
      published_at_5 DESC
  ) dctrn_result
LIMIT
  1

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b1_.id AS id_9, b1_.value AS value_10, b1_.locale AS locale_11, b2_.id AS id_12, b2_.name AS name_13, b2_.sortorder AS sortorder_14, b2_.version AS version_15, b2_.type AS type_16 FROM bolt_content b0_ LEFT JOIN bolt_field b2_ ON b0_.id = b2_.content_id AND b2_.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') LEFT JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id WHERE b0_.content_type = 'knipsels' AND (((b1_.value >= '[\"2016-01-01 00:00\"]' AND b1_.value <= '[\"2016-12-31 00:00\"]') AND b2_.parent_id IS NULL AND b2_.name = 'date') AND b0_.status = 'published') ORDER BY b2_.sortorder ASC) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.content_type AS content_type_1,
  b0_.status AS status_2,
  b0_.created_at AS created_at_3,
  b0_.modified_at AS modified_at_4,
  b0_.published_at AS published_at_5,
  b0_.depublished_at AS depublished_at_6,
  b0_.title AS title_7,
  b0_.list_format AS list_format_8,
  b0_.author_id AS author_id_9
FROM
  bolt_content b0_
  LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
  AND b1_.type IN (
    'generic', 'select', 'number', 'email',
    'set', 'templateselect', 'embed',
    'markdown', 'checkbox', 'filelist',
    'imagelist', 'date', 'file', 'html',
    'data', 'image', 'hidden', 'textarea',
    'slug', 'text', 'block', 'collection',
    'article', 'redactor'
  )
  LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
WHERE
  b0_.content_type = ?
  AND b0_.status = ?
  AND b1_.name = ?
  AND b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  LOWER(b2_.value) ASC

SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'knipsels' AND b0_.status = 'published' AND b1_.name = 'date' AND b0_.id IN (41, 42, 43, 44, 45, 46, 193, 47, 48, 194, 49, 50, 51, 192, 52, 53, 54, 55, 56, 57, 195, 58, 59, 60, 61, 62, 63, 196, 222, 64, 65, 66, 67, 197, 68, 198, 69, 70, 71, 199, 72, 73, 74, 75, 76, 77, 200, 78, 79, 80) ORDER BY LOWER(b2_.value) ASC;

SELECT
  b0_.id AS id_0,
  b0_.content_type AS content_type_1,
  b0_.status AS status_2,
  b0_.created_at AS created_at_3,
  b0_.modified_at AS modified_at_4,
  b0_.published_at AS published_at_5,
  b0_.depublished_at AS depublished_at_6,
  b0_.title AS title_7,
  b0_.list_format AS list_format_8,
  b0_.author_id AS author_id_9
FROM
  bolt_content b0_
  LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
  AND b1_.type IN (
    'generic', 'select', 'number', 'email',
    'set', 'templateselect', 'embed',
    'markdown', 'checkbox', 'filelist',
    'imagelist', 'date', 'file', 'html',
    'data', 'image', 'hidden', 'textarea',
    'slug', 'text', 'block', 'collection',
    'article', 'redactor'
  )
  LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
WHERE
  b0_.content_type = ?
  AND (
    (
      (
        b2_.value >= ?
        AND b2_.value <= ?
      )
      AND b1_.parent_id IS NULL
      AND b1_.name = ?
    )
    AND b0_.status = ?
  )
  AND b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  b0_.published_at DESC

SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'knipsels' AND (((b2_.value >= '[\"2016-01-01 00:00\"]' AND b2_.value <= '[\"2016-12-31 00:00\"]') AND b1_.parent_id IS NULL AND b1_.name = 'date') AND b0_.status = 'published') AND b0_.id IN (213, 214, 215, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 90) ORDER BY b0_.published_at DESC;

SELECT
  b0_.id AS id_0,
  b0_.content_type AS content_type_1,
  b0_.status AS status_2,
  b0_.created_at AS created_at_3,
  b0_.modified_at AS modified_at_4,
  b0_.published_at AS published_at_5,
  b0_.depublished_at AS depublished_at_6,
  b0_.title AS title_7,
  b0_.list_format AS list_format_8,
  b0_.author_id AS author_id_9
FROM
  bolt_content b0_
  LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
  AND b1_.type IN (
    'generic', 'select', 'number', 'email',
    'set', 'templateselect', 'embed',
    'markdown', 'checkbox', 'filelist',
    'imagelist', 'date', 'file', 'html',
    'data', 'image', 'hidden', 'textarea',
    'slug', 'text', 'block', 'collection',
    'article', 'redactor'
  )
  LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
WHERE
  b0_.content_type = ?
  AND b0_.status = ?
  AND b1_.name = ?
  AND b0_.id IN (?)
ORDER BY
  LOWER(b2_.value) ASC

SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'knipsels' AND b0_.status = 'published' AND b1_.name = 'date' AND b0_.id IN (41) ORDER BY LOWER(b2_.value) ASC;

SELECT
  b0_.id AS id_0,
  b0_.content_type AS content_type_1,
  b0_.status AS status_2,
  b0_.created_at AS created_at_3,
  b0_.modified_at AS modified_at_4,
  b0_.published_at AS published_at_5,
  b0_.depublished_at AS depublished_at_6,
  b0_.title AS title_7,
  b0_.list_format AS list_format_8,
  b0_.author_id AS author_id_9
FROM
  bolt_content b0_
  LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
  AND b1_.type IN (
    'generic', 'select', 'number', 'email',
    'set', 'templateselect', 'embed',
    'markdown', 'checkbox', 'filelist',
    'imagelist', 'date', 'file', 'html',
    'data', 'image', 'hidden', 'textarea',
    'slug', 'text', 'block', 'collection',
    'article', 'redactor'
  )
  LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
WHERE
  b0_.content_type = ?
  AND (
    (
      (
        b2_.value >= ?
        AND b2_.value <= ?
      )
      AND b1_.parent_id IS NULL
      AND b1_.name = ?
    )
    AND b0_.status = ?
  )
  AND b0_.id IN (?)
ORDER BY
  b0_.published_at DESC

SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'number', 'email', 'set', 'templateselect', 'embed', 'markdown', 'checkbox', 'filelist', 'imagelist', 'date', 'file', 'html', 'data', 'image', 'hidden', 'textarea', 'slug', 'text', 'block', 'collection', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'knipsels' AND (((b2_.value >= '[\"2016-01-01 00:00\"]' AND b2_.value <= '[\"2016-12-31 00:00\"]') AND b1_.parent_id IS NULL AND b1_.name = 'date') AND b0_.status = 'published') AND b0_.id IN (213) ORDER BY b0_.published_at DESC;