SELECT 
  id 
FROM 
  content 
WHERE 
  section = : section 
  AND urlname = : urlname 
  AND COALESCE(parentid, 0) = : parentid 
  AND published = 1

SELECT id
                FROM content
				WHERE section = 'information'
                AND urlname = 'mock-6-info'
                AND COALESCE(parentid, 0) = 0 AND published = 1;

SELECT 
  t0.id AS id1, 
  t0.title AS title2, 
  t0.description AS description3, 
  t0.keywords AS keywords4, 
  t0.summary AS summary5, 
  t0.content AS content6, 
  t0.published AS published7, 
  t0.urlname AS urlname8, 
  t0.section AS section9, 
  t0.weight AS weight10, 
  t0.tags AS tags11, 
  t0.contexts AS contexts12, 
  t0.parentid AS parentid13 
FROM 
  content t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.title AS title2, t0.description AS description3, t0.keywords AS keywords4, t0.summary AS summary5, t0.content AS content6, t0.published AS published7, t0.urlname AS urlname8, t0.section AS section9, t0.weight AS weight10, t0.tags AS tags11, t0.contexts AS contexts12, t0.parentid AS parentid13 FROM content t0 WHERE t0.id = '412';

SELECT 
  t0_.id AS id0, 
  t0_.name AS name1, 
  t0_.display_name AS display_name2, 
  t0_.number AS number3, 
  t0_.test_type AS test_type4, 
  t0_.year AS year5, 
  t0_.test_count AS test_count6, 
  t0_.testsum_score1 AS testsum_score17, 
  t0_.testsum_score1squared AS testsum_score1squared8, 
  t0_.program_id AS program_id9, 
  t0_.subject_id AS subject_id10, 
  t0_.level_id AS level_id11, 
  t0_.pack_id AS pack_id12 
FROM 
  test_def t0_ 
  LEFT JOIN test_subject t1_ ON t0_.subject_id = t1_.id 
WHERE 
  t0_.program_id = ? 
  AND t0_.pack_id IS NOT NULL 
  AND t0_.test_type <> 'demo' 
  AND t0_.year = ? 
ORDER BY 
  t0_.pack_id ASC, 
  t0_.level_id ASC, 
  t1_.sort_order ASC

SELECT t0_.id AS id0, t0_.name AS name1, t0_.display_name AS display_name2, t0_.number AS number3, t0_.test_type AS test_type4, t0_.year AS year5, t0_.test_count AS test_count6, t0_.testsum_score1 AS testsum_score17, t0_.testsum_score1squared AS testsum_score1squared8, t0_.program_id AS program_id9, t0_.subject_id AS subject_id10, t0_.level_id AS level_id11, t0_.pack_id AS pack_id12 FROM test_def t0_ LEFT JOIN test_subject t1_ ON t0_.subject_id = t1_.id WHERE t0_.program_id = 4 AND t0_.pack_id IS NOT NULL AND t0_.test_type <> 'demo' AND t0_.year = 6 ORDER BY t0_.pack_id ASC, t0_.level_id ASC, t1_.sort_order ASC;

SELECT 
  t0_.id AS id0, 
  t0_.name AS name1, 
  t0_.display_name AS display_name2, 
  t0_.number AS number3, 
  t0_.test_type AS test_type4, 
  t0_.year AS year5, 
  t0_.test_count AS test_count6, 
  t0_.testsum_score1 AS testsum_score17, 
  t0_.testsum_score1squared AS testsum_score1squared8, 
  t0_.program_id AS program_id9, 
  t0_.subject_id AS subject_id10, 
  t0_.level_id AS level_id11, 
  t0_.pack_id AS pack_id12 
FROM 
  test_def t0_ 
WHERE 
  t0_.year = ? 
  AND t0_.pack_id IS NOT NULL 
GROUP BY 
  t0_.subject_id

SELECT t0_.id AS id0, t0_.name AS name1, t0_.display_name AS display_name2, t0_.number AS number3, t0_.test_type AS test_type4, t0_.year AS year5, t0_.test_count AS test_count6, t0_.testsum_score1 AS testsum_score17, t0_.testsum_score1squared AS testsum_score1squared8, t0_.program_id AS program_id9, t0_.subject_id AS subject_id10, t0_.level_id AS level_id11, t0_.pack_id AS pack_id12 FROM test_def t0_ WHERE t0_.year = 6 AND t0_.pack_id IS NOT NULL GROUP BY t0_.subject_id;

SELECT 
  t0_.id AS id0, 
  t0_.name AS name1, 
  t0_.display_name AS display_name2, 
  t0_.number AS number3, 
  t0_.test_type AS test_type4, 
  t0_.year AS year5, 
  t0_.test_count AS test_count6, 
  t0_.testsum_score1 AS testsum_score17, 
  t0_.testsum_score1squared AS testsum_score1squared8, 
  t0_.program_id AS program_id9, 
  t0_.subject_id AS subject_id10, 
  t0_.level_id AS level_id11, 
  t0_.pack_id AS pack_id12 
FROM 
  test_def t0_ 
WHERE 
  t0_.year = ? 
  AND t0_.pack_id IS NOT NULL 
GROUP BY 
  t0_.subject_id

SELECT t0_.id AS id0, t0_.name AS name1, t0_.display_name AS display_name2, t0_.number AS number3, t0_.test_type AS test_type4, t0_.year AS year5, t0_.test_count AS test_count6, t0_.testsum_score1 AS testsum_score17, t0_.testsum_score1squared AS testsum_score1squared8, t0_.program_id AS program_id9, t0_.subject_id AS subject_id10, t0_.level_id AS level_id11, t0_.pack_id AS pack_id12 FROM test_def t0_ WHERE t0_.year = 6 AND t0_.pack_id IS NOT NULL GROUP BY t0_.subject_id;

SELECT 
  t0_.year AS year0 
FROM 
  test_def t0_ 
WHERE 
  t0_.program_id = ? 
GROUP BY 
  t0_.year

SELECT t0_.year AS year0 FROM test_def t0_ WHERE t0_.program_id = 4 GROUP BY t0_.year;