Total SQL queries executed by: 130
Before application load usage: 2MB
After application load usage: 2MB
SELECT * FROM `emo_easyblog_post` WHERE `publish_up`<='2019-06-16 23:21:10' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 5
SELECT id, created_by FROM`emo_easyblog_post` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2019-06-16 23:21:10' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'
SELECT * FROM `emo_easyblog_uploader_tmp` WHERE `created` <= DATE_SUB('2019-06-16 23:21:10' , INTERVAL 120 MINUTE)
delete a, b from `emo_easyblog_post` as a inner join `emo_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2019-06-16 23:21:10', INTERVAL 3 DAY)
SELECT * FROM `emo_menu` WHERE `published`='1' AND `link` LIKE 'index.php?option=com_easyblog%'
SELECT * FROM `emo_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC
SELECT * FROM `emo_easyblog_acl_group` WHERE `content_id`='1' AND `type`='group'
SELECT `id`,`name`,`rules`,`parent_id`
FROM `emo_assets`
WHERE `name` IN ('root.1','com_acmanager','com_acymailing','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_api','com_arkeditor','com_arkmedia','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_easydiscuss','com_easysocial','com_excelcsv_users_import','com_fields','com_finder','com_geommunity3es','com_installer','com_invitex','com_j2xml','com_jaextmanager','com_jbolo','com_jfbconnect','com_jgive','com_joomlaupdate','com_jticketing','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_myplayer','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_regularlabsmanager','com_search','com_tags','com_templates','com_tjfields','com_users','com_wrapper')
SELECT `id` FROM `emo_menu` WHERE `link`='index.php?option=com_easyblog&view=categories' AND `published`='1' AND (`language`='en-GB' OR `language`='' OR `language`='*') LIMIT 1
SELECT `params` FROM `emo_menu` WHERE `id`='373'
SELECT *
FROM emo_easyblog_meta
WHERE `content_id` = '2' AND `type` = 'view'
select SQL_CALC_FOUND_ROWS a.*, count(pcat.`id`) as `cnt` from `emo_easyblog_category` as a inner join `emo_easyblog_category` as c on a.`lft` <= c.`lft` and a.`rgt` >= c.`rgt` left join `emo_easyblog_post_category` as `pcat` on c.`id` = pcat.`category_id` and exists (select p.`id` from `emo_easyblog_post` as p where pcat.`post_id` = p.`id` and p.`published` = '1' and p.`state` = '0') WHERE a.`published`='1' and a.`parent_id` = 0 and (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.`private` = 2 and (select count(1) from `emo_easyblog_category_acl` where `category_id` = a.`id` and `acl_id` = 1 and `content_id` in (9)) > 0)) ) GROUP BY a.`id` having (count(pcat.`id`) > 0) ORDER BY a.`lft` ASC LIMIT 0,5
select FOUND_ROWS()
SELECT `uid` FROM `emo_easyblog_subscriptions` WHERE `uid` IN (3,8,9,13) AND `utype` = 'category' AND `email` = ''
select distinct b.`category_id`, u.id from `emo_easyblog_users` as u inner join `emo_easyblog_post` as a on u.`id` = a.`created_by` inner join `emo_easyblog_post_category` as b on a.`id` = b.`post_id` where b.`category_id` in (3,8,9,13)
select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` from `emo_users` as u left join `emo_easyblog_users` as e ON u.`id` = e.`id` where u.`id` IN (42,74,42,42,74)
SHOW FULL COLUMNS FROM `emo_users`
SELECT *
FROM `emo_users`
WHERE `id` = 42
SELECT `g`.`id`,`g`.`title`
FROM `emo_usergroups` AS g
INNER JOIN `emo_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 42
SELECT *
FROM `emo_users`
WHERE `id` = 74
SELECT `g`.`id`,`g`.`title`
FROM `emo_usergroups` AS g
INNER JOIN `emo_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 74
select a.id as category_id, b.`id`, b.`title`, b.`alias`, b.`private`, b.`parent_id` from `emo_easyblog_category` as a inner join `emo_easyblog_category` as b on a.`lft` < b.`lft` and a.`rgt` > b.`lft` where a.`id` in (3,8,9,13) and a.`published` = '1' AND (( ( b.`private` = 0) OR ( b.`private` = 1 and 1 > 0) OR ( b.`private` = 2 and (select count(1) from `emo_easyblog_category_acl` where `category_id` = b.`id` and `acl_id` = 1 and `content_id` in (9)) > 0)))
(select distinct p1.*, '3' as `category_id`, f1.`id` as `featured` from `emo_easyblog_post` as p1 inner join `emo_easyblog_post_category` as a1 on p1.`id` = a1.`post_id` LEFT JOIN `emo_easyblog_featured` AS f1 ON p1.`id` = f1.`content_id` AND f1.`type` = 'post' where a1.`category_id` = '3' and p1.`published` = '1' and p1.`state` = '0' AND p1.`access` = '0' AND ( (p1.`source_type` = 'easyblog.sitewide') OR ( p1.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `emo_easyblog_team` as srcteam where srcteam.`id` = p1.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `emo_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (9) ) > 0)))) OR ( p1.`source_type` = 'easysocial.group' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p1.`source_id` and srcesgroup.`cluster_type` = 'group' and srcesgroup.`type` = '1')) OR ( p1.`source_type` = 'easysocial.page' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p1.`source_id` and srcesgroup.`cluster_type` = 'page' and srcesgroup.`type` = '1')) OR ( p1.`source_type` = 'easysocial.event' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p1.`source_id` and srcesgroup.`cluster_type` = 'event' and srcesgroup.`type` = '1'))) order by p1.`created` desc limit 5) UNION ALL (select distinct p2.*, '8' as `category_id`, f2.`id` as `featured` from `emo_easyblog_post` as p2 inner join `emo_easyblog_post_category` as a2 on p2.`id` = a2.`post_id` LEFT JOIN `emo_easyblog_featured` AS f2 ON p2.`id` = f2.`content_id` AND f2.`type` = 'post' where a2.`category_id` IN (8,6,15) and p2.`published` = '1' and p2.`state` = '0' AND p2.`access` = '0' AND ( (p2.`source_type` = 'easyblog.sitewide') OR ( p2.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `emo_easyblog_team` as srcteam where srcteam.`id` = p2.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `emo_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (9) ) > 0)))) OR ( p2.`source_type` = 'easysocial.group' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p2.`source_id` and srcesgroup.`cluster_type` = 'group' and srcesgroup.`type` = '1')) OR ( p2.`source_type` = 'easysocial.page' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p2.`source_id` and srcesgroup.`cluster_type` = 'page' and srcesgroup.`type` = '1')) OR ( p2.`source_type` = 'easysocial.event' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p2.`source_id` and srcesgroup.`cluster_type` = 'event' and srcesgroup.`type` = '1'))) order by p2.`created` desc limit 5) UNION ALL (select distinct p3.*, '9' as `category_id`, f3.`id` as `featured` from `emo_easyblog_post` as p3 inner join `emo_easyblog_post_category` as a3 on p3.`id` = a3.`post_id` LEFT JOIN `emo_easyblog_featured` AS f3 ON p3.`id` = f3.`content_id` AND f3.`type` = 'post' where a3.`category_id` IN (9,5,7,11) and p3.`published` = '1' and p3.`state` = '0' AND p3.`access` = '0' AND ( (p3.`source_type` = 'easyblog.sitewide') OR ( p3.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `emo_easyblog_team` as srcteam where srcteam.`id` = p3.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `emo_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (9) ) > 0)))) OR ( p3.`source_type` = 'easysocial.group' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p3.`source_id` and srcesgroup.`cluster_type` = 'group' and srcesgroup.`type` = '1')) OR ( p3.`source_type` = 'easysocial.page' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p3.`source_id` and srcesgroup.`cluster_type` = 'page' and srcesgroup.`type` = '1')) OR ( p3.`source_type` = 'easysocial.event' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p3.`source_id` and srcesgroup.`cluster_type` = 'event' and srcesgroup.`type` = '1'))) order by p3.`created` desc limit 5) UNION ALL (select distinct p4.*, '13' as `category_id`, f4.`id` as `featured` from `emo_easyblog_post` as p4 inner join `emo_easyblog_post_category` as a4 on p4.`id` = a4.`post_id` LEFT JOIN `emo_easyblog_featured` AS f4 ON p4.`id` = f4.`content_id` AND f4.`type` = 'post' where a4.`category_id` = '13' and p4.`published` = '1' and p4.`state` = '0' AND p4.`access` = '0' AND ( (p4.`source_type` = 'easyblog.sitewide') OR ( p4.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `emo_easyblog_team` as srcteam where srcteam.`id` = p4.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `emo_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (9) ) > 0)))) OR ( p4.`source_type` = 'easysocial.group' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p4.`source_id` and srcesgroup.`cluster_type` = 'group' and srcesgroup.`type` = '1')) OR ( p4.`source_type` = 'easysocial.page' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p4.`source_id` and srcesgroup.`cluster_type` = 'page' and srcesgroup.`type` = '1')) OR ( p4.`source_type` = 'easysocial.event' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = p4.`source_id` and srcesgroup.`cluster_type` = 'event' and srcesgroup.`type` = '1'))) order by p4.`created` desc limit 5)
SELECT COUNT(1) as `voted`, `uid` FROM `emo_easyblog_ratings` WHERE `uid` IN (278076,102034) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '6eccdb9fb2916655d0bc70ffbe6c7a49899912c7' OR `ip` = '3.88.220.93') GROUP BY `uid` ORDER BY NULL
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `emo_easyblog_ratings` AS a WHERE a.`uid` IN(278076,102034) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `emo_easyblog_comment` AS a WHERE a.`post_id` IN(278076,102034) AND a.`published`='1'
SELECT a.`post_id`, COUNT(1) AS `count` FROM `emo_easyblog_comment` AS a WHERE a.`post_id` IN(278076,102034) AND a.`published`='1' GROUP BY a.`post_id`
select a.*, b.`post_id`, b.`primary` from `emo_easyblog_category` as a inner join `emo_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 278076,102034)
select a.*, b.`post_id` from `emo_easyblog_tag` as a inner join `emo_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 278076,102034)
select a.* from `emo_easyblog_revisions` as a where a.`id` IN ( 278285,107899)
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `emo_easyblog_category_fields_groups` as a inner join `emo_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `emo_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `emo_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `emo_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where p.post_id IN (278076,102034)
select * from `emo_easyblog_meta` where `content_id` in (278076,102034) and `type` = 'post'
SELECT `group_id` FROM `emo_easyblog_category_fields_groups` WHERE `category_id`='9'
SELECT a.* FROM `emo_easyblog_fields` AS a INNER JOIN `emo_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='9' AND a.`state`='1' ORDER BY a.`created` DESC
SELECT `group_id` FROM `emo_easyblog_category_fields_groups` WHERE `category_id`='3'
SELECT a.* FROM `emo_easyblog_fields` AS a INNER JOIN `emo_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='3' AND a.`state`='1' ORDER BY a.`created` DESC
SELECT *
FROM emo_easyblog_category
WHERE `id` = '6'
SELECT *
FROM emo_easyblog_category
WHERE `id` = '15'
SELECT COUNT(1) as `voted`, `uid` FROM `emo_easyblog_ratings` WHERE `uid` IN (282078,282076,282077,282067,282064) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '6eccdb9fb2916655d0bc70ffbe6c7a49899912c7' OR `ip` = '3.88.220.93') GROUP BY `uid` ORDER BY NULL
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `emo_easyblog_ratings` AS a WHERE a.`uid` IN(282078,282076,282077,282067,282064) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `emo_easyblog_comment` AS a WHERE a.`post_id` IN(282078,282076,282077,282067,282064) AND a.`published`='1'
SELECT a.`post_id`, COUNT(1) AS `count` FROM `emo_easyblog_comment` AS a WHERE a.`post_id` IN(282078,282076,282077,282067,282064) AND a.`published`='1' GROUP BY a.`post_id`
select a.*, b.`post_id`, b.`primary` from `emo_easyblog_category` as a inner join `emo_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 282078,282076,282077,282067,282064)
select a.*, b.`post_id` from `emo_easyblog_tag` as a inner join `emo_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 282078,282076,282077,282067,282064)
select a.* from `emo_easyblog_revisions` as a where a.`id` IN ( 282330,282327,282329,282316,282314)
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `emo_easyblog_category_fields_groups` as a inner join `emo_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `emo_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `emo_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `emo_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where p.post_id IN (282078,282076,282077,282067,282064)
select * from `emo_easyblog_meta` where `content_id` in (282078,282076,282077,282067,282064) and `type` = 'post'
SELECT * FROM `emo_easyblog_featured` WHERE `content_id` IN(282078,282076,282077,282067,282064) AND `type`='post'
SELECT `group_id` FROM `emo_easyblog_category_fields_groups` WHERE `category_id`='8'
SELECT a.* FROM `emo_easyblog_fields` AS a INNER JOIN `emo_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='8' AND a.`state`='1' ORDER BY a.`created` DESC
SELECT *
FROM emo_easyblog_category
WHERE `id` = '5'
SELECT *
FROM emo_easyblog_category
WHERE `id` = '11'
SELECT COUNT(1) as `voted`, `uid` FROM `emo_easyblog_ratings` WHERE `uid` IN (282167,282163,282162,282161,282160) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '6eccdb9fb2916655d0bc70ffbe6c7a49899912c7' OR `ip` = '3.88.220.93') GROUP BY `uid` ORDER BY NULL
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `emo_easyblog_ratings` AS a WHERE a.`uid` IN(282167,282163,282162,282161,282160) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `emo_easyblog_comment` AS a WHERE a.`post_id` IN(282167,282163,282162,282161,282160) AND a.`published`='1'
SELECT a.`post_id`, COUNT(1) AS `count` FROM `emo_easyblog_comment` AS a WHERE a.`post_id` IN(282167,282163,282162,282161,282160) AND a.`published`='1' GROUP BY a.`post_id`
select a.*, b.`post_id`, b.`primary` from `emo_easyblog_category` as a inner join `emo_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 282167,282163,282162,282161,282160)
select a.*, b.`post_id` from `emo_easyblog_tag` as a inner join `emo_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 282167,282163,282162,282161,282160)
select a.* from `emo_easyblog_revisions` as a where a.`id` IN ( 282475,282467,282462,282461,282460)
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `emo_easyblog_category_fields_groups` as a inner join `emo_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `emo_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `emo_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `emo_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where p.post_id IN (282167,282163,282162,282161,282160)
select * from `emo_easyblog_meta` where `content_id` in (282167,282163,282162,282161,282160) and `type` = 'post'
SELECT * FROM `emo_easyblog_featured` WHERE `content_id` IN(282167,282163,282162,282161,282160) AND `type`='post'
SELECT `group_id` FROM `emo_easyblog_category_fields_groups` WHERE `category_id`='5'
SELECT a.* FROM `emo_easyblog_fields` AS a INNER JOIN `emo_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='5' AND a.`state`='1' ORDER BY a.`created` DESC
SELECT COUNT(1) as `voted`, `uid` FROM `emo_easyblog_ratings` WHERE `uid` IN (282041,282042,282043,282044,282045) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '6eccdb9fb2916655d0bc70ffbe6c7a49899912c7' OR `ip` = '3.88.220.93') GROUP BY `uid` ORDER BY NULL
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `emo_easyblog_ratings` AS a WHERE a.`uid` IN(282041,282042,282043,282044,282045) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `emo_easyblog_comment` AS a WHERE a.`post_id` IN(282041,282042,282043,282044,282045) AND a.`published`='1'
SELECT a.`post_id`, COUNT(1) AS `count` FROM `emo_easyblog_comment` AS a WHERE a.`post_id` IN(282041,282042,282043,282044,282045) AND a.`published`='1' GROUP BY a.`post_id`
select a.*, b.`post_id`, b.`primary` from `emo_easyblog_category` as a inner join `emo_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 282041,282042,282043,282044,282045)
select a.*, b.`post_id` from `emo_easyblog_tag` as a inner join `emo_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 282041,282042,282043,282044,282045)
select a.* from `emo_easyblog_revisions` as a where a.`id` IN ( 282287,282288,282289,282290,282291)
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `emo_easyblog_category_fields_groups` as a inner join `emo_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `emo_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `emo_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `emo_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where p.post_id IN (282041,282042,282043,282044,282045)
select * from `emo_easyblog_meta` where `content_id` in (282041,282042,282043,282044,282045) and `type` = 'post'
SELECT * FROM `emo_easyblog_featured` WHERE `content_id` IN(282041,282042,282043,282044,282045) AND `type`='post'
SELECT `group_id` FROM `emo_easyblog_category_fields_groups` WHERE `category_id`='13'
SELECT a.* FROM `emo_easyblog_fields` AS a INNER JOIN `emo_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='13' AND a.`state`='1' ORDER BY a.`created` DESC
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SET SQL_BIG_SELECTS=1
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`auth`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `emo_users` AS `a` LEFT JOIN `emo_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `emo_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `emo_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `emo_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `emo_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '42' GROUP BY `a`.`id`
SELECT * FROM `emo_social_default_avatars` WHERE `uid` IN (3) AND `type`='profiles'
SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` FROM `emo_usergroups` AS a INNER JOIN `emo_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` IN (42)
select * from `emo_social_users` where `user_id` IN (42)
select `session_id`, `userid` from `emo_session` where `userid` IN (42)
SELECT * FROM `emo_social_default_avatars` WHERE `uid`='3' AND `type`='profiles'
SELECT *
FROM emo_social_profiles
WHERE `id` = '3'
SELECT COUNT(1) FROM `emo_easyblog_post` AS a WHERE a.`created_by`='42' AND a.`published`='1' AND a.`state`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SET SQL_BIG_SELECTS=1
SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`auth`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `emo_users` AS `a` LEFT JOIN `emo_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `emo_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `emo_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `emo_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `emo_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '74' GROUP BY `a`.`id`
SELECT * FROM `emo_social_default_avatars` WHERE `uid` IN (2) AND `type`='profiles'
SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` FROM `emo_usergroups` AS a INNER JOIN `emo_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` IN (74)
select * from `emo_social_users` where `user_id` IN (74)
select `session_id`, `userid` from `emo_session` where `userid` IN (74)
SELECT *
FROM emo_social_profiles
WHERE `id` = '2'
SELECT COUNT(1) FROM `emo_easyblog_post` AS a WHERE a.`created_by`='74' AND a.`published`='1' AND a.`state`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
EMoDiR
Early Modern Dissents and Radicalism
