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 * FROM `sls_menu` WHERE `published` = '1' AND `link` LIKE 'index.php?option=com_easysocial%'
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` = 'gui1jpvgqtvs29ol4ghgfaucs5'
SELECT COUNT(1) FROM `sls_social_registrations` WHERE `session_id`='gui1jpvgqtvs29ol4ghgfaucs5'
INSERT INTO `sls_social_registrations`
(`session_id`,`created`) VALUES
('gui1jpvgqtvs29ol4ghgfaucs5','2022-08-10 22:23:14')
SELECT * FROM `sls_social_apps`
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 *
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_profiles
WHERE `id` = '1'