Miscellany

GET GALLERIES **** 

SELECT fg.`gallery_id` AS `hash_key`, 
fg.*, lc.`content_id`, 
lc.`user_id`, 
lc.`modifier_user_id`, 
lc.`created`, 
lc.`last_modified`, 
lc.`content_type_guid`, 
lc.`format_guid`, 
lch.`hits`, 
lch.`last_hit`, 
lc.`event_time`, 
lc.`version`, 
lc.`lang_code`, 
lc.`title`, 
lc.`ip`, 
uu.`login`, 
uu.`real_name`, 
plc.`content_type_guid` AS `preview_content_type_guid` ,
lc.`data` ,
gks.`security_id`, 
gks.`security_description`, 
gks.`is_private`, 
gks.`is_hidden`, 
gks.`access_question`, 
gks.`access_answer` 
FROM `fisheye_gallery` fg 
INNER JOIN `liberty_content` lc ON (fg.`content_id` = lc.`content_id`) 
INNER JOIN `users_users` uu ON (uu.`user_id` = lc.`user_id`) 
LEFT JOIN `liberty_content_hits` lch ON (lch.`content_id` = lc.`content_id`) 
INNER JOIN `fisheye_gallery_image_map` fgim ON (fgim.`gallery_content_id`=lc.`content_id`) 
LEFT OUTER JOIN `fisheye_gallery_image_map` tfgim2 ON (tfgim2.`item_content_id`=lc.`content_id`) 
LEFT OUTER JOIN `gatekeeper_security_map` cg ON (lc.`content_id`=cg.`content_id`) 
LEFT OUTER JOIN `gatekeeper_security` gks ON (gks.`security_id`=cg.`security_id` ) 
LEFT OUTER JOIN `liberty_content` plc ON (fg.`preview_content_id` = plc.`content_id`) 
WHERE tfgim2.`item_content_id` IS NULL 
ORDER BY `last_modified` DESC 

COUNT GALLERIES **** 

SELECT COUNT( fg.`gallery_id` ) 
FROM `fisheye_gallery` fg 
INNER JOIN `liberty_content` lc ON (fg.`content_id` = lc.`content_id`) 
INNER JOIN `users_users` uu ON (uu.`user_id` = lc.`user_id`) 
LEFT OUTER JOIN `liberty_content` ptc ON( fg.`preview_content_id`=ptc.`content_id` ) 
INNER JOIN `fisheye_gallery_image_map` fgim ON (fgim.`gallery_content_id`=lc.`content_id`) 
LEFT OUTER JOIN `fisheye_gallery_image_map` tfgim2 ON (tfgim2.`item_content_id`=lc.`content_id`) 
LEFT OUTER JOIN `gatekeeper_security_map` cg ON (lc.`content_id`=cg.`content_id`) 
LEFT OUTER JOIN `gatekeeper_security` gks ON (gks.`security_id`=cg.`security_id` ) 
WHERE tfgim2.`item_content_id` IS NULL