SELECT * FROM `emo_easyblog_post` WHERE `publish_up`<='2021-03-07 03:02:29' 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:02:29' 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:02:29' , 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:02:29', 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` = '4'
SELECT *
FROM emo_easyblog_meta
WHERE `content_id` = '4' AND `type` = 'category'
SELECT *
FROM emo_easyblog_category
WHERE `id` = '4'
select a.`id`, a.`title`, a.`alias`, a.`private`, a.`parent_id` from `emo_easyblog_category` as a WHERE a.`lft` > '22' AND a.`lft` < '23' 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 (4) or c.`parent_id` IN (4)) 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` = 4 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` = 4 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` = '4' AND `content_id` IN ('9')
SELECT `id` FROM `emo_easyblog_subscriptions` WHERE `uid` = '4' 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'
We would like to hear from you