// // //
//
+8
5
Користувачі
Светік*)
Посилання на цю сторінку:
http://college.tim.ua/users/yakovenko
Улюблена музика:Не вказано
Контент користувача
Фото користувача
Друзі користувача
1093 дні тому
395 днів тому
1479 днів тому
1700 днів тому
2025 днів тому
1462 дні тому
Стіна користувача
Julianitas mk, 2 квітня 2012:

Светік*) не входить до клубів.

Час генерації сторінки: 1.0135 сек.
Запити до бази: 45
SET NAMES cp1251

SELECT * FROM cms_menu ORDER BY id ASC

SELECT id, title, link, config, internal, published, version, system FROM cms_components

SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id

SELECT id FROM cms_user_groups WHERE alias = 'guest'

DELETE FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE)

SELECT id as getfield FROM cms_online WHERE sess_id = 'fc7jqtbkn6ab2kbgmlkt7afsg7' AND ip = '54.158.214.111' LIMIT 1

INSERT INTO cms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.158.214.111', 'fc7jqtbkn6ab2kbgmlkt7afsg7', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/users/yakovenko')

SELECT id FROM cms_stats WHERE (ip = '54.158.214.111' AND page = '/users/yakovenko')

INSERT INTO cms_stats (ip, logdate, page, agent, refer) VALUES ('54.158.214.111', NOW(), '/users/yakovenko', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '')

SELECT NSLeft, NSRight FROM cms_menu WHERE id = '15'

SELECT id, title, link, linktype
                           FROM cms_menu
                           WHERE NSLeft <= 50 AND NSRight >= 51 AND parent_id > 0
                           ORDER BY NSLeft

SELECT id as getfield FROM cms_users WHERE login='yakovenko' ORDER BY is_deleted ASC LIMIT 1

SELECT		        
				u.id as id,
				u.login,
				u.nickname,
				u.email,
				u.icq,
		        u.is_deleted as is_deleted,
                u.regdate fregdate,
                u.birthdate as birthdate,
                u.status as status_text,
				DATE_FORMAT(u.status_date, '%d-%m-%Y %H:%i') as status_date,
                u.logdate as flogdate,
				u.rating as user_rating,
                p.city, p.description, p.showmail, p.showbirth, p.showicq,
				p.karma, p.imageurl, p.allow_who,
				p.gender as gender,	p.formsdata,			
				u.group_id,
				g.title as grp,
				g.alias as group_alias,
				o.user_id as status,
				b.user_id as banned,
                IFNULL(ui.login, '') as inv_login,
                IFNULL(ui.nickname, '') as inv_nickname
                FROM cms_users u
				INNER JOIN cms_user_profiles p ON p.user_id = u.id
				INNER JOIN cms_user_groups g ON g.id = u.group_id
				LEFT JOIN cms_online o ON o.user_id = u.id
				LEFT JOIN cms_banlist b ON b.user_id = u.id
                LEFT JOIN cms_users ui ON ui.id = u.invited_by
                WHERE u.is_locked = 0 AND u.id = '185'
                LIMIT 1

SELECT
				CASE
				WHEN f.from_id = 0
				THEN f.to_id
				WHEN f.to_id = 0
				THEN f.from_id
				END AS id, u.nickname as nickname, u.login as login
                FROM cms_user_friends f
				LEFT JOIN cms_users u ON u.id = CASE WHEN f.from_id = 0 THEN f.to_id WHEN f.to_id = 0 THEN f.from_id END
				WHERE (from_id = 0 OR to_id = 0) AND is_accepted =1

SELECT 1 FROM cms_user_friends WHERE (from_id = '185' OR to_id = '185') AND is_accepted =1

SELECT
			CASE
			WHEN f.from_id = 185
			THEN f.to_id
			WHEN f.to_id = 185
			THEN f.from_id
			END AS id_friends, u.id as id, u.nickname as nickname, u.login as login, u.is_deleted as is_deleted, u.status, p.imageurl as avatar, u.logdate as flogdate, o.id as online
			FROM cms_user_friends f
			LEFT JOIN cms_users u ON u.id = CASE WHEN f.from_id = 185 THEN f.to_id WHEN f.to_id = 185 THEN f.from_id END
			LEFT JOIN cms_user_profiles p ON p.user_id = u.id
            LEFT JOIN cms_online o ON p.user_id = o.user_id
			WHERE (from_id = '185' OR to_id = '185') AND is_accepted =1
			LIMIT 0, 6

