The EMoDiR Blog

SELECT * FROM `emo_easyblog_post` WHERE `publish_up`<='2019-01-22 05:17:16' 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-01-22 05:17:16' 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-01-22 05:17:16' , 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-01-22 05:17:16', 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_meta WHERE `content_id` = '4' AND `type` = 'view'
select SQL_CALC_FOUND_ROWS count( p.id ) as `totalPost`, MAX(p.`created`) as `latestPostDate`, COUNT( DISTINCT(g.content_id) ) as `featured`, a.`id`, b.`nickname`, a.`name`, a.`username`, a.`registerDate`, a.`lastvisitDate`, b.`permalink` from `emo_users` as a inner JOIN `emo_easyblog_users` AS `b` ON a.`id` = b.`id` left join `emo_easyblog_post` as p on a.`id` = p.`created_by` and `p`.`published` = '1' and p.`state` = '0' left join `emo_easyblog_featured` AS `g` ON a.`id`= g.`content_id` AND g.`type`= 'blogger' where (1 <= (select count(1) from `emo_easyblog_acl_group` as ag inner join `emo_easyblog_acl` as acl on ag.`acl_id` = acl.`id` inner join `emo_user_usergroup_map` as up on ag.`content_id` = up.`group_id` where up.`user_id` = `a`.`id` and acl.`action` = 'add_entry' and ag.`type` = 'group' and ag.`status` = 1)) group by a.`id` ORDER BY a.`id` DESC LIMIT 0,5
select FOUND_ROWS()
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 (563,562,560,542,151)
SHOW FULL COLUMNS FROM `emo_users`
SELECT * FROM `emo_users` WHERE `id` = 151
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` = 151
SELECT * FROM `emo_users` WHERE `id` = 542
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` = 542
SELECT * FROM `emo_users` WHERE `id` = 560
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` = 560
SELECT * FROM `emo_users` WHERE `id` = 562
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` = 562
SELECT * FROM `emo_users` WHERE `id` = 563
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` = 563
select distinct a.*, c.`created_by` as `author_id` from `emo_easyblog_tag` as a inner join `emo_easyblog_post_tag` as b on a.`id` = b.`tag_id` inner join `emo_easyblog_post` as c on b.`post_id` = c.`id` where c.`created_by` IN (563,562,560,542,151) and c.`published` = '1' and c.`state` = '0'
select distinct a.*, count(b.`id`) as `post_count`, c.`created_by` as `author_id` from `emo_easyblog_category` as a inner join `emo_easyblog_post_category` as b ON a.`id` = b.`category_id` inner join `emo_easyblog_post` as c ON b.`post_id` = c.`id` where c.`created_by` IN (563,562,560,542,151) and c.`published` = '1' and c.`state` = '0' group by a.`id`, c.`created_by` order by null
SELECT `id`, `uid` FROM `emo_easyblog_subscriptions` WHERE `uid` IN (563,562,560,542,151) AND `utype` = 'blogger' AND `email` = ''
SELECT a.*, if( a.`target_id` = '0', a.`actor_id`, a.`target_id`) AS friendid FROM `emo_social_friends` AS a INNER JOIN `emo_users` AS uu ON uu.`id` = if( a.`target_id` = '0', a.`actor_id`, a.`target_id`) INNER JOIN `emo_social_profiles_maps` as upm on uu.`id` = upm.`user_id` INNER JOIN `emo_social_profiles` as up on upm.`profile_id` = up.`id` and up.`community_access` = 1 WHERE uu.`block` = '0' AND (a.`target_id`='0' AND a.`state`='1') OR (a.`actor_id`='0' AND a.`state`='1')
SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `emo_easyblog_post` AS a LEFT JOIN `emo_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND ( ( a.`access`= 0 ) OR ( (a.`access` = 10) AND ('0' > 0 ) ) OR ( ( a.`access` = 30 ) AND ( 1 = 2 ) ) OR ( (a.`access` = 40) AND ( a.`created_by`=0) ) ) AND a.`created_by` = '563' 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.`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.`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'))) ORDER BY a.`created` desc LIMIT 5
SELECT a.*, if( a.`target_id` = '0', a.`actor_id`, a.`target_id`) AS friendid FROM `emo_social_friends` AS a INNER JOIN `emo_users` AS uu ON uu.`id` = if( a.`target_id` = '0', a.`actor_id`, a.`target_id`) INNER JOIN `emo_social_profiles_maps` as upm on uu.`id` = upm.`user_id` INNER JOIN `emo_social_profiles` as up on upm.`profile_id` = up.`id` and up.`community_access` = 1 WHERE uu.`block` = '0' AND (a.`target_id`='0' AND a.`state`='1') OR (a.`actor_id`='0' AND a.`state`='1')
SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `emo_easyblog_post` AS a LEFT JOIN `emo_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND ( ( a.`access`= 0 ) OR ( (a.`access` = 10) AND ('0' > 0 ) ) OR ( ( a.`access` = 30 ) AND ( 1 = 2 ) ) OR ( (a.`access` = 40) AND ( a.`created_by`=0) ) ) AND a.`created_by` = '562' 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.`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.`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'))) ORDER BY a.`created` desc LIMIT 5
SELECT a.*, if( a.`target_id` = '0', a.`actor_id`, a.`target_id`) AS friendid FROM `emo_social_friends` AS a INNER JOIN `emo_users` AS uu ON uu.`id` = if( a.`target_id` = '0', a.`actor_id`, a.`target_id`) INNER JOIN `emo_social_profiles_maps` as upm on uu.`id` = upm.`user_id` INNER JOIN `emo_social_profiles` as up on upm.`profile_id` = up.`id` and up.`community_access` = 1 WHERE uu.`block` = '0' AND (a.`target_id`='0' AND a.`state`='1') OR (a.`actor_id`='0' AND a.`state`='1')
SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `emo_easyblog_post` AS a LEFT JOIN `emo_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND ( ( a.`access`= 0 ) OR ( (a.`access` = 10) AND ('0' > 0 ) ) OR ( ( a.`access` = 30 ) AND ( 1 = 2 ) ) OR ( (a.`access` = 40) AND ( a.`created_by`=0) ) ) AND a.`created_by` = '560' 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.`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.`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'))) ORDER BY a.`created` desc LIMIT 5
SELECT a.*, if( a.`target_id` = '0', a.`actor_id`, a.`target_id`) AS friendid FROM `emo_social_friends` AS a INNER JOIN `emo_users` AS uu ON uu.`id` = if( a.`target_id` = '0', a.`actor_id`, a.`target_id`) INNER JOIN `emo_social_profiles_maps` as upm on uu.`id` = upm.`user_id` INNER JOIN `emo_social_profiles` as up on upm.`profile_id` = up.`id` and up.`community_access` = 1 WHERE uu.`block` = '0' AND (a.`target_id`='0' AND a.`state`='1') OR (a.`actor_id`='0' AND a.`state`='1')
SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `emo_easyblog_post` AS a LEFT JOIN `emo_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND ( ( a.`access`= 0 ) OR ( (a.`access` = 10) AND ('0' > 0 ) ) OR ( ( a.`access` = 30 ) AND ( 1 = 2 ) ) OR ( (a.`access` = 40) AND ( a.`created_by`=0) ) ) AND a.`created_by` = '542' 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.`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.`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'))) ORDER BY a.`created` desc LIMIT 5
SELECT a.*, if( a.`target_id` = '0', a.`actor_id`, a.`target_id`) AS friendid FROM `emo_social_friends` AS a INNER JOIN `emo_users` AS uu ON uu.`id` = if( a.`target_id` = '0', a.`actor_id`, a.`target_id`) INNER JOIN `emo_social_profiles_maps` as upm on uu.`id` = upm.`user_id` INNER JOIN `emo_social_profiles` as up on upm.`profile_id` = up.`id` and up.`community_access` = 1 WHERE uu.`block` = '0' AND (a.`target_id`='0' AND a.`state`='1') OR (a.`actor_id`='0' AND a.`state`='1')
SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `emo_easyblog_post` AS a LEFT JOIN `emo_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND ( ( a.`access`= 0 ) OR ( (a.`access` = 10) AND ('0' > 0 ) ) OR ( ( a.`access` = 30 ) AND ( 1 = 2 ) ) OR ( (a.`access` = 40) AND ( a.`created_by`=0) ) ) AND a.`created_by` = '151' 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.`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.`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'))) ORDER BY a.`created` desc LIMIT 5
SELECT * FROM `emo_easyblog_oauth` WHERE `user_id`='563' AND `type`='twitter' LIMIT 1
SELECT `group_id` FROM `emo_user_usergroup_map` WHERE `user_id` = '563'
SELECT * FROM `emo_easyblog_acl_group` WHERE `content_id` IN (2, 6, 7, 10) AND `type`='group'
SELECT * FROM `emo_easyblog_oauth` WHERE `user_id`='562' AND `type`='twitter' LIMIT 1
SELECT `group_id` FROM `emo_user_usergroup_map` WHERE `user_id` = '562'
SELECT * FROM `emo_easyblog_acl_group` WHERE `content_id` IN (1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14) AND `type`='group'
SELECT * FROM `emo_easyblog_oauth` WHERE `user_id`='560' AND `type`='twitter' LIMIT 1
SELECT `group_id` FROM `emo_user_usergroup_map` WHERE `user_id` = '560'
SELECT * FROM `emo_easyblog_acl_group` WHERE `content_id` IN (2, 3, 4, 5, 6, 7, 10, 11, 12, 13, 14) AND `type`='group'
SELECT * FROM `emo_easyblog_oauth` WHERE `user_id`='542' AND `type`='twitter' LIMIT 1
SELECT `group_id` FROM `emo_user_usergroup_map` WHERE `user_id` = '542'
SELECT * FROM `emo_easyblog_acl_group` WHERE `content_id` IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14) AND `type`='group'
SELECT * FROM `emo_easyblog_oauth` WHERE `user_id`='151' AND `type`='twitter' LIMIT 1
SELECT `group_id` FROM `emo_user_usergroup_map` WHERE `user_id` = '151'
SELECT * FROM `emo_easyblog_acl_group` WHERE `content_id` IN (2) AND `type`='group'
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` = '563' 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 (563)
select * from `emo_social_users` where `user_id` IN (563)
select `session_id`, `userid` from `emo_session` where `userid` IN (563)
SELECT * FROM emo_social_profiles WHERE `id` = '2'
select `id` FROM `emo_easyblog_feedburner` where userid = '563'
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` = '562' GROUP BY `a`.`id`
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 (562)
select * from `emo_social_users` where `user_id` IN (562)
select `session_id`, `userid` from `emo_session` where `userid` IN (562)
select `id` FROM `emo_easyblog_feedburner` where userid = '562'
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` = '560' GROUP BY `a`.`id`
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 (560)
select * from `emo_social_users` where `user_id` IN (560)
select `session_id`, `userid` from `emo_session` where `userid` IN (560)
select `id` FROM `emo_easyblog_feedburner` where userid = '560'
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` = '542' GROUP BY `a`.`id`
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 (542)
select * from `emo_social_users` where `user_id` IN (542)
select `session_id`, `userid` from `emo_session` where `userid` IN (542)
select `id` FROM `emo_easyblog_feedburner` where userid = '542'
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` = '151' GROUP BY `a`.`id`
SELECT * FROM `emo_social_default_avatars` WHERE `uid` IN (1) 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 (151)
select * from `emo_social_users` where `user_id` IN (151)
select `session_id`, `userid` from `emo_session` where `userid` IN (151)
SELECT * FROM `emo_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
SELECT * FROM emo_social_profiles WHERE `id` = '1'
select `id` FROM `emo_easyblog_feedburner` where userid = '151'
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'

The EMoDiR Blog

Fritz Viertel

publisher

Nina Fl

Xenia von Tippelskirch

Adam Morton

Debug information

Newsletters

The Members

Site Notice

Featured Blogs