SELECT 
  u0_.id AS id0, 
  u0_.logo_enabled AS logo_enabled1, 
  u0_.sch_name AS sch_name2, 
  u0_.logo_filepath AS logo_filepath3, 
  u0_.user_category AS user_category4 
FROM 
  users u0_ 
WHERE 
  u0_.usertype = ? 
  AND u0_.logo_enabled <> 0 
  AND (
    u0_.user_category = ? 
    OR u0_.user_category IS NULL
  ) 
ORDER BY 
  u0_.sch_name ASC

SELECT u0_.id AS id0, u0_.logo_enabled AS logo_enabled1, u0_.sch_name AS sch_name2, u0_.logo_filepath AS logo_filepath3, u0_.user_category AS user_category4 FROM users u0_ WHERE u0_.usertype = 10 AND u0_.logo_enabled <> 0 AND (u0_.user_category = 'School' OR u0_.user_category IS NULL) ORDER BY u0_.sch_name ASC;

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 = 'demo-ks2englishspelling'
                AND COALESCE(parentid, 0) = 0 AND published = 1;

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.subject_id = ? 
  AND t0.program_id = ? 
  AND t0.level_id = ? 
LIMIT 
  1

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.subject_id = 8 AND t0.program_id = 2 AND t0.level_id = 10 LIMIT 1;

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.`key` = ? 
LIMIT 
  1

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.`key` = 'ks2englishspelling' LIMIT 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 = '415';