SELECT *
			FROM cms_user_awards
			WHERE user_id = 185
			ORDER BY pubdate DESC

SELECT 1 FROM cms_user_wall WHERE user_id = 185 AND usertype = 'user'

SELECT w.*, g.gender, g.imageurl, u.nickname as author, u.login as author_login, u.is_deleted, w.pubdate
                    FROM cms_user_wall w
					INNER JOIN cms_users u ON u.id = w.author_id
					INNER JOIN cms_user_profiles g ON g.user_id = u.id
                    WHERE w.user_id = 185 AND w.usertype = 'user'
                    ORDER BY w.pubdate DESC
                    LIMIT 0, 10

SELECT u.*, c.title as title, c.id as id
			FROM cms_user_clubs u, cms_clubs c
			WHERE u.user_id = 185 AND u.club_id = c.id AND c.published = 1
			ORDER BY c.title DESC

SELECT title, id, admin_id
			FROM cms_clubs
			WHERE admin_id = 185 AND published = 1
			ORDER BY title DESC

SELECT 1 FROM cms_online WHERE user_id = '185'

SELECT SUM(points) as karma FROM cms_user_karma WHERE user_id = 185

SELECT
				CASE
				WHEN f.from_id = 0
				THEN f.to_id
				WHEN f.to_id = 0
				THEN f.from_id
				END AS id, u.nickname as nickname, u.login as login
                FROM cms_user_friends f
				LEFT JOIN cms_users u ON u.id = CASE WHEN f.from_id = 0 THEN f.to_id WHEN f.to_id = 0 THEN f.from_id END
				WHERE (from_id = 0 OR to_id = 0) AND is_accepted =1

SELECT 1 FROM cms_user_photos WHERE user_id=185 AND ( allow_who='all' OR (allow_who='registered' AND (0>0)) OR (allow_who='friends' AND (0=1)) )

SELECT 1 FROM cms_photo_files WHERE user_id=185 AND published = 1

SELECT a.id as id,
                       a.title as title,
                       a.pubdate as pubdate,
                       a.allow_who as allow_who,
                       'private' as type,
                       p.imageurl as imageurl,
                       COUNT(p.id) as photos_count
                FROM cms_user_photos p
				INNER JOIN cms_user_albums a ON a.id = p.album_id
                WHERE p.user_id='185' AND (
                                a.allow_who='all'
                                OR
                                (a.allow_who='registered' AND (0>0))
                                OR
                                (a.allow_who='friends' AND (0=1))
                            )
                GROUP BY p.album_id

SELECT  a.id as id,
                        a.title as title,
                        a.pubdate as pubdate,
                        'all' as allow_who,
                        'public' as type,
                        f.file as imageurl,
                        COUNT(f.id) as photos_count
                FROM cms_photo_files f
				LEFT JOIN cms_photo_albums a ON a.id = f.album_id
                WHERE f.user_id='185' AND f.published = 1
                GROUP BY f.album_id

SELECT 1 FROM cms_board_items WHERE user_id=185 AND published=1

SELECT 1 FROM cms_comments WHERE user_id=185 AND published=1

SELECT 1 FROM cms_forum_posts p LEFT JOIN cms_forum_threads t ON t.id = p.thread_id WHERE p.user_id = 185 AND t.is_hidden = 0

SELECT 1 FROM cms_user_files WHERE user_id = 185

SELECT id, seolink FROM cms_blogs WHERE owner="user" AND user_id = 185 ORDER BY owner LIMIT 1

SELECT *
			FROM cms_forms
			WHERE id = 3

SELECT * FROM cms_form_fields WHERE form_id = 3 ORDER BY ordering ASC

SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'top' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '15' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'sidebar' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '15' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'topmenu') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '15' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT NSLeft, NSRight, NSLevel FROM cms_menu WHERE id = '15' ORDER BY id ASC LIMIT 1

SELECT id as getfield FROM cms_menu WHERE parent_id=0 LIMIT 1

SELECT * FROM cms_menu WHERE id = 1 AND NSDiffer = ''

SELECT * FROM cms_menu WHERE NSLeft > 1 AND NSRight < 64 AND NSDiffer = '' ORDER BY NSLeft,ordering

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'maintop') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '15' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'mainbottom') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '15' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC