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

SELECT id
                FROM content
				WHERE section = 'content'
                AND urlname = 'Translate'
                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 = '146';

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