Home - Cedarburg Public Library

SQL Error:booklists

SQL: [1109] SELECT *	 
	FROM `booklists` bk
	JOIN (Select stassoc.site_table_id, GROUP_CONCAT(st.`slug` SEPARATOR '|') site_tag_slugs from 	`site_tags_assoc` stassoc 
			JOIN `site_tags` st ON stassoc.`site_tag_id`=st.`id`
			AND stassoc.`site_table`='booklists' 
			WHERE st.`site_id`=:site_id -- multi-site
			GROUP BY site_table_id
		) as tags
	
	JOIN (SELECT `booklist_id`,
			GROUP_CONCAT(t2.`title` SEPARATOR '|') AS `booklist_books_titles`,
			GROUP_CONCAT(t2.`author` SEPARATOR '|') AS `booklist_books_authors`, 
			GROUP_CONCAT(t2.`image` SEPARATOR '|') AS `booklist_books_images`, 
			GROUP_CONCAT(t2.`description` SEPARATOR '|') AS `booklist_books_descriptions`, 
			GROUP_CONCAT(t2.`link` SEPARATOR '|') AS `booklist_books_links`
			FROM `booklists` t1	LEFT JOIN `booklist_books` t2 ON t1.`id` = t2.`booklist_id`  
			WHERE t1.`status`='Published' 
				AND t1.`site_id`=:site_id -- multi-site
			GROUP BY booklist_id 
			ORDER BY t2.`order`
		) as books	
	ON `site_table_id` = bk.`id` AND `booklist_id` = bk.`id`
	WHERE bk.`site_id`=:site_id -- multi-site	
	ORDER BY `booklist_order`
;
Sent SQL: [1094] SELECT *	 
	FROM `booklists` bk
	JOIN (Select stassoc.site_table_id, GROUP_CONCAT(st.`slug` SEPARATOR '|') site_tag_slugs from 	`site_tags_assoc` stassoc 
			JOIN `site_tags` st ON stassoc.`site_tag_id`=st.`id`
			AND stassoc.`site_table`='booklists' 
			WHERE st.`site_id`='5' -- multi-site
			GROUP BY site_table_id
		) as tags
	
	JOIN (SELECT `booklist_id`,
			GROUP_CONCAT(t2.`title` SEPARATOR '|') AS `booklist_books_titles`,
			GROUP_CONCAT(t2.`author` SEPARATOR '|') AS `booklist_books_authors`, 
			GROUP_CONCAT(t2.`image` SEPARATOR '|') AS `booklist_books_images`, 
			GROUP_CONCAT(t2.`description` SEPARATOR '|') AS `booklist_books_descriptions`, 
			GROUP_CONCAT(t2.`link` SEPARATOR '|') AS `booklist_books_links`
			FROM `booklists` t1	LEFT JOIN `booklist_books` t2 ON t1.`id` = t2.`booklist_id`  
			WHERE t1.`status`='Published' 
				AND t1.`site_id`='5' -- multi-site
			GROUP BY booklist_id 
			ORDER BY t2.`order`
		) as books	
	ON `site_table_id` = bk.`id` AND `booklist_id` = bk.`id`
	WHERE bk.`site_id`='5' -- multi-site	
	ORDER BY `booklist_order`
;
Params:  2
Key: Name: [15] :this_page_path
paramno=-1
name=[15] ":this_page_path"
is_param=1
param_type=2
Key: Name: [8] :site_id
paramno=-1
name=[8] ":site_id"
is_param=1
param_type=2