SELECT i.options as options
FROM cms_controllers i
WHERE (i.name = 'messages')
LIMIT 1

system/controllers/users/model.php => getCount()

SELECT COUNT(i.id) as count
FROM cms_users_friends i
WHERE (i.user_id = '0') AND (i.friend_id = '1393') AND (i.is_mutual = '0')

system/controllers/content/model.php => get()

SELECT i.*
FROM cms_users_fields i
ORDER BY i.ordering
LIMIT 1000

system/controllers/users/model.php => get()

SELECT i.*, u.id as id, u.*
FROM cms_users_friends i
INNER JOIN cms_users as u ON u.id = i.friend_id
WHERE (i.user_id = '1393') AND (i.is_mutual = '1')
ORDER BY u.date_log desc

system/controllers/content/model.php => get()

SELECT i.*
FROM cms_content_types i
LIMIT 1000

system/controllers/content/model.php => getCount()

SELECT COUNT(i.id) as count
FROM cms_con_pages i
WHERE (i.user_id = '1393') AND ((i.is_private = 0 OR i.user_id = 0 OR (i.is_private = 1 AND EXISTS (SELECT id FROM cms_users_friends WHERE user_id=0 AND friend_id=i.user_id AND is_mutual=1)))) AND (i.is_approved = '1')

system/controllers/content/model.php => getCount()

SELECT COUNT(i.id) as count
FROM cms_con_posts i
WHERE (i.user_id = '1393') AND ((i.is_private = 0 OR i.user_id = 0 OR (i.is_private = 1 AND EXISTS (SELECT id FROM cms_users_friends WHERE user_id=0 AND friend_id=i.user_id AND is_mutual=1)))) AND (i.is_approved = '1')

system/controllers/content/model.php => getCount()

SELECT COUNT(i.id) as count
FROM cms_con_news i
WHERE (i.user_id = '1393') AND ((i.is_private = 0 OR i.user_id = 0 OR (i.is_private = 1 AND EXISTS (SELECT id FROM cms_users_friends WHERE user_id=0 AND friend_id=i.user_id AND is_mutual=1)))) AND (i.is_approved = '1')

system/controllers/content/model.php => getCount()

SELECT COUNT(i.id) as count
FROM cms_con_debati i
WHERE (i.user_id = '1393') AND ((i.is_private = 0 OR i.user_id = 0 OR (i.is_private = 1 AND EXISTS (SELECT id FROM cms_users_friends WHERE user_id=0 AND friend_id=i.user_id AND is_mutual=1)))) AND (i.is_approved = '1')

system/controllers/wall/model.php => getCount()

SELECT COUNT(i.id) as count
FROM cms_wall_entries i
WHERE (i.profile_id = '1393') AND (i.profile_type = 'user') AND (i.parent_id = '0')

system/controllers/wall/model.php => get()

SELECT i.*, COUNT(e.id) as replies_count, u.nickname as user_nickname, u.avatar as user_avatar
FROM cms_wall_entries i
LEFT JOIN cms_wall_entries as e ON e.parent_id = i.id
JOIN cms_users as u ON u.id = i.user_id
WHERE (i.profile_id = '1393') AND (i.profile_type = 'user') AND (i.parent_id = '0')
GROUP BY i.id
ORDER BY i.date_pub desc
LIMIT 0, 10

system/core/controller.php => getFieldFiltered()

SELECT i.options as options
FROM cms_controllers i
WHERE (i.name = 'markitup')
LIMIT 1

system/controllers/users/model.php => get()

SELECT i.*
FROM cms_users_tabs i
WHERE (i.is_active = '1')
ORDER BY i.ordering

system/controllers/users/model.php => getCount()

SELECT COUNT(i.id) as count
FROM cms_users_friends i
WHERE (i.user_id = '1393') AND (i.is_mutual = '1')

system/core/controller.php => getFieldFiltered()

SELECT i.options as options
FROM cms_controllers i
WHERE (i.name = 'groups')
LIMIT 1

system/controllers/groups/model.php => getCount()

SELECT COUNT(i.id) as count
FROM cms_groups i
JOIN cms_groups_members as m ON i.id = m.group_id AND m.user_id = '1393'

system/controllers/comments/model.php => getCount()

SELECT COUNT(i.id) as count
FROM cms_comments i
WHERE (i.user_id = '1393') AND (i.is_deleted IS NULL)