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 `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` = '1786' GROUP BY `a`.`id`
SELECT COUNT(1) AS `count` FROM `sls_social_users` WHERE `user_id` = '1786'
SELECT 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` = '1786'
SELECT COUNT(1) FROM `sls_social_block_users` WHERE `user_id` = '1786' AND `target_id` = '0'
SELECT * FROM `sls_social_apps`
SELECT COUNT(1) FROM `sls_social_apps_map` WHERE `app_id` = '9' AND `uid` = '1786'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` = '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-22'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` = '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-23'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` = '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-24'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` = '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-25'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` = '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-26'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` = '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-27'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` = '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-28'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` != '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-22'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` != '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-23'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` != '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-24'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` != '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-25'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` != '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-26'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` != '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-27'
SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `user_id` = '1786' AND `parent_id` != '0' AND DATE_FORMAT( `created`, GET_FORMAT( DATE , "ISO" ) ) = '2023-01-28'
SELECT *
FROM sls_social_apps_map
WHERE `app_id` = '9' AND `uid` = '1786'
SELECT count(*) AS `totalVotes` FROM `sls_discuss_votes` WHERE `user_id`='1786'
SELECT `params` FROM `sls_discuss_configs` WHERE `name`='config'
SELECT COUNT(1) FROM `sls_discuss_posts` AS a WHERE a.`published` = '1' AND a.`user_id`='1786' AND a.`parent_id` = 0
SELECT DATEDIFF('2023-01-28 16:20:48', a.`created`) as `noofdays`, DATEDIFF('2023-01-28 16:20:48', a.`created`) as `daydiff`, TIMEDIFF('2023-01-28 16:20:48', a.`created`) as `timediff`, a.`id`, a.`title`, a.`alias`, a.`created`, a.`modified`, a.`replied`, a.`legacy`, a.`content`, a.`category_id`, a.`published`, a.`ordering`, a.`vote`, a.`hits`, a.`islock`, a.`featured`, a.`isresolve`, a.`isreport`, a.`user_id`, a.`parent_id`, a.`user_type`, a.`poster_name`, a.`poster_email`, a.`num_likes`, a.`num_negvote`, a.`sum_totalvote`,a.`answered`, a.`post_status`, a.`post_type`, pt.`title` AS `post_type_title`,pt.`suffix` AS `post_type_suffix`, count(b.id) as `num_replies`, c.`title` AS `category`, a.`password` FROM `sls_discuss_posts` AS a LEFT JOIN `sls_discuss_posts` AS b ON a.`id` = b.`parent_id` AND b.`published` = 1 LEFT JOIN `sls_discuss_category` AS c ON a.`category_id` = c.`id` LEFT JOIN `sls_discuss_post_types` AS pt ON a.`post_type` = pt.`alias` WHERE a.`published` = '1' AND a.`user_id`='1786' AND a.`parent_id` = 0 GROUP BY (a.id) ORDER BY a.`created` DESC LIMIT 0,5
SELECT DATEDIFF('2023-01-28 16:20:48', b.`created`) as `noofdays`, DATEDIFF('2023-01-28 16:20:48', b.`created`) as `daydiff`, TIMEDIFF('2023-01-28 16:20:48', b.`created`) as `timediff`, b.`id`, b.`title`, b.`alias`, b.`created`, b.`modified`, b.`replied`,b.`legacy`, b.`content`, b.`category_id`, b.`published`, b.`ordering`, b.`vote`, a.`hits`, b.`islock`, b.`featured`, b.`isresolve`, b.`isreport`, b.`user_id`, b.`parent_id`, b.`user_type`, b.`poster_name`, b.`poster_email`, b.`num_likes`, b.`num_negvote`, b.`sum_totalvote`, b.`answered`, b.`post_status`, b.`post_type`, pt.`title` AS `post_type_title`,pt.`suffix` AS `post_type_suffix`, count(a.id) as `num_replies`, c.`title` as `category`, b.`password` FROM `sls_discuss_posts` AS a INNER JOIN `sls_discuss_posts` AS b ON a.`parent_id` = b.`id` LEFT JOIN `sls_discuss_category` AS c ON c.`id` = b.`category_id` LEFT JOIN `sls_discuss_post_types` AS pt ON b.`post_type` = pt.`alias` WHERE a.`user_id` = '1786' AND a.`published` = '1' AND a.`parent_id` != '0' AND b.`published` = '1' AND b.`parent_id` = '0' GROUP BY b.`id`
SELECT DATEDIFF('2023-01-28 16:20:48', b.`created`) as `noofdays`, DATEDIFF('2023-01-28 16:20:48', b.`created`) as `daydiff`, TIMEDIFF('2023-01-28 16:20:48', b.`created`) as `timediff`, b.`id`, b.`title`, b.`alias`, b.`created`, b.`modified`, b.`replied`,b.`legacy`, b.`content`, b.`category_id`, b.`published`, b.`ordering`, b.`vote`, a.`hits`, b.`islock`, b.`featured`, b.`isresolve`, b.`isreport`, b.`user_id`, b.`parent_id`, b.`user_type`, b.`poster_name`, b.`poster_email`, b.`num_likes`, b.`num_negvote`, b.`sum_totalvote`, b.`answered`, b.`post_status`, b.`post_type`, pt.`title` AS `post_type_title`,pt.`suffix` AS `post_type_suffix`, count(a.id) as `num_replies`, c.`title` as `category`, b.`password` FROM `sls_discuss_posts` AS a INNER JOIN `sls_discuss_posts` AS b ON a.`parent_id` = b.`id` LEFT JOIN `sls_discuss_category` AS c ON c.`id` = b.`category_id` LEFT JOIN `sls_discuss_post_types` AS pt ON b.`post_type` = pt.`alias` WHERE a.`user_id` = '1786' AND a.`published` = '1' AND a.`parent_id` != '0' AND b.`published` = '1' AND b.`parent_id` = '0' GROUP BY b.`id` LIMIT 0, 20
SELECT count(*) AS `totalReplies` FROM `sls_discuss_posts` WHERE `user_id`='1786' AND `parent_id`!='0' AND `published`='1'
select distinct a.`id`, a.`private` from `sls_discuss_category` as a left join `sls_discuss_category_acl_map` as b on a.`id` = b.`category_id` and b.`acl_id` = '2' and b.`type` = 'group' where a.`private` != '0' and a.`id` NOT IN ( SELECT c.category_id FROM `sls_discuss_category_acl_map` as c WHERE c.acl_id = '2' AND c.type = 'group' AND c.content_id IN ('1') )
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 (SELECT COUNT(1) FROM `sls_discuss_polls` WHERE `post_id` = a.`id`) AS `polls_cnt`, (SELECT COUNT(1) FROM `sls_discuss_favourites` WHERE `post_id` = a.`id`) AS `totalFavourites`,(SELECT COUNT(1) FROM `sls_discuss_posts` WHERE `parent_id` = a.`id` AND `published`="1") AS `num_replies`, (SELECT COUNT(1) FROM `sls_discuss_attachments` WHERE `uid` = a.`id` AND `type`='questions' AND `published`='1') AS `attachments_cnt`, '0' as `isVoted`, a.`post_status`, a.`post_type`, pt.`suffix` AS post_type_suffix, pt.`title` AS post_type_title , a.*, e.`title` AS `category`, a.`legacy`, IF(a.`replied` = '0000-00-00 00:00:00', a.`created`, a.`replied`) as `lastupdate`, (select count(1) from `sls_discuss_votes` where post_id = a.id) as `total_vote_cnt` FROM `sls_discuss_posts` AS a LEFT JOIN `sls_discuss_post_types` AS pt ON a.`post_type`= pt.`alias` LEFT JOIN `sls_discuss_category` AS e ON a.`category_id`=e.`id` LEFT JOIN `sls_discuss_favourites` AS f ON f.`post_id` = a.`id` WHERE a.`published` = '1' AND f.`created_by` = '0' AND a.`parent_id` = '0' AND a.`answered` = '0' AND a.`private`='0' ORDER BY a.`replied` DESC LIMIT 0, 20
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.`id`, a.`type`, a.`rule`, a.`options`, b.`value` 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' order by a.`type`
select a.`type`, a.`rule`, b.`value`, a.`id`, 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` = '1786' and b.`utype` = 'user' and a.`state` = '1' order by a.`type`
SELECT COUNT(1) FROM `sls_social_apps` AS `a` LEFT JOIN `sls_social_apps_map` AS `b` ON `b`.`app_id` = `a`.`id` AND `b`.`uid` = '1786' AND `b`.`type` = 'user' INNER JOIN `sls_social_apps_views` AS `c` ON `c`.`app_id` = `a`.`id` AND `c`.`view` = 'profile' WHERE `a`.`state` = '1' AND ( `a`.`default` = '1' OR `b`.`id` IS NOT NULL )
SELECT `a`.* FROM `sls_social_apps` AS `a` LEFT JOIN `sls_social_apps_map` AS `b` ON `b`.`app_id` = `a`.`id` AND `b`.`uid` = '1786' AND `b`.`type` = 'user' INNER JOIN `sls_social_apps_views` AS `c` ON `c`.`app_id` = `a`.`id` AND `c`.`view` = 'profile' WHERE `a`.`state` = '1' AND ( `a`.`default` = '1' OR `b`.`id` IS NOT NULL )
SELECT COUNT(1) FROM `sls_social_apps` AS `a` LEFT JOIN `sls_social_apps_map` AS `b` ON `b`.`app_id` = `a`.`id` AND `b`.`uid` = '1786' AND `b`.`type` = 'user' WHERE `a`.`state` = '1' AND `a`.`group` = 'user' AND `a`.`widget` = '1' AND ( `a`.`default` = '1' OR `b`.`id` IS NOT NULL OR `a`.`system` = '1' )
SELECT `a`.* FROM `sls_social_apps` AS `a` LEFT JOIN `sls_social_apps_map` AS `b` ON `b`.`app_id` = `a`.`id` AND `b`.`uid` = '1786' AND `b`.`type` = 'user' WHERE `a`.`state` = '1' AND `a`.`group` = 'user' AND `a`.`widget` = '1' AND ( `a`.`default` = '1' OR `b`.`id` IS NOT NULL OR `a`.`system` = '1' )
SELECT * FROM `sls_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
SELECT `b`.* FROM `sls_social_avatars` AS `a` INNER JOIN `sls_social_photos` AS `b` ON `a`.`photo_id` = `b`.`id` WHERE `a`.`uid` = '1786' AND `a`.`type` = 'user'
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` = '761' and b.`type` = 'photos' and a.`state` = '1' and b.`user_id` = '1786'
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` = '1786' and b.`utype` = 'user' 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_social_default_avatars` WHERE `uid`='1' AND `type`='profiles'
SELECT COUNT(1) FROM `sls_session` WHERE `userid`='1786'
SELECT `id` FROM `sls_social_subscriptions` WHERE `uid` = '1786' AND `type` = 'user.user' AND `user_id` = '0'
SELECT * FROM `sls_menu` WHERE `published` = '1' AND `link` LIKE 'index.php?option=com_easysocial%'
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`.`unique_key` = 'HEADLINE' AND `d`.`uid` = '1' AND `d`.`type` = 'profiles' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC
SELECT COUNT(1) FROM `sls_social_friends` AS a INNER JOIN `sls_users` AS uu ON uu.`id` = if( a.`target_id` = '1786', a.`actor_id`, a.`target_id`) WHERE uu.`block` = '0' AND ( ( a.`target_id`='1786' AND a.`state` = '1' ) OR ( a.`actor_id`='1786' AND a.`state` = '1' ) )
SELECT COUNT(1) FROM `sls_social_subscriptions` AS `a` INNER JOIN `sls_users` AS `uu` ON `a`.`user_id` = `uu`.`id` WHERE `a`.`type` = 'user.user' AND `a`.`uid` = '1786' AND `uu`.`block` = '0'
SELECT COUNT(1) FROM `sls_social_badges_maps` AS `a` INNER JOIN `sls_social_badges` AS `b` ON `a`.`badge_id` = `b`.`id` WHERE `a`.`user_id` = '1786' AND `b`.`state` = '1'
SELECT *
FROM sls_social_profiles
WHERE `id` = '1'
SELECT `a`.*,`b`.`custom_message` AS `custom_message`,`b`.`created` AS `achieved_date` FROM `sls_social_badges` AS `a` LEFT JOIN `sls_social_badges_maps` AS `b` ON `b`.`badge_id` = `a`.`id` WHERE `b`.`user_id` = '1786' AND `a`.`state` = '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`.`unique_key` = 'BIRTHDAY' AND `d`.`uid` = '1' AND `d`.`type` = 'profiles' ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC
SELECT * FROM `sls_social_fields_data` WHERE `uid` = '1786' AND `type` = 'user' ORDER BY `field_id` ASC,`datakey` ASC
SELECT * FROM `sls_social_fields_options` WHERE `parent_id` IN ('10') ORDER BY `parent_id` ASC,`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` = '10' and b.`type` = 'field' and a.`state` = '1' and b.`user_id` = '1786'
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` = '10' and b.`type` = 'year' and a.`state` = '1' and b.`user_id` = '1786'
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`.`unique_key` = 'GENDER' 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 ('9') ORDER BY `parent_id` ASC,`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` = '9' and b.`type` = 'field' and a.`state` = '1' and b.`user_id` = '1786'
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`.`unique_key` = 'ADDRESS' 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 ('11') ORDER BY `parent_id` ASC,`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` = '11' and b.`type` = 'field' and a.`state` = '1' and b.`user_id` = '1786'
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`.`unique_key` = 'URL' 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 ('13') ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC
SELECT * FROM `sls_social_apps_views`
SELECT DISTINCT(a.id) FROM `sls_social_clusters` AS `a` INNER JOIN `sls_social_clusters_nodes` AS `c` ON `a`.`id` = `c`.`cluster_id` WHERE `a`.`cluster_type` = 'group' AND `c`.`uid` = '1786' AND `c`.`state` = '1' AND `a`.`type` IN ('2', '1') AND `a`.`state` = '1' ORDER BY `a`.`created` DESC
SELECT COUNT(1) FROM `sls_social_clusters_nodes` AS `a` INNER JOIN `sls_social_clusters` AS `b` ON `b`.`id` = `a`.`cluster_id` WHERE `a`.`uid` = '1786' AND `a`.`type` = 'user' AND `a`.`state` = '1' AND `b`.`state` = '1' AND `b`.`cluster_type` = 'group' AND `b`.`type` IN ('2', '1')
SELECT COUNT(1) FROM (SELECT DISTINCT `a`.`id` AS `id` FROM `sls_social_clusters` AS `a` LEFT JOIN `sls_social_events_meta` AS `b` ON `a`.`id` = `b`.`cluster_id` WHERE `a`.`cluster_type` = 'event' AND `a`.`type` IN ('1','2') AND `a`.`creator_uid` = '1786' AND `a`.`creator_type` = 'user' AND `a`.`state` = '1' AND `b`.`start` >= '2023-01-28 16:20:49') AS zcount
SELECT DISTINCT `a`.`id` AS `id` FROM `sls_social_clusters` AS `a` LEFT JOIN `sls_social_events_meta` AS `b` ON `a`.`id` = `b`.`cluster_id` WHERE `a`.`cluster_type` = 'event' AND `a`.`type` IN ('1','2') AND `a`.`creator_uid` = '1786' AND `a`.`creator_type` = 'user' AND `a`.`state` = '1' AND `b`.`start` >= '2023-01-28 16:20:49' ORDER BY `b`.`start` asc LIMIT 0, 5
SELECT COUNT(DISTINCT(`a`.`id`)) AS `id` FROM `sls_social_clusters` AS `a` LEFT JOIN `sls_social_events_meta` AS `b` ON `a`.`id` = `b`.`cluster_id` WHERE `a`.`cluster_type` = 'event' AND `a`.`type` IN ('1', '2') AND `a`.`creator_uid` = '1786' AND `a`.`creator_type` = 'user' AND `a`.`state` = '1' AND `b`.`start` >= '2023-01-28 16:20:49'
SELECT COUNT(1) FROM (SELECT DISTINCT `a`.`id` AS `id` FROM `sls_social_clusters` AS `a` LEFT JOIN `sls_social_events_meta` AS `b` ON `a`.`id` = `b`.`cluster_id` LEFT JOIN `sls_social_clusters_nodes` AS `c` ON `a`.`id` = `c`.`cluster_id` WHERE `a`.`cluster_type` = 'event' AND `a`.`type` IN ('1','2') AND `a`.`state` = '1' AND `c`.`uid` = '1786' AND `c`.`state` = '1' AND `b`.`start` >= '2023-01-28 16:20:49') AS zcount
SELECT DISTINCT `a`.`id` AS `id` FROM `sls_social_clusters` AS `a` LEFT JOIN `sls_social_events_meta` AS `b` ON `a`.`id` = `b`.`cluster_id` LEFT JOIN `sls_social_clusters_nodes` AS `c` ON `a`.`id` = `c`.`cluster_id` WHERE `a`.`cluster_type` = 'event' AND `a`.`type` IN ('1','2') AND `a`.`state` = '1' AND `c`.`uid` = '1786' AND `c`.`state` = '1' AND `b`.`start` >= '2023-01-28 16:20:49' ORDER BY `b`.`start` asc LIMIT 0, 5
SELECT COUNT(DISTINCT(`a`.`id`)) AS `id` FROM `sls_social_clusters` AS `a` LEFT JOIN `sls_social_events_meta` AS `b` ON `a`.`id` = `b`.`cluster_id` LEFT JOIN `sls_social_clusters_nodes` AS `c` ON `a`.`id` = `c`.`cluster_id` WHERE `a`.`cluster_type` = 'event' AND `a`.`type` IN ('1', '2') AND `a`.`state` = '1' AND `c`.`uid` = '1786' AND `c`.`state` = '1' AND `b`.`start` >= '2023-01-28 16:20:49'
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