Oct 18, 2025 10:16:44 /flat/belarus/grodnenskaya-oblast/Grodno/931.html Error:/home/kdvby/public_html/cms/modules/user/nekofunction.php:1511
1050: Table 'temp_sect0_216_73_216_0' already exists
CREATE TABLE `temp_sect0_216_73_216_0` (SELECT SQL_CALC_FOUND_ROWS (@cnt := @cnt+ 1) AS current_row, s.`Section_ID`,d.`Data_ID`, CONCAT_WS(' ', a.`country`, a.`city`, a.`street`, CONCAT('д.', a.`house`), CONCAT('корп.', a.`housing`)) AS `address`, CONCAT(s.`Hidden_URL`,IF(d.`Keyword`<>'', d.`Keyword`, d.`Data_ID`), '.html') AS link, d.`User_ID` AS user_id, (SELECT COUNT(*) FROM `views` WHERE `Data_ID` = d.Data_ID AND `type` = 0 AND `Date` > '2025-09-18 10:16:44') AS `views`, (SELECT COUNT(*) FROM `views` WHERE `Data_ID` = d.Data_ID AND type = 1) AS `watch_phones`, IF(DATE_ADD(`priorityDate`, INTERVAL `priorityDays` DAY) >= NOW(), 1, 0) AS `is_priority`, IF(UNIX_TIMESTAMP(`Highlighting`) + `HighlightingDays`*3600*24 >= UNIX_TIMESTAMP(NOW()), 1, 0) AS `is_highlight`, IF (d.`Up2TopDate` IS NULL,0,1 ) as `is_upped`, IF(UNIX_TIMESTAMP(`priorityDate`) + `priorityDays`*3600*24 >= UNIX_TIMESTAMP(NOW()), DATE_FORMAT(DATE_ADD(`priorityDate`, INTERVAL `priorityDays` DAY), '%Y-%m-%d %H:%i:%s'), NULL) AS `date_priority_to_full`, IF(UNIX_TIMESTAMP(`Highlighting`) + `HighlightingDays`*3600*24 >= UNIX_TIMESTAMP(NOW()), DATE_FORMAT(DATE_ADD(`Highlighting`, INTERVAL `HighlightingDays` DAY), '%Y-%m-%d %H:%i:%s'), NULL) AS `date_highlighting_to_full`, DATE_FORMAT(`Up2TopDate`, '%Y-%m-%d %H:%i:%s') AS `date_top_full`, IF(UNIX_TIMESTAMP(`priorityDate`) + `priorityDays`*3600*24 >= UNIX_TIMESTAMP(NOW()), DATE_FORMAT(DATE_ADD(`priorityDate`, INTERVAL `priorityDays` DAY), '%d.%m %H:%i'), NULL) AS `date_priority_to`, IF(UNIX_TIMESTAMP(`Highlighting`) + `HighlightingDays`*3600*24 >= UNIX_TIMESTAMP(NOW()), DATE_FORMAT(DATE_ADD(`Highlighting`, INTERVAL `HighlightingDays` DAY), '%d.%m %H:%i'), NULL) AS `date_highlighting_to`, DATE_FORMAT(`Up2TopDate`, '%d.%m.%Y') AS `date_top`, DATE_FORMAT(`priorityDate`, '%d.%m.%Y') AS `date_priority`, DATE_FORMAT(`Highlighting`, '%d.%m.%Y') AS `date_highlighting`, s.`Section_ID` as `cityID`, DATE_FORMAT(d.`Created`, '%d.%m.%Y') AS `created`, COUNT( DISTINCT im.`Photo_ID` ) AS photo_count, im.`Photo_Name` AS `Photo`, l.`time_Name` AS `time_title`, d.`Data_ID` AS `object_id`, MIN(pr.`price`) AS min_price, MAX(pr.`price`) AS max_price, d. `coord`,d. `room`,d. `roomKvadr`,d. `washmachine`,d. `microwave`,d. `tv`,d. `internet`,d. `refrigerator`,d. `price`,d. `wifi`,d. `placeCount`,d. `info`,d. `pricecomment`,d. `step`,d. `priorityDays`,d. `priorityDate`,d. `Up2TopDate`,d. `hint`,d. `HighlightingDays`,d. `Highlighting`,d. `guests`,d. `floor`,d. `cFloor`,d. `docs`,d. `cashless`,d. `party`,d. `animal`,d. `smoking`,d. `registr`,d. `transfer`,d. `parking`,d. `air`,d. `jacuzzi`,d. `el_kettle`,d. `hairdryer`,d. `iron`,d. `elevator`,d. `title`,d. `min_time`,d. `time`,d. `cabel`,d. `3g`,d. `satellite`,d. `tvcabel`,d. `separately`,d. `doublePlace`,d. `archive`,d. `moderation`,d. `suspended`,d. `SEOTitle`,d. `SEODescr`,d. `SEOKeyword`,d. `SEOTitle_caption`,d. `SEOh1short`,d. `SEOh1full`,d. `keyword01`,d. `keyword02`,d. `keyword03`,d. `keyword04`,d. `keyword05`,d. `keyword06`,d. `keyword07`,d. `keyword08`,d. `keyword09`,d. `keyword10`,d. `keyword11`,d. `desc01`,d. `desc02`,d. `desc03`,d. `desc04`,d. `desc05`,d. `desc06`,d. `desc07`,d. `desc08`,d. `desc09`,d.Checked FROM `data42` d LEFT JOIN `section` AS s ON (s.`Section_ID` = d.`Section_ID`) LEFT JOIN `pricelist` AS pr ON (d.`Data_ID`= pr.`Data_ID` AND pr.`price`>0) LEFT JOIN `photolist` AS im ON d.`Data_ID` = im.`Data_ID` LEFT JOIN `address` AS a ON d.`Data_ID` = a.`Data_ID` LEFT JOIN `list_time` AS l ON d.`time` = l.`time_ID` WHERE 1 AND d.`Data_ID` = 931 AND d.`Checked` = 1 AND `step`=4 AND (d.`moderation` <> 1 OR d.`moderation` IS NULL) AND (d.`archive` <> 1 OR d.`archive` IS NULL) AND (d.`suspended` = 0 OR d.`suspended` IS NULL) GROUP BY d.`Data_ID` ORDER BY IF(DATE_ADD(`priorityDate`, INTERVAL `priorityDays` DAY) >= NOW(), 1, 0) DESC, IF(d.`Up2TopDate` IS NULL, d.`Created`,d.`Up2TopDate`) DESC, im.`num` )