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