ezSQL (v2.17) Debug..

Query [3] -- [SELECT books.id, books.title, books.author_name, projects.name as project_name, areas.name as area_name, areas.url AS area_url FROM books LEFT JOIN projects ON books.project_id = projects.id LEFT JOIN areas ON books.area_id = areas.id WHERE books.status = '1' ORDER BY books.published DESC LIMIT 5]

Query Result..

(row)	int0 id	string0 title	string0 author_name	string0 project_name	string0 area_name	string0 area_url
No Results

ezSQL (v2.17) Debug..

Query [3] -- [SELECT books.id, books.title, books.author_name, projects.name as project_name, areas.name as area_name, areas.url AS area_url FROM books LEFT JOIN projects ON books.project_id = projects.id LEFT JOIN areas ON books.area_id = areas.id WHERE books.status = '1' ORDER BY books.published DESC LIMIT 5]

Query Result..

(row)	int0 id	string0 title	string0 author_name	string0 project_name	string0 area_name	string0 area_url
No Results