Spaces of Coexistence
SELECT * FROM `emo_easyblog_post` WHERE `publish_up`<='2021-03-07 03:13:19' 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` <= '2021-03-07 03:13:19' 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('2021-03-07 03:13:19' , 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('2021-03-07 03:13:19', 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 *
FROM emo_easyblog_category
WHERE `id` = '3'
SELECT *
FROM emo_easyblog_meta
WHERE `content_id` = '3' AND `type` = 'category'
SELECT *
FROM emo_easyblog_category
WHERE `id` = '3'
select a.`id`, a.`title`, a.`alias`, a.`private`, a.`parent_id` from `emo_easyblog_category` as a WHERE a.`lft` > '3' AND a.`lft` < '4' and a.`published` = '1' 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))) ORDER BY a.`lft` ASC
SELECT COUNT(1) AS `cnt` FROM `emo_easyblog_post_category` AS `a` INNER JOIN `emo_easyblog_post` AS `b` ON a.`post_id` = b.`id` AND b.`published`='1' INNER JOIN `emo_easyblog_category` AS `c` ON a.`category_id` = c.`id` AND b.`access`='0' WHERE ( c.`id` IN (3) or c.`parent_id` IN (3)) AND b.`state`='0'
SELECT COUNT(1) FROM `emo_easyblog_post` AS a WHERE a.`published`='1' AND a.`state`='0' AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `emo_easyblog_team` as srcteam where srcteam.`id` = a.`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 ( a.`source_type` = 'easysocial.group' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'group' and srcesgroup.`type` = '1')) OR ( a.`source_type` = 'easysocial.page' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'page' and srcesgroup.`type` = '1')) OR ( a.`source_type` = 'easysocial.event' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'event' and srcesgroup.`type` = '1'))) AND (1 <= (select count(1) from `emo_easyblog_post_category` AS acp INNER JOIN `emo_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` = 3 and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `emo_easyblog_category_acl` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (9)) > 0 ) ) ) )) AND a.`access`='0' ORDER BY a.`created` desc
SELECT a.* FROM `emo_easyblog_post` AS a WHERE a.`published`='1' AND a.`state`='0' AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `emo_easyblog_team` as srcteam where srcteam.`id` = a.`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 ( a.`source_type` = 'easysocial.group' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'group' and srcesgroup.`type` = '1')) OR ( a.`source_type` = 'easysocial.page' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'page' and srcesgroup.`type` = '1')) OR ( a.`source_type` = 'easysocial.event' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'event' and srcesgroup.`type` = '1'))) AND (1 <= (select count(1) from `emo_easyblog_post_category` AS acp INNER JOIN `emo_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` = 3 and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `emo_easyblog_category_acl` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (9)) > 0 ) ) ) )) AND a.`access`='0' ORDER BY a.`created` desc LIMIT 0,5
SELECT COUNT(1) FROM `emo_easyblog_category_acl` WHERE `acl_id` = '1' AND `status` = '1' AND `category_id` = '3' AND `content_id` IN ('9')
SELECT COUNT(1) as `voted`, `uid` FROM `emo_easyblog_ratings` WHERE `uid` IN (278076,102034) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '7e47d9294b676505341a17a84bde611e7653f3dd' OR `ip` = '44.192.10.166') 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 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` = 42
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 `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 * FROM `emo_easyblog_featured` 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 `id` FROM `emo_easyblog_subscriptions` WHERE `uid` = '3' AND `utype` = 'category' AND `email` = ''
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 MAX(ordering)
FROM `emo_extensions`
WHERE `type` = 'plugin' AND `folder` = 'content'
SELECT `ordering`
FROM `emo_extensions`
WHERE `type` = 'plugin' AND `folder` = 'content' AND `element` = 'perfect_everything_in_everyway'
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM emo_fields AS a
LEFT JOIN `emo_languages` AS l ON l.lang_code = a.language
LEFT JOIN emo_users AS uc ON uc.id=a.checked_out
LEFT JOIN emo_viewlevels AS ag ON ag.id = a.access
LEFT JOIN emo_users AS ua ON ua.id = a.created_user_id
LEFT JOIN emo_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `emo_fields_categories` AS fc ON fc.field_id = a.id
WHERE a.context = 'easyblog.blog' AND (fc.category_id IS NULL OR fc.category_id IN (3,0)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
SELECT * FROM `emo_social_access_rules` WHERE `group` = 'user' AND `state` = '1'
SELECT `params` FROM `emo_social_access` WHERE `uid` = NULL AND `type` = 'profiles'
SELECT COUNT(1) FROM `emo_social_comments` AS `a` WHERE `a`.`stream_id` = '' AND `a`.`element` = 'article.user.create' AND `a`.`uid` = '278076' AND `a`.`parent` = '0'
SELECT COUNT(1) FROM `emo_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'user' OR `a`.`default` = '1'
SELECT `a`.* FROM `emo_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'user' OR `a`.`default` = '1'
SELECT * FROM `emo_social_themes` WHERE `element` = 'wireframe'
SELECT namekey,value FROM `emo_invitex_config`
SELECT namekey,value FROM `emo_invitex_config`
SELECT namekey,value FROM `emo_invitex_config`
SELECT namekey,value FROM `emo_invitex_config`
SELECT template FROM `emo_template_styles` AS s LEFT JOIN `emo_extensions` AS e ON e.type = `template` AND e.element=s.template AND e.client_id=s.client_id WHERE s.client_id = '0' AND home = 1
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT *
FROM emo_easyblog_tag
WHERE `id` = '23'
SELECT *
FROM emo_easyblog_tag
WHERE `id` = '22'
SELECT *
FROM emo_easyblog_tag
WHERE `id` = '21'
SELECT *
FROM emo_easyblog_tag
WHERE `id` = '20'
SELECT *
FROM emo_easyblog_tag
WHERE `id` = '19'
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 a.* FROM `emo_easyblog_comment` a INNER JOIN emo_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '278076' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3
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 COUNT(1) FROM `emo_social_comments` AS `a` WHERE `a`.`stream_id` = '' AND `a`.`element` = 'article.user.create' AND `a`.`uid` = '102034' AND `a`.`parent` = '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 a.* FROM `emo_easyblog_comment` a INNER JOIN emo_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '102034' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3
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` = 49
SELECT *
FROM `emo_users`
WHERE `id` = 49
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` = 49
select a.id as `user_id`, c.id, a.name as `displayname` FROM `emo_users` as a inner join `emo_easyblog_users` as b on a.id = b.id inner join `emo_easyblog_likes` as c on a.id = c.created_by where c.content_id = '1' and c.`type` = 'comment' order by c.id desc
select a.id as `user_id`, c.id, a.name as `displayname` FROM `emo_users` as a inner join `emo_easyblog_users` as b on a.id = b.id inner join `emo_easyblog_likes` as c on a.id = c.created_by where c.content_id = '5' and c.`type` = 'comment' order by c.id 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'
We would like to hear from you