Замена ссылок SQL запросом на DLE

Проблемы и их решение
У вас был домен, например bincobox.com. Домен сменили на новый: vova1234.com, а ссылки остались прежними то в таблицах.

Для этого заходим в PHP My Admin, пишем:

UPDATE dle_post SET short_story = REPLACE (short_story, 'bincobox.com', 'vova1234.com');
UPDATE dle_post SET full_story = REPLACE (full_story, 'bincobox.com', 'vova1234.com');

Эпик на sib.fm

Интернет и сайты
Не посещаю такие сайты вообще, просто по ссылке случайно попал:


Сколько же запросов:
string(343) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE `Tag`.`slug` = 'obovsem'» string(848) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `posts` AS `Post` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = `Post`.`id` AND `PostsTag`.`tag_id` = (29)) WHERE NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:41' AND `Post`.`status` = ('active') ORDER BY `Post`.`published` DESC LIMIT 3» string(477) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (14909, 14876, 14877) AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(694) «SELECT `Author`.`id`, `Author`.`email`, `Author`.`login`, `Author`.`password`, `Author`.`salt`, `Author`.`token`, `Author`.`role`, `Author`.`name`, `Author`.`name_alt`, `Author`.`subtitle`, `Author`.`slug`, `Author`.`url`, `Author`.`gender`, `Author`.`data`, `Author`.`created`, `Author`.`allowed_types`, `Author`.`allowed_actions`, `Author`.`marks`, `Author`.`status`, `Author`.`salary`, `Author`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Author` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` IN (14909, 14876, 14877) AND `PeoplePost`.`person_id` = `Author`.`id`) WHERE `PeoplePost`.`relation_type` = 'Author' » string(345) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE `Tag`.`slug` = 'quotation'» string(895) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `posts` AS `Post` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = `Post`.`id` AND `PostsTag`.`tag_id` = (24)) WHERE NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:42' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877)) ORDER BY `Post`.`published` DESC LIMIT 1» string(460) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 14827 AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(677) «SELECT `Author`.`id`, `Author`.`email`, `Author`.`login`, `Author`.`password`, `Author`.`salt`, `Author`.`token`, `Author`.`role`, `Author`.`name`, `Author`.`name_alt`, `Author`.`subtitle`, `Author`.`slug`, `Author`.`url`, `Author`.`gender`, `Author`.`data`, `Author`.`created`, `Author`.`allowed_types`, `Author`.`allowed_actions`, `Author`.`marks`, `Author`.`status`, `Author`.`salary`, `Author`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Author` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` = 14827 AND `PeoplePost`.`person_id` = `Author`.`id`) WHERE `PeoplePost`.`relation_type` = 'Author' » string(345) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE `Tag`.`slug` = 'televizor'» string(902) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `posts` AS `Post` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = `Post`.`id` AND `PostsTag`.`tag_id` = (21)) WHERE NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:42' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827)) ORDER BY `Post`.`published` DESC LIMIT 5» string(491) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (14759, 14744, 14718, 14556, 14693) AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(708) «SELECT `Author`.`id`, `Author`.`email`, `Author`.`login`, `Author`.`password`, `Author`.`salt`, `Author`.`token`, `Author`.`role`, `Author`.`name`, `Author`.`name_alt`, `Author`.`subtitle`, `Author`.`slug`, `Author`.`url`, `Author`.`gender`, `Author`.`data`, `Author`.`created`, `Author`.`allowed_types`, `Author`.`allowed_actions`, `Author`.`marks`, `Author`.`status`, `Author`.`salary`, `Author`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Author` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` IN (14759, 14744, 14718, 14556, 14693) AND `PeoplePost`.`person_id` = `Author`.`id`) WHERE `PeoplePost`.`relation_type` = 'Author' » string(340) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE `Tag`.`slug` = 'main'» string(937) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `posts` AS `Post` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = `Post`.`id` AND `PostsTag`.`tag_id` = (22)) WHERE NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:42' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693)) ORDER BY `Post`.`published` DESC LIMIT 1» string(460) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 14912 AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(677) «SELECT `Author`.`id`, `Author`.`email`, `Author`.`login`, `Author`.`password`, `Author`.`salt`, `Author`.`token`, `Author`.`role`, `Author`.`name`, `Author`.`name_alt`, `Author`.`subtitle`, `Author`.`slug`, `Author`.`url`, `Author`.`gender`, `Author`.`data`, `Author`.`created`, `Author`.`allowed_types`, `Author`.`allowed_actions`, `Author`.`marks`, `Author`.`status`, `Author`.`salary`, `Author`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Author` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` = 14912 AND `PeoplePost`.`person_id` = `Author`.`id`) WHERE `PeoplePost`.`relation_type` = 'Author' » string(826) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url` FROM `posts` AS `Post` WHERE `Post`.`type` = 'news' AND NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:42' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693, 14912)) ORDER BY `Post`.`published` DESC LIMIT 6» string(498) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (14913, 14906, 14822, 14908, 14910, 14902) AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(341) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE `Tag`.`slug` = 'stick'» string(987) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `posts` AS `Post` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = `Post`.`id` AND `PostsTag`.`tag_id` = (74)) WHERE NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:42' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693, 14912, 14913, 14906, 14822, 14908, 14910, 14902)) ORDER BY `Post`.`published` DESC LIMIT 10» string(484) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (14741, 14746, 14734, 14596) AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(701) «SELECT `Author`.`id`, `Author`.`email`, `Author`.`login`, `Author`.`password`, `Author`.`salt`, `Author`.`token`, `Author`.`role`, `Author`.`name`, `Author`.`name_alt`, `Author`.`subtitle`, `Author`.`slug`, `Author`.`url`, `Author`.`gender`, `Author`.`data`, `Author`.`created`, `Author`.`allowed_types`, `Author`.`allowed_actions`, `Author`.`marks`, `Author`.`status`, `Author`.`salary`, `Author`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Author` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` IN (14741, 14746, 14734, 14596) AND `PeoplePost`.`person_id` = `Author`.`id`) WHERE `PeoplePost`.`relation_type` = 'Author' » string(345) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE `Tag`.`slug` = 'threesome'» string(1014) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `posts` AS `Post` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = `Post`.`id` AND `PostsTag`.`tag_id` = (26)) WHERE NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:42' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693, 14912, 14913, 14906, 14822, 14908, 14910, 14902, 14741, 14746, 14734, 14596)) ORDER BY `Post`.`published` DESC LIMIT 6» string(498) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (14869, 14774, 14590, 14815, 14670, 14647) AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(715) «SELECT `Author`.`id`, `Author`.`email`, `Author`.`login`, `Author`.`password`, `Author`.`salt`, `Author`.`token`, `Author`.`role`, `Author`.`name`, `Author`.`name_alt`, `Author`.`subtitle`, `Author`.`slug`, `Author`.`url`, `Author`.`gender`, `Author`.`data`, `Author`.`created`, `Author`.`allowed_types`, `Author`.`allowed_actions`, `Author`.`marks`, `Author`.`status`, `Author`.`salary`, `Author`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Author` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` IN (14869, 14774, 14590, 14815, 14670, 14647) AND `PeoplePost`.`person_id` = `Author`.`id`) WHERE `PeoplePost`.`relation_type` = 'Author' » string(347) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE `Tag`.`slug` = 'people-work'» string(1058) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `posts` AS `Post` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = `Post`.`id` AND `PostsTag`.`tag_id` = (1073)) WHERE NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:43' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693, 14912, 14913, 14906, 14822, 14908, 14910, 14902, 14741, 14746, 14734, 14596, 14869, 14774, 14590, 14815, 14670, 14647)) ORDER BY `Post`.`published` DESC LIMIT 5» string(488) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (13210, 10071, 9604, 9196, 8933) AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(705) «SELECT `Author`.`id`, `Author`.`email`, `Author`.`login`, `Author`.`password`, `Author`.`salt`, `Author`.`token`, `Author`.`role`, `Author`.`name`, `Author`.`name_alt`, `Author`.`subtitle`, `Author`.`slug`, `Author`.`url`, `Author`.`gender`, `Author`.`data`, `Author`.`created`, `Author`.`allowed_types`, `Author`.`allowed_actions`, `Author`.`marks`, `Author`.`status`, `Author`.`salary`, `Author`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Author` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` IN (13210, 10071, 9604, 9196, 8933) AND `PeoplePost`.`person_id` = `Author`.`id`) WHERE `PeoplePost`.`relation_type` = 'Author' » string(729) «SELECT `Sponsor`.`id`, `Sponsor`.`email`, `Sponsor`.`login`, `Sponsor`.`password`, `Sponsor`.`salt`, `Sponsor`.`token`, `Sponsor`.`role`, `Sponsor`.`name`, `Sponsor`.`name_alt`, `Sponsor`.`subtitle`, `Sponsor`.`slug`, `Sponsor`.`url`, `Sponsor`.`gender`, `Sponsor`.`data`, `Sponsor`.`created`, `Sponsor`.`allowed_types`, `Sponsor`.`allowed_actions`, `Sponsor`.`marks`, `Sponsor`.`status`, `Sponsor`.`salary`, `Sponsor`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Sponsor` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` IN (13210, 10071, 9604, 9196, 8933) AND `PeoplePost`.`person_id` = `Sponsor`.`id`) WHERE `PeoplePost`.`relation_type` = 'Sponsor' » string(345) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE `Tag`.`slug` = 'peoplesay'» string(1088) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `posts` AS `Post` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = `Post`.`id` AND `PostsTag`.`tag_id` = (27)) WHERE NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:43' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693, 14912, 14913, 14906, 14822, 14908, 14910, 14902, 14741, 14746, 14734, 14596, 14869, 14774, 14590, 14815, 14670, 14647, 13210, 10071, 9604, 9196, 8933)) ORDER BY `Post`.`published` DESC LIMIT 7» string(502) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (14346, 10987, 10874, 10762, 7733, 7364, 7146) AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(719) «SELECT `Author`.`id`, `Author`.`email`, `Author`.`login`, `Author`.`password`, `Author`.`salt`, `Author`.`token`, `Author`.`role`, `Author`.`name`, `Author`.`name_alt`, `Author`.`subtitle`, `Author`.`slug`, `Author`.`url`, `Author`.`gender`, `Author`.`data`, `Author`.`created`, `Author`.`allowed_types`, `Author`.`allowed_actions`, `Author`.`marks`, `Author`.`status`, `Author`.`salary`, `Author`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Author` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` IN (14346, 10987, 10874, 10762, 7733, 7364, 7146) AND `PeoplePost`.`person_id` = `Author`.`id`) WHERE `PeoplePost`.`relation_type` = 'Author' » string(1024) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url` FROM `posts` AS `Post` WHERE `Post`.`type` = 'infographics' AND NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:43' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693, 14912, 14913, 14906, 14822, 14908, 14910, 14902, 14741, 14746, 14734, 14596, 14869, 14774, 14590, 14815, 14670, 14647, 13210, 10071, 9604, 9196, 8933, 14346, 10987, 10874, 10762, 7733, 7364, 7146)) ORDER BY `Post`.`published` DESC LIMIT 1» string(460) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 13914 AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(1028) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url` FROM `posts` AS `Post` WHERE `Post`.`type` = 'oftheweek' AND NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:43' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693, 14912, 14913, 14906, 14822, 14908, 14910, 14902, 14741, 14746, 14734, 14596, 14869, 14774, 14590, 14815, 14670, 14647, 13210, 10071, 9604, 9196, 8933, 14346, 10987, 10874, 10762, 7733, 7364, 7146, 13914)) ORDER BY `Post`.`published` DESC LIMIT 1» string(460) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 14911 AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(349) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE `Tag`.`slug` = 'editorschoice'» string(1148) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `posts` AS `Post` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = `Post`.`id` AND `PostsTag`.`tag_id` = (28)) WHERE NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:43' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693, 14912, 14913, 14906, 14822, 14908, 14910, 14902, 14741, 14746, 14734, 14596, 14869, 14774, 14590, 14815, 14670, 14647, 13210, 10071, 9604, 9196, 8933, 14346, 10987, 10874, 10762, 7733, 7364, 7146, 13914, 14911)) ORDER BY `Post`.`published` DESC LIMIT 6» string(498) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (13904, 13006, 12648, 12431, 12413, 12393) AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(715) «SELECT `Author`.`id`, `Author`.`email`, `Author`.`login`, `Author`.`password`, `Author`.`salt`, `Author`.`token`, `Author`.`role`, `Author`.`name`, `Author`.`name_alt`, `Author`.`subtitle`, `Author`.`slug`, `Author`.`url`, `Author`.`gender`, `Author`.`data`, `Author`.`created`, `Author`.`allowed_types`, `Author`.`allowed_actions`, `Author`.`marks`, `Author`.`status`, `Author`.`salary`, `Author`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Author` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` IN (13904, 13006, 12648, 12431, 12413, 12393) AND `PeoplePost`.`person_id` = `Author`.`id`) WHERE `PeoplePost`.`relation_type` = 'Author' » string(343) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE `Tag`.`slug` = 'finally'» string(1190) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `posts` AS `Post` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = `Post`.`id` AND `PostsTag`.`tag_id` = (25)) WHERE NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:43' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693, 14912, 14913, 14906, 14822, 14908, 14910, 14902, 14741, 14746, 14734, 14596, 14869, 14774, 14590, 14815, 14670, 14647, 13210, 10071, 9604, 9196, 8933, 14346, 10987, 10874, 10762, 7733, 7364, 7146, 13914, 14911, 13904, 13006, 12648, 12431, 12413, 12393)) ORDER BY `Post`.`published` DESC LIMIT 1» string(460) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 14303 AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(677) «SELECT `Author`.`id`, `Author`.`email`, `Author`.`login`, `Author`.`password`, `Author`.`salt`, `Author`.`token`, `Author`.`role`, `Author`.`name`, `Author`.`name_alt`, `Author`.`subtitle`, `Author`.`slug`, `Author`.`url`, `Author`.`gender`, `Author`.`data`, `Author`.`created`, `Author`.`allowed_types`, `Author`.`allowed_actions`, `Author`.`marks`, `Author`.`status`, `Author`.`salary`, `Author`.`rate`, `PeoplePost`.`person_id`, `PeoplePost`.`post_id`, `PeoplePost`.`relation_type` FROM `people` AS `Author` JOIN `people_posts` AS `PeoplePost` ON (`PeoplePost`.`post_id` = 14303 AND `PeoplePost`.`person_id` = `Author`.`id`) WHERE `PeoplePost`.`relation_type` = 'Author' » string(1085) «SELECT `Post`.`id`, `Post`.`type`, `Post`.`title`, `Post`.`subtitle`, `Post`.`summary`, `Post`.`content`, `Post`.`after_content`, `Post`.`meta`, `Post`.`tags`, `Post`.`chars_count`, `Post`.`comment_count`, `Post`.`view_counter`, `Post`.`status`, `Post`.`visibility`, `Post`.`created`, `Post`.`updated`, `Post`.`published`, `Post`.`slug`, `Post`.`illustration`, `Post`.`illustration_notation`, `Post`.`quotation`, `Post`.`typo_data`, `Post`.`busy`, `Post`.`busyer`, `Post`.`map_data`, `Post`.`def_url` FROM `posts` AS `Post` WHERE `Post`.`type` = 'dailyphoto' AND NOT FIND_IN_SET('no mainpage', Post.visibility) AND `Post`.`published` < '2016-03-29 21:49:43' AND `Post`.`status` = ('active') AND NOT (`Post`.`id` IN (14909, 14876, 14877, 14827, 14759, 14744, 14718, 14556, 14693, 14912, 14913, 14906, 14822, 14908, 14910, 14902, 14741, 14746, 14734, 14596, 14869, 14774, 14590, 14815, 14670, 14647, 13210, 10071, 9604, 9196, 8933, 14346, 10987, 10874, 10762, 7733, 7364, 7146, 13914, 14911, 13904, 13006, 12648, 12431, 12413, 12393, 14303)) ORDER BY `Post`.`published` DESC LIMIT 2» string(470) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` IN (14632, 14617) AND `PostsTag`.`tag_id` = `Tag`.`id`) » string(450) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE FIND_IN_SET('mainpage', `Tag`.`marks`) > 0 AND FIND_IN_SET('coolstory', `Tag`.`marks`) > 0 ORDER BY `Tag`.`position` ASC LIMIT 5» string(447) «SELECT `Tag`.`id`, `Tag`.`type`, `Tag`.`type_text`, `Tag`.`title`, `Tag`.`subtitle`, `Tag`.`content`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`notation`, `Tag`.`image`, `Tag`.`marks`, `Tag`.`posts_tag_count`, `Tag`.`updated`, `Tag`.`meta_title`, `Tag`.`meta_description`, `Tag`.`position` FROM `tags` AS `Tag` WHERE FIND_IN_SET('mainpage', `Tag`.`marks`) > 0 AND NOT (`Tag`.`id` IN (1132, 219, 1140, 1275, 1272)) ORDER BY `Tag`.`updated` DESC»