Компания Facebook зарегистрировала не один патент, что конечно само по себе не удивительно. Однако среди них есть один который привлек мое вниманием. Я говорю про патент №8,600,797, который описывает алгоритм, позволяющий вычислить приблизительный доход пользователя в зависимости от списка посещаемых сайтов.
В сети появился вирус, который заражает компьютеры пользователей Facebook. Принцип очень прост. Пользователь получает сообщение, что один из друзей отметил его на видео. Сообщение естественно с ссылкой. При переходе по ссылке человеку предлагается установить плагин, без которого не получится посмотреть видео ролик.
Самая известная во всем мира социальная сеть Facebook занимается созданием своей собственной платежной системы, которая позволит ее пользователям осуществлять покупки в сторонних приложениях с помощью своего "социального" аккаунта.
В мае 2012-го года компания Facebook начала релизацию своего нового проекта по предоставлению бесплатного Wi-Fi для своих пользователей. В замен, понимая где залогинился пользователь, Facebook получает его координаты.
SELECT b.id
FROMj25_usergroupsAS a
LEFTJOINj25_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `j25_viewlevels`
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROMj25_menuAS m
LEFTJOINj25_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
SHOWFULLCOLUMNS FROM `j25_easyblog_configs`
SELECT* FROMj25_easyblog_configs WHERE `name` = 'config'
SHOWFULLCOLUMNS FROM `j25_easyblog_tag`
SELECT* FROM `j25_easyblog_tag` WHERE (`title` = 'facebook' OR `title` = 'facebook' OR `alias` = 'facebook') LIMIT 1
DELETE FROM `j25_easyblog_mailq` WHERE `status`='1' ANDDATEDIFF(NOW(), `created`) >= 7
SELECT `id` FROM `j25_easyblog_mailq` WHERE `status` = 0 ORDERBY `created` ASC LIMIT 5
SELECT* FROM `j25_easyblog_post` WHERE `publish_up` <= '2025-05-14 21:38:35' AND `published` = '2' AND `ispending` = '0' ORDERBY `id` LIMIT 5
UPDATE `j25_easyblog_post` SET `published` = '0' WHERE `publish_down` > `publish_up` AND `publish_down` <= '2025-05-14 21:38:35' AND `publish_down` != '0000-00-00 00:00:00' AND `published` != '0' AND `published` != '3' AND `ispending` = '0'
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SHOWFULLCOLUMNS FROM `j25_assets`
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT b.rules
FROMj25_assetsAS a
LEFTJOINj25_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SHOWFULLCOLUMNS FROM `j25_easyblog_users`
SELECTCOUNT(*) FROM `j25_easyblog_configs` WHERE `name` = 'default'
SELECT* FROMj25_easyblog_configs WHERE `name` = 'default'
SELECT* FROM `j25_easyblog_acl` WHERE `published`=1 ORDERBY `id` ASC
SELECT* FROM `j25_easyblog_acl_group` WHERE `content_id`='1' AND `type`=' group'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_tag WHERE `id` = '38'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='facebook' AND `id`!='38'
SELECT id, keywords, description, indexing FROM `j25_easyblog_meta` WHERE content_id = '3' and type = 'view'
select `id` FROM `j25_easyblog_team` where `access` = '3' and `published` = '1'
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a left join `j25_easyblog_category_acl` as b on a.`id` = b.`category_id` and b.`acl_id` = '1' where a.`private` != '0' and b.`category_id` NOTIN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )
SELECT b.*, c.`title` as `category` FROM `j25_easyblog_post_tag` AS a INNERJOIN `j25_easyblog_post` AS b ON a.post_id=b.id LEFTJOIN `j25_easyblog_category` AS c ON b.category_id = c.id WHERE a.tag_id = '38' AND b.`published` = '1' AND b.`private` = '0' AND b.`issitewide` = '1' ORDERBY b.`created` desc LIMIT 0,10
SELECTCOUNT(1) FROM (SELECT b.*, c.`title` as `category` FROM `j25_easyblog_post_tag` AS a INNERJOIN `j25_easyblog_post` AS b ON a.post_id=b.id LEFTJOIN `j25_easyblog_category` AS c ON b.category_id = c.id WHERE a.tag_id = '38' AND b.`published` = '1' AND b.`private` = '0' AND b.`issitewide` = '1' ORDERBY b.`created` desc) as x
SELECTCOUNT(1) FROM (SELECT b.*, c.`title` as `category` FROM `j25_easyblog_post_tag` AS a INNERJOIN `j25_easyblog_post` AS b ON a.post_id=b.id LEFTJOIN `j25_easyblog_category` AS c ON b.category_id = c.id WHERE a.tag_id = '38' AND b.`published` = '1' AND b.`private` = '0' AND b.`issitewide` = '1' ORDERBY b.`created` desc) as x
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a left join `j25_easyblog_category_acl` as b on a.`id` = b.`category_id` and b.`acl_id` = '1' where a.`private` != '0' and b.`category_id` NOTIN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )
select count(1) from `j25_easyblog_post` as a inner join `j25_easyblog_post_tag` as b on a.`id` = b.`post_id` and b.`tag_id` = '38' where a.`private` = '1'
SHOWFULLCOLUMNS FROM `j25_easyblog_post`
SELECT* FROMj25_easyblog_users WHERE `id` = '81'
SHOWFULLCOLUMNS FROM `j25_users`
SELECT* FROM `j25_users`
WHERE `id` = 81
SELECT `g`.`id`,`g`.`title`
FROM `j25_usergroups` AS g
INNERJOIN `j25_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 81
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '421' AND `type` = 'post'
SHOWFULLCOLUMNS FROM `j25_komento_configs`
SELECT* FROMj25_komento_configs WHERE `component` = 'com_komento'
SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id` WHERE b.`post_id` = '421' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='421' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '421' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '368' AND `type` = 'post'
SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id` WHERE b.`post_id` = '368' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='368' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '368' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '361' AND `type` = 'post'
SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id` WHERE b.`post_id` = '361' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='361' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '361' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '320' AND `type` = 'post'
SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id` WHERE b.`post_id` = '320' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='320' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '320' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '2'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '2'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '2'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '2'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_tag WHERE `id` = '38'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='facebook' AND `id`!='38'
SELECT* FROMj25_easyblog_post WHERE `id` = '421'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='421'
SHOWFULLCOLUMNS FROM `j25_easyblog_category`
SELECT* FROMj25_easyblog_category WHERE `id` = '2'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='news' AND `id`!='2'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_tag WHERE `id` = '38'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='facebook' AND `id`!='38'
SHOWFULLCOLUMNS FROM `j25_easyblog_ratings`
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='421' AND `type`='entry' AND `sessionid`='7bcafd650b8d812609ef2bdc9013a7fd'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='421' AND `type`='entry'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_post WHERE `id` = '368'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='368'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_tag WHERE `id` = '11'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='google' AND `id`!='11'
SELECT* FROMj25_easyblog_tag WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='bezopasnost' AND `id`!='6'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='368' AND `type`='entry' AND `sessionid`='7bcafd650b8d812609ef2bdc9013a7fd'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='368' AND `type`='entry'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_post WHERE `id` = '361'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='361'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='361' AND `type`='entry' AND `sessionid`='7bcafd650b8d812609ef2bdc9013a7fd'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='361' AND `type`='entry'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_post WHERE `id` = '320'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='320'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_tag WHERE `id` = '28'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='cisco' AND `id`!='28'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='320' AND `type`='entry' AND `sessionid`='7bcafd650b8d812609ef2bdc9013a7fd'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='320' AND `type`='entry'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_tag WHERE `id` = '38'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='facebook' AND `id`!='38'
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_tagmeta_rules WHERE ( ( ('/easyblog/tags/tag/facebook' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/easyblog/tags/tag/facebook' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/facebook' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/facebook' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/easyblog/tags/tag/facebook' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/easyblog/tags/tag/facebook' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/facebook' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/facebook' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only=0) ) ) AND published=1 ORDERBY ordering
52 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
34 × SELECT id FROMj25_assets
7 × SELECT* FROMj25_easyblog_tag
7 × SELECTCOUNT(1) FROM `j25_easyblog_tag`
4 × SELECT `title`, `id` FROM `j25_easyblog_category`
4 × SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id`
4 × SELECTCOUNT(1) FROM `j25_easyblog_comment`
4 × SELECTCOUNT(1) FROM `j25_easyblog_featured`
4 × SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id`
4 × SELECT* FROMj25_easyblog_post
4 × SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings`
4 × SELECT `id` FROM `j25_menu`
4 × SELECT* FROM `j25_easyblog_ratings`
4 × SELECT a.* FROM `j25_easyblog_post` as a
2 × SELECTCOUNT(1) FROM (SELECT b.*, c.`title` as `category` FROM `j25_easyblog_post_tag` AS a INNERJOIN `j25_easyblog_post` AS b ON a.post_id=b.id LEFTJOIN `j25_easyblog_category` AS c ON b.category_id = c.id
2 × SELECT* FROMj25_easyblog_configs
2 × select distinct a.`id`, a.`private` from `j25_easyblog_category` as a left join `j25_easyblog_category_acl` as b on a.`id` = b.`category_id` and b.`acl_id` = '1'
1 × SELECT* FROMj25_tagmeta_rules
1 × SELECT `g`.`id`,`g`.`title` FROM `j25_usergroups` AS g INNERJOIN `j25_user_usergroup_map` AS m ON m.group_id = g.id
1 × SELECT* FROM `j25_users`
1 × SELECTCOUNT(1) FROM `j25_easyblog_category`
1 × SELECT* FROMj25_easyblog_category
1 × SELECT* FROMj25_komento_configs
1 × SELECT b.*, c.`title` as `category` FROM `j25_easyblog_post_tag` AS a INNERJOIN `j25_easyblog_post` AS b ON a.post_id=b.id LEFTJOIN `j25_easyblog_category` AS c ON b.category_id = c.id
1 × SELECT `id` FROM `j25_easyblog_mailq`
1 × SELECT* FROM `j25_easyblog_post`
1 × SELECT a.rules FROMj25_assetsAS a
1 × SELECT* FROM `j25_easyblog_tag`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROMj25_menuAS m LEFTJOINj25_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT b.id FROMj25_usergroupsAS a LEFTJOINj25_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `j25_viewlevels
1 × SELECT b.rules FROMj25_assetsAS a LEFTJOINj25_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECTCOUNT(*) FROM `j25_easyblog_configs`
1 × SELECT `session_id` FROM `j25_session`
1 × select count(1) from `j25_easyblog_post` as a inner join `j25_easyblog_post_tag` as b on a.`id` = b.`post_id` and b.`tag_id` = '38'
1 × select `id` FROM `j25_easyblog_team`
1 × SELECT id, keywords, description, indexing FROM `j25_easyblog_meta`