| |
Could not query hr_url
DEBUG MODE
SQL Error : 1 Can't create/write to file '/tmp/#sql_27b8_0.MYI' (Errcode: 122)
SELECT *, url_id as urlid, url_rec_cnt + user_session_time / 1227083265 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (56546, 56548, 56550, 57426, 57437, 57441, 57443, 57446, 57449, 57456, 57457, 57481, 57841, 58002, 58004, 58005, 58006, 58007, 58009, 58011, 58012, 58013, 58014, 58016, 58017, 58021, 58027, 58029, 58031, 58032, 58033, 58035, 58036, 58038, 58040, 58042, 58043, 58045, 58046, 58047, 58048, 58049, 58051, 58052, 58054, 58056, 58057, 58059, 58060, 58062, 58063, 58064, 58065, 58067, 58068, 58069, 58071, 58072, 58077, 58078, 58079, 58081, 58102, 58103, 58104, 58105, 58106, 58107, 58108, 58109, 58121, 58122, 58123, 58124, 58125, 58126, 58204, 58205, 58206, 58207, 58208, 58210, 58212, 58214, 58218, 58219, 58223, 58224, 58228, 58230, 58231, 58234, 58235, 58240, 58244, 58250, 58251, 58254, 58257, 58258, 58259, 58266, 58267, 58272, 58274, 58275, 58277, 58278, 58300, 58301, 58313, 58319, 58320, 58321, 58324, 58325, 58327, 58330, 58332, 58333, 58335, 58337, 58341, 58343, 58344, 58345, 58346, 58348, 58351, 58356, 58357, 58359, 58361, 58362, 58368, 58370, 58371, 58374, 58377, 58379, 58380, 58381, 58382, 58386, 58401, 58402, 58405, 58413, 58415, 58416, 58418, 58420, 58421, 58422, 58423, 58424, 58425, 58426, 58428, 58429, 58430, 58431, 58432, 58433, 58436, 58438, 58439, 58440, 58441, 58442, 58443, 58444, 58445, 58448, 58451, 58452, 58454, 58455, 58456, 58458, 58460, 58461, 58463, 58464, 58466, 58467, 58472, 58474, 58475, 58476, 58477, 58478, 58479, 58480, 58481, 58482, 58483, 58484, 58486, 58487, 58488, 58489, 58490, 58492, 58494, 58495, 58496, 58497, 58501, 58502, 58503, 58504, 58505, 58506, 58507, 58521, 58524, 58532, 58542, 58544, 58549, 58552, 58553, 58554, 58558, 58559, 58560, 58561, 58572, 58573, 58579, 58581, 58710, 58723, 58736, 58747, 58758)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
