SELECT COUNT(1) FROM `sls_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'user' OR `a`.`default` = '1'
SELECT `a`.* FROM `sls_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'user' OR `a`.`default` = '1'
SELECT * FROM `sls_social_access_rules` WHERE `group` = 'user' AND `state` = '1'
SELECT `params` FROM `sls_social_access` WHERE `uid` = NULL AND `type` = 'profiles'
SELECT * FROM `sls_social_themes` WHERE `element` = 'wireframe'
SELECT `id`,`name`,`rules`,`parent_id`
FROM `sls_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_easyblog','com_easydiscuss','com_easysocial','com_fields','com_finder','com_gantry','com_gsd','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_route66','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
select `element` from `sls_social_apps` where `type` = 'apps' and `state` = 0 and `group` = 'user'
SELECT * FROM `sls_social_apps`
SELECT a.* , l.id as loc_id, l.uid as loc_uid, l.type as loc_type, l.user_id as loc_user_id, l.created as loc_created, l.short_address as loc_short_address ,l.address as loc_address, l.longitude as loc_longitude, l.latitude as loc_latitude, l.params as loc_params ,md.id as md_id, md.namespace as md_namespace,md.namespace_uid as md_namespace_uid, md.icon as md_icon, md.verb as md_verb, md.subject as md_subject, md.custom as md_custom ,md.text as md_text, md.user_id as md_user_id, md.created as md_created ,0 as bookmarked ,FLOOR( ( UNIX_TIMESTAMP( now() ) - UNIX_TIMESTAMP( a.`modified`) ) / 60 ) AS `min` ,FLOOR( ( UNIX_TIMESTAMP( now() ) - UNIX_TIMESTAMP( a.`modified`) ) / 60 / 60 ) AS `hour` ,FLOOR( ( UNIX_TIMESTAMP( now() ) - UNIX_TIMESTAMP( a.`modified`) ) / 60 / 60 / 24 ) AS `day` FROM `sls_social_stream` AS a LEFT JOIN `sls_social_locations` AS l ON a.`location_id` = l.`id` LEFT JOIN `sls_social_moods` AS md ON a.`mood_id` = md.`id` WHERE a.`state` = 1 AND ( (a.`cluster_id`= 0) OR (a.`cluster_id` > 0 and a.`cluster_access` = 1) ) AND a.`context_type` NOT IN ('article','parainvite') AND a.`access` = '0' ORDER BY a.`modified` DESC LIMIT 0,11
SELECT * FROM `sls_social_stream_item` as a WHERE `uid` IN ( 4928,4927,4926,4925,4923) AND `context_type`='users' UNION SELECT * FROM `sls_social_stream_item` as a WHERE `uid` IN ( 4922,4921,4920) AND `context_type`='users' UNION SELECT * FROM `sls_social_stream_item` as a WHERE `uid` IN ( 4924,4919) AND `context_type`='blog'
SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` IN (1517,1514,43,44,0)
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`,`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 `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` IN ('1517', '1514', '43', '44') GROUP BY `a`.`id`
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '43'
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '44'
SELECT *
FROM sls_social_default_avatars
WHERE `id` = '1'
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1514'
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1517'
SELECT * FROM `sls_social_stream_tags` WHERE `stream_id` IN('4928','4927','4926','4925','4924','4923','4922','4921','4920','4919') ORDER BY `stream_id`, `offset` DESC
SELECT a.* FROM `sls_social_likes` AS a INNER JOIN `sls_users` AS b ON a.`created_by` = b.`id` WHERE a.stream_id IN (4928,4927,4926,4925,4924,4923,4922,4921,4920,4919) AND b.`block` = '0'
select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4928) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4927) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4926) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4925) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4924) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4923) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4922) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4921) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4920) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4919) and `element` = 'stream.user'
select * from `sls_social_shares` where id IN (1517,1514,43,1155,936)
select count(1) as `cnt`, x.`uid`, x.`element`, x.`stream_id` from `sls_social_comments` as x where stream_id IN (4928,4927,4926,4925,4924,4923,4922,4921,4920,4919) group by x.`element`, x.`uid`, x.`stream_id`
select x.* from `sls_social_comments` as x where x.stream_id IN (4928,4927,4926,4925,4924,4923,4922,4921,4920,4919)
select a.`id`, a.`value` as `default`, a.`options`, b.`user_id`, b.`uid`, b.`type`, b.`value`,b.`id` as `pid` from `sls_social_privacy` as a inner join `sls_social_privacy_items` as b on a.`id` = b.`privacy_id` where b.uid IN (1517,1514,43,43,43,43,43,43) and b.type = 'users' UNION select a.`id`, a.`value` as `default`, a.`options`, b.`user_id`, b.`uid`, b.`type`, b.`value`,b.`id` as `pid` from `sls_social_privacy` as a inner join `sls_social_privacy_items` as b on a.`id` = b.`privacy_id` where b.uid IN (1155,936) and b.type = 'blog'
SELECT a.* , l.id as loc_id, l.uid as loc_uid, l.type as loc_type, l.user_id as loc_user_id, l.created as loc_created, l.short_address as loc_short_address ,l.address as loc_address, l.longitude as loc_longitude, l.latitude as loc_latitude, l.params as loc_params ,md.id as md_id, md.namespace as md_namespace,md.namespace_uid as md_namespace_uid, md.icon as md_icon, md.verb as md_verb, md.subject as md_subject, md.custom as md_custom ,md.text as md_text, md.user_id as md_user_id, md.created as md_created ,0 as bookmarked ,FLOOR( ( UNIX_TIMESTAMP( now() ) - UNIX_TIMESTAMP( a.`modified`) ) / 60 ) AS `min` ,FLOOR( ( UNIX_TIMESTAMP( now() ) - UNIX_TIMESTAMP( a.`modified`) ) / 60 / 60 ) AS `hour` ,FLOOR( ( UNIX_TIMESTAMP( now() ) - UNIX_TIMESTAMP( a.`modified`) ) / 60 / 60 / 24 ) AS `day` FROM `sls_social_stream` AS a LEFT JOIN `sls_social_locations` AS l ON a.`location_id` = l.`id` LEFT JOIN `sls_social_moods` AS md ON a.`mood_id` = md.`id` WHERE a.`state` = 1 AND ( (a.`cluster_id`= 0) OR (a.`cluster_id` > 0 and a.`cluster_access` = 1) ) AND a.`context_type` NOT IN ('article','parainvite') AND a.`access` = '0' ORDER BY a.`modified` DESC LIMIT 10,11
SELECT * FROM `sls_social_stream_item` as a WHERE `uid` IN ( 4918,4916) AND `context_type`='blog' UNION SELECT * FROM `sls_social_stream_item` as a WHERE `uid` IN ( 4917,4912,4911,4910,4909) AND `context_type`='users' UNION SELECT * FROM `sls_social_stream_item` as a WHERE `uid` IN ( 4907) AND `context_type`='users' UNION SELECT * FROM `sls_social_stream_item` as a WHERE `uid` IN ( 4908) AND `context_type`='story' UNION SELECT * FROM `sls_social_stream_item` as a WHERE `uid` IN ( 4906) AND `context_type`='profiles'
SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` FROM `sls_usergroups` AS a INNER JOIN `sls_user_usergroup_map` AS b ON a.`id` = b.`group_id` WHERE b.`user_id` IN (1444,1842,1964)
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`,`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 `sls_users` AS `a` LEFT JOIN `sls_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `sls_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `sls_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `sls_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `sls_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` IN ('1444', '1842', '1964') GROUP BY `a`.`id`
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1444'
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1842'
SELECT *
FROM sls_social_default_avatars
WHERE `id` = '1'
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1964'
SELECT * FROM `sls_social_stream_tags` WHERE `stream_id` IN('4918','4917','4916','4912','4911','4910','4909','4908','4907','4906') ORDER BY `stream_id`, `offset` DESC
SELECT a.* FROM `sls_social_likes` AS a INNER JOIN `sls_users` AS b ON a.`created_by` = b.`id` WHERE a.stream_id IN (4918,4917,4916,4912,4911,4910,4909,4908,4907,4906) AND b.`block` = '0'
select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4918) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4917) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4916) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4912) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4911) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4910) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4909) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4908) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4907) and `element` = 'stream.user' UNION select `uid`, `element`, `user_id` from `sls_social_shares` where `uid` IN (4906) and `element` = 'stream.user'
select * from `sls_social_shares` where id IN (1082,1842,1964)
select count(1) as `cnt`, x.`uid`, x.`element`, x.`stream_id` from `sls_social_comments` as x where stream_id IN (4918,4917,4916,4912,4911,4910,4909,4908,4907,4906) group by x.`element`, x.`uid`, x.`stream_id`
select x.* from `sls_social_comments` as x where x.stream_id IN (4918,4917,4916,4912,4911,4910,4909,4908,4907,4906)
select a.`id`, a.`value` as `default`, a.`options`, b.`user_id`, b.`uid`, b.`type`, b.`value`,b.`id` as `pid` from `sls_social_privacy` as a inner join `sls_social_privacy_items` as b on a.`id` = b.`privacy_id` where b.uid IN (1082) and b.type = 'blog' UNION select a.`id`, a.`value` as `default`, a.`options`, b.`user_id`, b.`uid`, b.`type`, b.`value`,b.`id` as `pid` from `sls_social_privacy` as a inner join `sls_social_privacy_items` as b on a.`id` = b.`privacy_id` where b.uid IN (4908) and b.type = 'story' UNION select a.`id`, a.`value` as `default`, a.`options`, b.`user_id`, b.`uid`, b.`type`, b.`value`,b.`id` as `pid` from `sls_social_privacy` as a inner join `sls_social_privacy_items` as b on a.`id` = b.`privacy_id` where b.uid IN (1842) and b.type = 'users' UNION select a.`id`, a.`value` as `default`, a.`options`, b.`user_id`, b.`uid`, b.`type`, b.`value`,b.`id` as `pid` from `sls_social_privacy` as a inner join `sls_social_privacy_items` as b on a.`id` = b.`privacy_id` where b.uid IN (1964) and b.type = 'profiles'
select a.`type`, a.`rule`, a.`id`, b.`value` as `default`, a.`options`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b ON a.`id` = b.`privacy_id` where b.`uid` = '1444' and b.`utype` = 'user' and a.`state` = '1'
select a.`type`, a.`rule`, a.`id`, b.`value` as `default`, a.`options`, 0 as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b ON a.`id` = b.`privacy_id` where b.`uid` = '1' and b.`utype` = 'profiles' and a.`state` = '1'
SELECT a.`type`, a.`rule`, a.`id`, a.`value` AS `default`, a.`options` , 0 as `mapid` FROM `sls_social_privacy` AS a where a.`state` = '1'
SELECT * FROM `sls_menu` WHERE `published` = '1' AND `link` LIKE 'index.php?option=com_easysocial%'
SELECT template FROM `sls_template_styles` AS s LEFT JOIN `sls_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 `a`.*,`b`.*,`c`.`element` FROM `sls_social_fields_data` AS `a` LEFT JOIN `sls_social_fields` AS `b` ON `a`.`field_id` = `b`.`id` LEFT JOIN `sls_social_apps` AS `c` ON `b`.`app_id` = `c`.`id` WHERE `a`.`uid` = '1964' AND `a`.`type` = 'user' AND `b`.`unique_key` = 'GENDER'
SELECT * FROM `sls_social_fields_options` WHERE `parent_id` = '9' ORDER BY `key` ASC,`ordering` ASC
select a.`id`, a.`value` as `default`, a.`options`, b.`user_id`, b.`uid`, b.`type`, b.`value`,b.`id` as `pid` from `sls_social_privacy` as a inner join `sls_social_privacy_items` as b on a.`id` = b.`privacy_id` where b.`uid` = '5058' and b.`type` = 'activity' and a.`state` = '1' and b.`user_id` = '1964'
select a.`type`, a.`rule`, a.`id`, b.`value` as `default`, a.`options`, b.`id` as `mapid` from `sls_social_privacy` as a inner join `sls_social_privacy_map` as b ON a.`id` = b.`privacy_id` where b.`uid` = '1964' and b.`utype` = 'user' and a.`state` = '1'
select a.`id`, a.`value` as `default`, a.`options`, b.`user_id`, b.`uid`, b.`type`, b.`value`,b.`id` as `pid` from `sls_social_privacy` as a inner join `sls_social_privacy_items` as b on a.`id` = b.`privacy_id` where b.`uid` = '5058' and b.`type` = 'activity' and a.`state` = '1' and b.`user_id` = '1964'
SELECT * FROM `sls_social_profiles` WHERE `default` = '1'
SELECT `a`.*,`b`.`element` AS `element`,`d`.`uid` AS `profile_id` FROM `sls_social_fields` AS `a` LEFT JOIN `sls_social_apps` AS `b` ON `b`.`id` = `a`.`app_id` LEFT JOIN `sls_social_fields_steps` AS `d` ON `a`.`step_id` = `d`.`id` WHERE `a`.`visible_mini_registration` = '1' AND `d`.`uid` = '1' AND `d`.`type` = 'profiles' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC
SELECT * FROM `sls_social_fields_options` WHERE `parent_id` IN ('2', '3', '4', '5', '167') ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC
SELECT *
FROM sls_social_registrations
WHERE `session_id` = '66j2ruds79mk9hm6ncr1t59o47'
SELECT COUNT(1) FROM `sls_social_registrations` WHERE `session_id`='66j2ruds79mk9hm6ncr1t59o47'
INSERT INTO `sls_social_registrations`
(`session_id`,`created`) VALUES
('66j2ruds79mk9hm6ncr1t59o47','2023-01-28 17:20:39')
SELECT *
FROM sls_social_profiles
WHERE `id` = '1'
SELECT `a`.*,`b`.`element` AS `element`,`d`.`uid` AS `profile_id` FROM `sls_social_fields` AS `a` LEFT JOIN `sls_social_apps` AS `b` ON `b`.`id` = `a`.`app_id` LEFT JOIN `sls_social_fields_steps` AS `d` ON `a`.`step_id` = `d`.`id` WHERE ( `a`.`core` = '1' OR `a`.`state` = '1' ) AND `d`.`uid` = '1' AND `d`.`type` = 'profiles' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC
SELECT * FROM `sls_social_fields_options` WHERE `parent_id` IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '165', '167', '14', '15', '16', '17', '18', '19') ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC
SELECT *
FROM sls_social_profiles
WHERE `id` = '1'
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
SELECT *
FROM sls_social_profiles
WHERE `id` = '1'