SELECT
`id`,
`email`,
`email_confirmation`,
`deleted`,
`status`,
`status_checked`,
`geo_version_id`,
`geo_country_id`,
`geo_region_id`,
`geo_city_id`,
`geo_area_id`,
`sex`,
`birthday`,
`nick`,
`surname`,
`name`,
`patronymic`,
`phone_id`,
`club_id`,
`club_status`,
UNIX_TIMESTAMP(`regdate`) AS `regdate`,
UNIX_TIMESTAMP(`date_news`) AS `date_news`,
`tw_id`,
`fb_id`,
`vk_id`,
`quest_hide`
FROM `users` WHERE `id` = "29339"
No such file or directory
INSERT INTO `read_view` (
`entry_id`,
`date`,
`count`
) VALUES (
25600,
NOW(),
1
)
ON DUPLICATE KEY UPDATE
`count` = ROUND(`count` + 1 + (`count` * 0.001))
No such file or directory UPDATE `read` SET `view` = ROUND(`view` + 1 + (`view` * 0.001)) WHERE `id` = 25600 No such file or directory SELECT `text` FROM `read` WHERE `id` = "25600" No such file or directory
SELECT
IF (`r`.`link_type` = "entry", `r`.`link_id`, `r`.`id`) AS `id`,
IF (`r`.`link_type` = "entry",
(COALESCE((SELECT `count` FROM `read_view` `vt` WHERE `vt`.`entry_id` = `r`.`link_id` AND DATE(`vt`.`date`) = DATE(NOW())), 0) * 0.035) +
(COALESCE((SELECT `count` FROM `read_view` `vy` WHERE `vy`.`entry_id` = `r`.`link_id` AND DATE(`vy`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 DAY))), 0) * 0.05) +
(COALESCE((SELECT `count` FROM `read_view` `va` WHERE `va`.`entry_id` = `r`.`link_id` AND DATE(`va`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -2 DAY))), 0) * 0.025) +
(COALESCE((SELECT `count` FROM `read_view` `va` WHERE `va`.`entry_id` = `r`.`link_id` AND DATE(`va`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -5 DAY))), 0) * 0.010) +
(COALESCE((SELECT `count` FROM `read_view` `va` WHERE `va`.`entry_id` = `r`.`link_id` AND DATE(`va`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 MONTH))), 0) * 0.003) +
(COALESCE((SELECT `count` FROM `read_view` `va` WHERE `va`.`entry_id` = `r`.`link_id` AND DATE(`va`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 YEAR))), 0) * 0.001) +
((SELECT COUNT(`ot`.`user_id`) AS `count` FROM `opinions` `ot` WHERE `ot`.`object_type` = "entry" AND `ot`.`object_id` = `r`.`link_id` AND DATE(`ot`.`date`) = DATE(NOW())) * 1) +
((SELECT COUNT(`oy`.`user_id`) AS `count` FROM `opinions` `oy` WHERE `oy`.`object_type` = "entry" AND `oy`.`object_id` = `r`.`link_id` AND DATE(`oy`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 DAY))) * 1.25) +
((SELECT COUNT(`oa`.`user_id`) AS `count` FROM `opinions` `oa` WHERE `oa`.`object_type` = "entry" AND `oa`.`object_id` = `r`.`link_id` AND DATE(`oa`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -2 DAY))) * 0.75) +
((SELECT COUNT(`oa`.`user_id`) AS `count` FROM `opinions` `oa` WHERE `oa`.`object_type` = "entry" AND `oa`.`object_id` = `r`.`link_id` AND DATE(`oa`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -2 DAY))) * 0.50) +
((SELECT COUNT(`oa`.`user_id`) AS `count` FROM `opinions` `oa` WHERE `oa`.`object_type` = "entry" AND `oa`.`object_id` = `r`.`link_id` AND DATE(`oa`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 MONTH))) * 0.10) +
((SELECT COUNT(`oa`.`user_id`) AS `count` FROM `opinions` `oa` WHERE `oa`.`object_type` = "entry" AND `oa`.`object_id` = `r`.`link_id` AND DATE(`oa`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 YEAR))) * 0.025) +
(COALESCE((SELECT `count` FROM `comments_users` `ct` WHERE `ct`.`object_type` = "entry" AND `ct`.`object_id` = `r`.`link_id` AND DATE(`ct`.`date`) = DATE(NOW())), 0) * 1) +
(COALESCE((SELECT `count` FROM `comments_users` `cy` WHERE `cy`.`object_type` = "entry" AND `cy`.`object_id` = `r`.`link_id` AND DATE(`cy`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 DAY))), 0) * 1.25) +
(COALESCE((SELECT `count` FROM `comments_users` `ca` WHERE `ca`.`object_type` = "entry" AND `ca`.`object_id` = `r`.`link_id` AND DATE(`ca`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -2 DAY))), 0) * 0.75) +
(COALESCE((SELECT `count` FROM `comments_users` `ca` WHERE `ca`.`object_type` = "entry" AND `ca`.`object_id` = `r`.`link_id` AND DATE(`ca`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -5 DAY))), 0) * 0.50) +
(COALESCE((SELECT `count` FROM `comments_users` `ca` WHERE `ca`.`object_type` = "entry" AND `ca`.`object_id` = `r`.`link_id` AND DATE(`ca`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 MONTH))), 0) * 0.10) +
(COALESCE((SELECT `count` FROM `comments_users` `ca` WHERE `ca`.`object_type` = "entry" AND `ca`.`object_id` = `r`.`link_id` AND DATE(`ca`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 YEAR))), 0) * 0.025)
,
(COALESCE((SELECT `count` FROM `read_view` `vt` WHERE `vt`.`entry_id` = `r`.`id` AND DATE(`vt`.`date`) = DATE(NOW())), 0) * 0.035) +
(COALESCE((SELECT `count` FROM `read_view` `vy` WHERE `vy`.`entry_id` = `r`.`id` AND DATE(`vy`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 DAY))), 0) * 0.05) +
(COALESCE((SELECT `count` FROM `read_view` `va` WHERE `va`.`entry_id` = `r`.`id` AND DATE(`va`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -2 DAY))), 0) * 0.025) +
(COALESCE((SELECT `count` FROM `read_view` `va` WHERE `va`.`entry_id` = `r`.`id` AND DATE(`va`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -5 DAY))), 0) * 0.010) +
(COALESCE((SELECT `count` FROM `read_view` `va` WHERE `va`.`entry_id` = `r`.`id` AND DATE(`va`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 MONTH))), 0) * 0.003) +
(COALESCE((SELECT `count` FROM `read_view` `va` WHERE `va`.`entry_id` = `r`.`id` AND DATE(`va`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 YEAR))), 0) * 0.001) +
((SELECT COUNT(`ot`.`user_id`) AS `count` FROM `opinions` `ot` WHERE `ot`.`object_type` = "entry" AND `ot`.`object_id` = `r`.`id` AND DATE(`ot`.`date`) = DATE(NOW())) * 1) +
((SELECT COUNT(`oy`.`user_id`) AS `count` FROM `opinions` `oy` WHERE `oy`.`object_type` = "entry" AND `oy`.`object_id` = `r`.`id` AND DATE(`oy`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 DAY))) * 1.25) +
((SELECT COUNT(`oa`.`user_id`) AS `count` FROM `opinions` `oa` WHERE `oa`.`object_type` = "entry" AND `oa`.`object_id` = `r`.`id` AND DATE(`oa`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -2 DAY))) * 0.75) +
((SELECT COUNT(`oa`.`user_id`) AS `count` FROM `opinions` `oa` WHERE `oa`.`object_type` = "entry" AND `oa`.`object_id` = `r`.`id` AND DATE(`oa`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -2 DAY))) * 0.50) +
((SELECT COUNT(`oa`.`user_id`) AS `count` FROM `opinions` `oa` WHERE `oa`.`object_type` = "entry" AND `oa`.`object_id` = `r`.`id` AND DATE(`oa`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 MONTH))) * 0.10) +
((SELECT COUNT(`oa`.`user_id`) AS `count` FROM `opinions` `oa` WHERE `oa`.`object_type` = "entry" AND `oa`.`object_id` = `r`.`id` AND DATE(`oa`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 YEAR))) * 0.025) +
(COALESCE((SELECT `count` FROM `comments_users` `ct` WHERE `ct`.`object_type` = "entry" AND `ct`.`object_id` = `r`.`id` AND DATE(`ct`.`date`) = DATE(NOW())), 0) * 1) +
(COALESCE((SELECT `count` FROM `comments_users` `cy` WHERE `cy`.`object_type` = "entry" AND `cy`.`object_id` = `r`.`id` AND DATE(`cy`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 DAY))), 0) * 1.25) +
(COALESCE((SELECT `count` FROM `comments_users` `ca` WHERE `ca`.`object_type` = "entry" AND `ca`.`object_id` = `r`.`id` AND DATE(`ca`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -2 DAY))), 0) * 0.75) +
(COALESCE((SELECT `count` FROM `comments_users` `ca` WHERE `ca`.`object_type` = "entry" AND `ca`.`object_id` = `r`.`id` AND DATE(`ca`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -5 DAY))), 0) * 0.50) +
(COALESCE((SELECT `count` FROM `comments_users` `ca` WHERE `ca`.`object_type` = "entry" AND `ca`.`object_id` = `r`.`id` AND DATE(`ca`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 MONTH))), 0) * 0.10) +
(COALESCE((SELECT `count` FROM `comments_users` `ca` WHERE `ca`.`object_type` = "entry" AND `ca`.`object_id` = `r`.`id` AND DATE(`ca`.`date`) = DATE(DATE_ADD(NOW(), INTERVAL -1 YEAR))), 0) * 0.025)
) AS `rank`
FROM `read` `r`
WHERE
`r`.`object_type` = "user" AND
`r`.`object_id` = 29339 AND
`r`.`link_type` IN ("entry", "none") AND
`r`.`deleted` = 0 AND
`r`.`hide` = 0
GROUP BY `r`.`id`
ORDER BY `rank` DESC
LIMIT 3
No such file or directory Пироговская набережная
Пироговская набережная
SELECT
`p`.`id`,
`p`.`company_id`,
`p`.`tariff_type`,
`p`.`tariff_count`,
`p`.`tariff_price`,
`p`.`limit_day`,
UNIX_TIMESTAMP(`p`.`date_end`) AS `date_end`,
`p`.`view`,
`c`.`place_id`,
`c`.`limit_type`,
`c`.`limit_count`,
`c`.`ext`,
`c`.`link`,
`c`.`target`,
`c`.`priority`,
`c`.`dealer`
FROM `ad_periods` `p`
RIGHT JOIN `ad_companies` `c` ON `c`.`id` = `p`.`company_id`
LEFT JOIN `ad_limits` `l` ON `l`.`company_id` = `p`.`company_id` AND `l`.`key` = "versions"
WHERE `c`.`place_id` = 4 AND `c`.`duplicate` = 1 AND `p`.`end` = 0 AND `p`.`date_start` <= NOW() AND `p`.`date_end` >= NOW() AND ((`l`.`value` = "8") OR `l`.`value` IS NULL)
GROUP BY `p`.`company_id`
No such file or directory
SELECT
`p`.`id`,
`p`.`company_id`,
`p`.`tariff_type`,
`p`.`tariff_count`,
`p`.`tariff_price`,
`p`.`limit_day`,
UNIX_TIMESTAMP(`p`.`date_end`) AS `date_end`,
`p`.`view`,
`c`.`place_id`,
`c`.`limit_type`,
`c`.`limit_count`,
`c`.`ext`,
`c`.`link`,
`c`.`target`,
`c`.`priority`,
`c`.`dealer`
FROM `ad_periods` `p`
RIGHT JOIN `ad_companies` `c` ON `c`.`id` = `p`.`company_id`
LEFT JOIN `ad_limits` `l` ON `l`.`company_id` = `p`.`company_id` AND `l`.`key` = "versions"
WHERE `c`.`place_id` = 4 AND `p`.`end` = 0 AND `p`.`date_start` <= NOW() AND `p`.`date_end` >= NOW() AND ((`l`.`value` = "8") OR `l`.`value` IS NULL)
GROUP BY `p`.`company_id`
No such file or directory