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` = '5aoh516n9frpet8dos8sukrjh1'
SELECT COUNT(1) FROM `sls_social_registrations` WHERE `session_id`='5aoh516n9frpet8dos8sukrjh1'
INSERT INTO `sls_social_registrations`
(`session_id`,`created`) VALUES
('5aoh516n9frpet8dos8sukrjh1','2022-12-08 22:09:46')
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'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sls_modules AS m
LEFT JOIN sls_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN sls_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up = '2022-12-08 22:09:47') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 120 OR mm.menuid