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-demos-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 = '413';

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 = NULL 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 = NULL AND t0_.pack_id IS NOT NULL GROUP BY t0_.subject_id;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.display_name AS display_name3, 
  t0.number AS number4, 
  t0.test_type AS test_type5, 
  t0.year AS year6, 
  t0.test_count AS test_count7, 
  t0.testsum_score1 AS testsum_score18, 
  t0.testsum_score1squared AS testsum_score1squared9, 
  t0.program_id AS program_id10, 
  t0.subject_id AS subject_id11, 
  t0.level_id AS level_id12, 
  t0.pack_id AS pack_id13 
FROM 
  test_def t0 
WHERE 
  t0.program_id = ? 
  AND t0.pack_id IS NULL 
  AND t0.test_type = ?

SELECT t0.id AS id1, t0.name AS name2, t0.display_name AS display_name3, t0.number AS number4, t0.test_type AS test_type5, t0.year AS year6, t0.test_count AS test_count7, t0.testsum_score1 AS testsum_score18, t0.testsum_score1squared AS testsum_score1squared9, t0.program_id AS program_id10, t0.subject_id AS subject_id11, t0.level_id AS level_id12, t0.pack_id AS pack_id13 FROM test_def t0 WHERE t0.program_id = 4 AND t0.pack_id IS NULL AND t0.test_type = 'demo';

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 = NULL 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;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.`key` AS key3, 
  t0.display_name AS display_name4, 
  t0.factory_service AS factory_service5, 
  t0.test_classname AS test_classname6, 
  t0.has_extracts AS has_extracts7, 
  t0.is_active AS is_active8, 
  t0.question_table AS question_table9, 
  t0.sort_order AS sort_order10, 
  t0.start_content AS start_content11, 
  t0.program_id AS program_id12 
FROM 
  test_subject t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = 43;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.`key` AS key3, 
  t0.display_name AS display_name4, 
  t0.factory_service AS factory_service5, 
  t0.test_classname AS test_classname6, 
  t0.has_extracts AS has_extracts7, 
  t0.is_active AS is_active8, 
  t0.question_table AS question_table9, 
  t0.sort_order AS sort_order10, 
  t0.start_content AS start_content11, 
  t0.program_id AS program_id12 
FROM 
  test_subject t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = 44;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.`key` AS key3, 
  t0.display_name AS display_name4, 
  t0.factory_service AS factory_service5, 
  t0.test_classname AS test_classname6, 
  t0.has_extracts AS has_extracts7, 
  t0.is_active AS is_active8, 
  t0.question_table AS question_table9, 
  t0.sort_order AS sort_order10, 
  t0.start_content AS start_content11, 
  t0.program_id AS program_id12 
FROM 
  test_subject t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = 41;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.`key` AS key3, 
  t0.display_name AS display_name4, 
  t0.factory_service AS factory_service5, 
  t0.test_classname AS test_classname6, 
  t0.has_extracts AS has_extracts7, 
  t0.is_active AS is_active8, 
  t0.question_table AS question_table9, 
  t0.sort_order AS sort_order10, 
  t0.start_content AS start_content11, 
  t0.program_id AS program_id12 
FROM 
  test_subject t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = 42;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.`key` AS key3, 
  t0.display_name AS display_name4, 
  t0.factory_service AS factory_service5, 
  t0.test_classname AS test_classname6, 
  t0.has_extracts AS has_extracts7, 
  t0.is_active AS is_active8, 
  t0.question_table AS question_table9, 
  t0.sort_order AS sort_order10, 
  t0.start_content AS start_content11, 
  t0.program_id AS program_id12 
FROM 
  test_subject t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = 47;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.`key` AS key3, 
  t0.display_name AS display_name4, 
  t0.factory_service AS factory_service5, 
  t0.test_classname AS test_classname6, 
  t0.has_extracts AS has_extracts7, 
  t0.is_active AS is_active8, 
  t0.question_table AS question_table9, 
  t0.sort_order AS sort_order10, 
  t0.start_content AS start_content11, 
  t0.program_id AS program_id12 
FROM 
  test_subject t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = 45;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.`key` AS key3, 
  t0.display_name AS display_name4, 
  t0.factory_service AS factory_service5, 
  t0.test_classname AS test_classname6, 
  t0.has_extracts AS has_extracts7, 
  t0.is_active AS is_active8, 
  t0.question_table AS question_table9, 
  t0.sort_order AS sort_order10, 
  t0.start_content AS start_content11, 
  t0.program_id AS program_id12 
FROM 
  test_subject t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.`key` AS key3, t0.display_name AS display_name4, t0.factory_service AS factory_service5, t0.test_classname AS test_classname6, t0.has_extracts AS has_extracts7, t0.is_active AS is_active8, t0.question_table AS question_table9, t0.sort_order AS sort_order10, t0.start_content AS start_content11, t0.program_id AS program_id12 FROM test_subject t0 WHERE t0.id = 46;