SELECT
ui.id,
ui.name,
ui.affiliation,
ui.city AS university_city,
ui.state AS university_state,
c.vcity_name AS ct,
s.vstate_name AS st,
ui.image,
ui.keyword,
ui.type,
sr.rank,
sr.nirf_start_rank,
sr.nirf_end_rank
FROM university_info ui
LEFT JOIN city c
ON c.ncityid = ui.city
LEFT JOIN state s
ON s.nstateid = ui.state
LEFT JOIN (
SELECT
db_university_id,
MIN(rank) AS rank,
MIN(nirf_start_rank) AS nirf_start_rank,
MAX(nirf_end_rank) AS nirf_end_rank
FROM staging_ranking
WHERE year = (SELECT MAX(year) FROM staging_ranking)
AND category = 'overall'
GROUP BY db_university_id
) sr ON sr.db_university_id = ui.id
WHERE
AND ui.type IS NULL
ORDER BY sr.nirf_start_rank IS NULL, sr.nirf_start_rank ASC
LIMIT 100
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND ui.type IS NULL
ORDER BY sr.nirf_start_rank IS N...' at line 32 in /home/eduvo/public_html/components/search/search-listing.php:346
Stack trace:
#0 /home/eduvo/public_html/components/search/search-listing.php(346): mysqli_query(Object(mysqli), 'SELECT\r\n ...')
#1 /home/eduvo/public_html/search.php(206): include('/home/eduvo/pub...')
#2 {main}
thrown in /home/eduvo/public_html/components/search/search-listing.php on line 346
