Symfony Profiler

SELECT 
  COUNT(*) count 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject`.`id` IN (
        SELECT 
          `contentobject_id` 
        FROM 
          `ezcontentobject_attribute` 
        WHERE 
          (
            `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` 
            AND (
              `contentclassattribute_id` IN ('4', '6', '116', '146', '413') 
              AND `sort_key_string` = : placeholder2
            ) 
            AND (
              `ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
            ) > : placeholder3
          )
      ) 
      AND `ezcontentobject`.`contentclass_id` IN (1) 
      AND `ezcontentobject_tree`.`parent_node_id` IN (2384) 
      AND `ezcontentobject_tree`.`is_invisible` = : placeholder4 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder5 
  AND ezcontentobject_version.status = : placeholder6 
  AND `ezcontentobject_tree`.`depth` <> : placeholder7

SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 2384 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7;

SELECT 
  ezcontentobject_tree.*, 
  `ezcontentobject`.`language_mask`, 
  `ezcontentobject`.`initial_language_id`, 
  `ezcontentobject_tree`.`priority` `sort_column_0` 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`parent_node_id` IN (2385) 
      AND `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND NOT (
        `ezcontentobject`.`contentclass_id` IN (1)
      ) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5 
ORDER BY 
  `sort_column_0` ASC 
LIMIT 
  25

SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`parent_node_id` IN ( 2385 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;

SELECT 
  ezcontentobject_tree.*, 
  `ezcontentobject`.`language_mask`, 
  `ezcontentobject`.`initial_language_id` 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject`.`id` IN (
        SELECT 
          `contentobject_id` 
        FROM 
          `ezcontentobject_attribute` 
        WHERE 
          (
            `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` 
            AND (
              `contentclassattribute_id` IN ('4', '6', '116', '146', '413') 
              AND `sort_key_string` = : placeholder2
            ) 
            AND (
              `ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
            ) > : placeholder3
          )
      ) 
      AND `ezcontentobject`.`contentclass_id` IN (1) 
      AND `ezcontentobject_tree`.`parent_node_id` IN (2384) 
      AND `ezcontentobject_tree`.`is_invisible` = : placeholder4 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder5 
  AND ezcontentobject_version.status = : placeholder6 
  AND `ezcontentobject_tree`.`depth` <> : placeholder7 
LIMIT 
  25

SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 2384 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7 LIMIT 25;

SELECT 
  COUNT(*) count 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`parent_node_id` IN (2385) 
      AND `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND NOT (
        `ezcontentobject`.`contentclass_id` IN (1)
      ) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5

SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`parent_node_id` IN ( 2385 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;

SELECT 
  COUNT(*) count 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      (
        `ezcontentobject`.`contentclass_id` IN (35) 
        OR `ezcontentobject`.`contentclass_id` IN (37) 
        OR `ezcontentobject`.`contentclass_id` IN (38) 
        OR `ezcontentobject`.`contentclass_id` IN (39) 
        OR `ezcontentobject`.`contentclass_id` IN (40) 
        OR `ezcontentobject`.`contentclass_id` IN (46) 
        OR `ezcontentobject`.`contentclass_id` IN (14) 
        OR `ezcontentobject`.`contentclass_id` IN (16) 
        OR `ezcontentobject`.`contentclass_id` IN (15) 
        OR `ezcontentobject`.`contentclass_id` IN (17) 
        OR `ezcontentobject`.`contentclass_id` IN (25) 
        OR `ezcontentobject`.`contentclass_id` IN (43) 
        OR `ezcontentobject`.`contentclass_id` IN (23) 
        OR `ezcontentobject`.`contentclass_id` IN (24) 
        OR `ezcontentobject`.`contentclass_id` IN (27) 
        OR `ezcontentobject`.`contentclass_id` IN (33) 
        OR `ezcontentobject`.`contentclass_id` IN (41) 
        OR `ezcontentobject`.`contentclass_id` IN (45) 
        OR `ezcontentobject`.`contentclass_id` IN (34) 
        OR `ezcontentobject`.`contentclass_id` IN (44) 
        OR `ezcontentobject`.`contentclass_id` IN (26) 
        OR `ezcontentobject`.`contentclass_id` IN (36)
      ) 
      AND `ezcontentobject_tree`.`parent_node_id` IN (2401) 
      AND `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND NOT (
        `ezcontentobject`.`contentclass_id` IN (1)
      ) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5

SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( ( `ezcontentobject`.`contentclass_id` IN ( 35 ) OR `ezcontentobject`.`contentclass_id` IN ( 37 ) OR `ezcontentobject`.`contentclass_id` IN ( 38 ) OR `ezcontentobject`.`contentclass_id` IN ( 39 ) OR `ezcontentobject`.`contentclass_id` IN ( 40 ) OR `ezcontentobject`.`contentclass_id` IN ( 46 ) OR `ezcontentobject`.`contentclass_id` IN ( 14 ) OR `ezcontentobject`.`contentclass_id` IN ( 16 ) OR `ezcontentobject`.`contentclass_id` IN ( 15 ) OR `ezcontentobject`.`contentclass_id` IN ( 17 ) OR `ezcontentobject`.`contentclass_id` IN ( 25 ) OR `ezcontentobject`.`contentclass_id` IN ( 43 ) OR `ezcontentobject`.`contentclass_id` IN ( 23 ) OR `ezcontentobject`.`contentclass_id` IN ( 24 ) OR `ezcontentobject`.`contentclass_id` IN ( 27 ) OR `ezcontentobject`.`contentclass_id` IN ( 33 ) OR `ezcontentobject`.`contentclass_id` IN ( 41 ) OR `ezcontentobject`.`contentclass_id` IN ( 45 ) OR `ezcontentobject`.`contentclass_id` IN ( 34 ) OR `ezcontentobject`.`contentclass_id` IN ( 44 ) OR `ezcontentobject`.`contentclass_id` IN ( 26 ) OR `ezcontentobject`.`contentclass_id` IN ( 36 ) ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 2401 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;

SELECT 
  ezcontentobject_tree.*, 
  `ezcontentobject`.`language_mask`, 
  `ezcontentobject`.`initial_language_id`, 
  `ezcontentobject_tree`.`priority` `sort_column_0` 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      (
        `ezcontentobject`.`contentclass_id` IN (35) 
        OR `ezcontentobject`.`contentclass_id` IN (37) 
        OR `ezcontentobject`.`contentclass_id` IN (38) 
        OR `ezcontentobject`.`contentclass_id` IN (39) 
        OR `ezcontentobject`.`contentclass_id` IN (40) 
        OR `ezcontentobject`.`contentclass_id` IN (46) 
        OR `ezcontentobject`.`contentclass_id` IN (14) 
        OR `ezcontentobject`.`contentclass_id` IN (16) 
        OR `ezcontentobject`.`contentclass_id` IN (15) 
        OR `ezcontentobject`.`contentclass_id` IN (17) 
        OR `ezcontentobject`.`contentclass_id` IN (25) 
        OR `ezcontentobject`.`contentclass_id` IN (43) 
        OR `ezcontentobject`.`contentclass_id` IN (23) 
        OR `ezcontentobject`.`contentclass_id` IN (24) 
        OR `ezcontentobject`.`contentclass_id` IN (27) 
        OR `ezcontentobject`.`contentclass_id` IN (33) 
        OR `ezcontentobject`.`contentclass_id` IN (41) 
        OR `ezcontentobject`.`contentclass_id` IN (45) 
        OR `ezcontentobject`.`contentclass_id` IN (34) 
        OR `ezcontentobject`.`contentclass_id` IN (44) 
        OR `ezcontentobject`.`contentclass_id` IN (26) 
        OR `ezcontentobject`.`contentclass_id` IN (36)
      ) 
      AND `ezcontentobject_tree`.`parent_node_id` IN (2401) 
      AND `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND NOT (
        `ezcontentobject`.`contentclass_id` IN (1)
      ) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5 
ORDER BY 
  `sort_column_0` ASC 
LIMIT 
  25

SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( ( `ezcontentobject`.`contentclass_id` IN ( 35 ) OR `ezcontentobject`.`contentclass_id` IN ( 37 ) OR `ezcontentobject`.`contentclass_id` IN ( 38 ) OR `ezcontentobject`.`contentclass_id` IN ( 39 ) OR `ezcontentobject`.`contentclass_id` IN ( 40 ) OR `ezcontentobject`.`contentclass_id` IN ( 46 ) OR `ezcontentobject`.`contentclass_id` IN ( 14 ) OR `ezcontentobject`.`contentclass_id` IN ( 16 ) OR `ezcontentobject`.`contentclass_id` IN ( 15 ) OR `ezcontentobject`.`contentclass_id` IN ( 17 ) OR `ezcontentobject`.`contentclass_id` IN ( 25 ) OR `ezcontentobject`.`contentclass_id` IN ( 43 ) OR `ezcontentobject`.`contentclass_id` IN ( 23 ) OR `ezcontentobject`.`contentclass_id` IN ( 24 ) OR `ezcontentobject`.`contentclass_id` IN ( 27 ) OR `ezcontentobject`.`contentclass_id` IN ( 33 ) OR `ezcontentobject`.`contentclass_id` IN ( 41 ) OR `ezcontentobject`.`contentclass_id` IN ( 45 ) OR `ezcontentobject`.`contentclass_id` IN ( 34 ) OR `ezcontentobject`.`contentclass_id` IN ( 44 ) OR `ezcontentobject`.`contentclass_id` IN ( 26 ) OR `ezcontentobject`.`contentclass_id` IN ( 36 ) ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 2401 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;

SELECT 
  COUNT(*) count 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      (
        `ezcontentobject`.`contentclass_id` IN (35) 
        OR `ezcontentobject`.`contentclass_id` IN (37) 
        OR `ezcontentobject`.`contentclass_id` IN (38) 
        OR `ezcontentobject`.`contentclass_id` IN (39) 
        OR `ezcontentobject`.`contentclass_id` IN (40) 
        OR `ezcontentobject`.`contentclass_id` IN (46) 
        OR `ezcontentobject`.`contentclass_id` IN (14) 
        OR `ezcontentobject`.`contentclass_id` IN (16) 
        OR `ezcontentobject`.`contentclass_id` IN (15) 
        OR `ezcontentobject`.`contentclass_id` IN (17) 
        OR `ezcontentobject`.`contentclass_id` IN (25) 
        OR `ezcontentobject`.`contentclass_id` IN (43) 
        OR `ezcontentobject`.`contentclass_id` IN (23) 
        OR `ezcontentobject`.`contentclass_id` IN (24) 
        OR `ezcontentobject`.`contentclass_id` IN (27) 
        OR `ezcontentobject`.`contentclass_id` IN (33) 
        OR `ezcontentobject`.`contentclass_id` IN (41) 
        OR `ezcontentobject`.`contentclass_id` IN (45) 
        OR `ezcontentobject`.`contentclass_id` IN (34) 
        OR `ezcontentobject`.`contentclass_id` IN (44) 
        OR `ezcontentobject`.`contentclass_id` IN (26) 
        OR `ezcontentobject`.`contentclass_id` IN (36)
      ) 
      AND `ezcontentobject_tree`.`parent_node_id` IN (2413) 
      AND `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND NOT (
        `ezcontentobject`.`contentclass_id` IN (1)
      ) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5

SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( ( `ezcontentobject`.`contentclass_id` IN ( 35 ) OR `ezcontentobject`.`contentclass_id` IN ( 37 ) OR `ezcontentobject`.`contentclass_id` IN ( 38 ) OR `ezcontentobject`.`contentclass_id` IN ( 39 ) OR `ezcontentobject`.`contentclass_id` IN ( 40 ) OR `ezcontentobject`.`contentclass_id` IN ( 46 ) OR `ezcontentobject`.`contentclass_id` IN ( 14 ) OR `ezcontentobject`.`contentclass_id` IN ( 16 ) OR `ezcontentobject`.`contentclass_id` IN ( 15 ) OR `ezcontentobject`.`contentclass_id` IN ( 17 ) OR `ezcontentobject`.`contentclass_id` IN ( 25 ) OR `ezcontentobject`.`contentclass_id` IN ( 43 ) OR `ezcontentobject`.`contentclass_id` IN ( 23 ) OR `ezcontentobject`.`contentclass_id` IN ( 24 ) OR `ezcontentobject`.`contentclass_id` IN ( 27 ) OR `ezcontentobject`.`contentclass_id` IN ( 33 ) OR `ezcontentobject`.`contentclass_id` IN ( 41 ) OR `ezcontentobject`.`contentclass_id` IN ( 45 ) OR `ezcontentobject`.`contentclass_id` IN ( 34 ) OR `ezcontentobject`.`contentclass_id` IN ( 44 ) OR `ezcontentobject`.`contentclass_id` IN ( 26 ) OR `ezcontentobject`.`contentclass_id` IN ( 36 ) ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 2413 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;

SELECT 
  COUNT(*) count 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND `ezcontentobject`.`contentclass_id` IN (18) 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND `ezcontentobject_tree`.`parent_node_id` IN (2384) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5

SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 18 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 2384 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;

SELECT 
  ezcontentobject_tree.*, 
  `ezcontentobject`.`language_mask`, 
  `ezcontentobject`.`initial_language_id`, 
  `ezcontentobject_tree`.`priority` `sort_column_0` 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      (
        `ezcontentobject`.`contentclass_id` IN (35) 
        OR `ezcontentobject`.`contentclass_id` IN (37) 
        OR `ezcontentobject`.`contentclass_id` IN (38) 
        OR `ezcontentobject`.`contentclass_id` IN (39) 
        OR `ezcontentobject`.`contentclass_id` IN (40) 
        OR `ezcontentobject`.`contentclass_id` IN (46) 
        OR `ezcontentobject`.`contentclass_id` IN (14) 
        OR `ezcontentobject`.`contentclass_id` IN (16) 
        OR `ezcontentobject`.`contentclass_id` IN (15) 
        OR `ezcontentobject`.`contentclass_id` IN (17) 
        OR `ezcontentobject`.`contentclass_id` IN (25) 
        OR `ezcontentobject`.`contentclass_id` IN (43) 
        OR `ezcontentobject`.`contentclass_id` IN (23) 
        OR `ezcontentobject`.`contentclass_id` IN (24) 
        OR `ezcontentobject`.`contentclass_id` IN (27) 
        OR `ezcontentobject`.`contentclass_id` IN (33) 
        OR `ezcontentobject`.`contentclass_id` IN (41) 
        OR `ezcontentobject`.`contentclass_id` IN (45) 
        OR `ezcontentobject`.`contentclass_id` IN (34) 
        OR `ezcontentobject`.`contentclass_id` IN (44) 
        OR `ezcontentobject`.`contentclass_id` IN (26) 
        OR `ezcontentobject`.`contentclass_id` IN (36)
      ) 
      AND `ezcontentobject_tree`.`parent_node_id` IN (2413) 
      AND `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND NOT (
        `ezcontentobject`.`contentclass_id` IN (1)
      ) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5 
ORDER BY 
  `sort_column_0` ASC 
LIMIT 
  25

SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( ( `ezcontentobject`.`contentclass_id` IN ( 35 ) OR `ezcontentobject`.`contentclass_id` IN ( 37 ) OR `ezcontentobject`.`contentclass_id` IN ( 38 ) OR `ezcontentobject`.`contentclass_id` IN ( 39 ) OR `ezcontentobject`.`contentclass_id` IN ( 40 ) OR `ezcontentobject`.`contentclass_id` IN ( 46 ) OR `ezcontentobject`.`contentclass_id` IN ( 14 ) OR `ezcontentobject`.`contentclass_id` IN ( 16 ) OR `ezcontentobject`.`contentclass_id` IN ( 15 ) OR `ezcontentobject`.`contentclass_id` IN ( 17 ) OR `ezcontentobject`.`contentclass_id` IN ( 25 ) OR `ezcontentobject`.`contentclass_id` IN ( 43 ) OR `ezcontentobject`.`contentclass_id` IN ( 23 ) OR `ezcontentobject`.`contentclass_id` IN ( 24 ) OR `ezcontentobject`.`contentclass_id` IN ( 27 ) OR `ezcontentobject`.`contentclass_id` IN ( 33 ) OR `ezcontentobject`.`contentclass_id` IN ( 41 ) OR `ezcontentobject`.`contentclass_id` IN ( 45 ) OR `ezcontentobject`.`contentclass_id` IN ( 34 ) OR `ezcontentobject`.`contentclass_id` IN ( 44 ) OR `ezcontentobject`.`contentclass_id` IN ( 26 ) OR `ezcontentobject`.`contentclass_id` IN ( 36 ) ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 2413 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND (`ezcontentobject`.`language_mask` & 7) > 0 AND NOT ( `ezcontentobject`.`contentclass_id` IN ( 1 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;

SELECT 
  COUNT(*) count 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND `ezcontentobject`.`contentclass_id` IN (30) 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND `ezcontentobject_tree`.`parent_node_id` IN (5245) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5

SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5245 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;

SELECT 
  COUNT(*) count 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND `ezcontentobject`.`contentclass_id` IN (30) 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND `ezcontentobject_tree`.`parent_node_id` IN (476) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5

SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 476 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;

SELECT 
  ezcontentobject_tree.*, 
  `ezcontentobject`.`language_mask`, 
  `ezcontentobject`.`initial_language_id`, 
  `ezcontentobject_tree`.`priority` `sort_column_0` 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND `ezcontentobject`.`contentclass_id` IN (30) 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND `ezcontentobject_tree`.`parent_node_id` IN (4703) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5 
ORDER BY 
  `sort_column_0` ASC 
LIMIT 
  25

SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 4703 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;

SELECT 
  COUNT(*) count 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject`.`id` IN (
        SELECT 
          `contentobject_id` 
        FROM 
          `ezcontentobject_attribute` 
        WHERE 
          (
            `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` 
            AND (
              `contentclassattribute_id` IN ('4', '6', '116', '146', '413') 
              AND `sort_key_string` = : placeholder2
            ) 
            AND (
              `ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
            ) > : placeholder3
          )
      ) 
      AND `ezcontentobject`.`contentclass_id` IN (1) 
      AND `ezcontentobject_tree`.`parent_node_id` IN (240) 
      AND `ezcontentobject_tree`.`is_invisible` = : placeholder4 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder5 
  AND ezcontentobject_version.status = : placeholder6 
  AND `ezcontentobject_tree`.`depth` <> : placeholder7

SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 240 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7;

SELECT 
  ezcontentobject_tree.*, 
  `ezcontentobject`.`language_mask`, 
  `ezcontentobject`.`initial_language_id`, 
  `ezcontentobject_tree`.`priority` `sort_column_0` 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND `ezcontentobject`.`contentclass_id` IN (18) 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND `ezcontentobject_tree`.`parent_node_id` IN (2384) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5 
ORDER BY 
  `sort_column_0` ASC 
LIMIT 
  25

SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 18 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 2384 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;

SELECT 
  ezcontentobject_tree.*, 
  `ezcontentobject`.`language_mask`, 
  `ezcontentobject`.`initial_language_id`, 
  `ezcontentobject_tree`.`priority` `sort_column_0` 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND `ezcontentobject`.`contentclass_id` IN (30) 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND `ezcontentobject_tree`.`parent_node_id` IN (476) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5 
ORDER BY 
  `sort_column_0` ASC 
LIMIT 
  25

SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 476 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;

SELECT 
  ezcontentobject_tree.*, 
  `ezcontentobject`.`language_mask`, 
  `ezcontentobject`.`initial_language_id`, 
  `ezcontentobject_tree`.`priority` `sort_column_0` 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND `ezcontentobject`.`contentclass_id` IN (30) 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND `ezcontentobject_tree`.`parent_node_id` IN (5245) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5 
ORDER BY 
  `sort_column_0` ASC 
LIMIT 
  25

SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id`, `ezcontentobject_tree`.`priority` `sort_column_0` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5245 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5 ORDER BY `sort_column_0` ASC LIMIT 25;

SELECT 
  COUNT(*) count 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND `ezcontentobject`.`contentclass_id` IN (30) 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND `ezcontentobject_tree`.`parent_node_id` IN (5250) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5

SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 30 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 5250 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;

SELECT 
  ezcontentobject_tree.*, 
  `ezcontentobject`.`language_mask`, 
  `ezcontentobject`.`initial_language_id` 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject`.`id` IN (
        SELECT 
          `contentobject_id` 
        FROM 
          `ezcontentobject_attribute` 
        WHERE 
          (
            `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` 
            AND (
              `contentclassattribute_id` IN ('4', '6', '116', '146', '413') 
              AND `sort_key_string` = : placeholder2
            ) 
            AND (
              `ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`
            ) > : placeholder3
          )
      ) 
      AND `ezcontentobject`.`contentclass_id` IN (1) 
      AND `ezcontentobject_tree`.`parent_node_id` IN (240) 
      AND `ezcontentobject_tree`.`is_invisible` = : placeholder4 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder5 
  AND ezcontentobject_version.status = : placeholder6 
  AND `ezcontentobject_tree`.`depth` <> : placeholder7 
LIMIT 
  25

SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject`.`id` IN ( SELECT `contentobject_id` FROM `ezcontentobject_attribute` WHERE ( `ezcontentobject_attribute`.`version` = `ezcontentobject`.`current_version` AND ( `contentclassattribute_id` IN ( '4', '6', '116', '146', '413' ) AND `sort_key_string` = :placeholder2 ) AND (`ezcontentobject`.`initial_language_id` & `ezcontentobject_attribute`.`language_id`) > :placeholder3 ) ) AND `ezcontentobject`.`contentclass_id` IN ( 1 ) AND `ezcontentobject_tree`.`parent_node_id` IN ( 240 ) AND `ezcontentobject_tree`.`is_invisible` = :placeholder4 AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder5 AND ezcontentobject_version.status = :placeholder6 AND `ezcontentobject_tree`.`depth` <> :placeholder7 LIMIT 25;