| |
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 / 1227089328 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1>1500 and user_zip in (56510, 56513, 56516, 56517, 56519, 56521, 56523, 56525, 56529, 56535, 56536, 56540, 56541, 56542, 56545, 56546, 56547, 56548, 56549, 56550, 56552, 56554, 56556, 56557, 56560, 56561, 56562, 56563, 56566, 56568, 56569, 56574, 56580, 56581, 56584, 56585, 56589, 56592, 56634, 56644, 56646, 56651, 56682, 56684, 56701, 56710, 56712, 56713, 56714, 56715, 56716, 56720, 56721, 56722, 56723, 56724, 56725, 56726, 56727, 56728, 56729, 56731, 56732, 56733, 56734, 56735, 56736, 56737, 56738, 56740, 56742, 56744, 56748, 56750, 56754, 56755, 56757, 56758, 56759, 56760, 56761, 56762, 58002, 58004, 58005, 58006, 58007, 58009, 58011, 58012, 58014, 58015, 58016, 58021, 58027, 58029, 58031, 58035, 58036, 58038, 58042, 58045, 58046, 58047, 58048, 58049, 58051, 58052, 58056, 58059, 58062, 58063, 58064, 58065, 58068, 58071, 58072, 58077, 58078, 58079, 58102, 58103, 58104, 58105, 58106, 58107, 58108, 58109, 58121, 58122, 58123, 58124, 58125, 58126, 58201, 58202, 58203, 58204, 58205, 58206, 58207, 58208, 58210, 58212, 58213, 58214, 58216, 58218, 58219, 58220, 58222, 58223, 58224, 58225, 58227, 58228, 58229, 58230, 58231, 58233, 58234, 58235, 58236, 58237, 58238, 58239, 58240, 58241, 58243, 58244, 58249, 58250, 58251, 58254, 58255, 58256, 58257, 58258, 58259, 58260, 58261, 58262, 58265, 58266, 58267, 58269, 58270, 58271, 58272, 58273, 58274, 58275, 58276, 58277, 58278, 58281, 58282, 58293, 58300, 58301, 58311, 58317, 58320, 58321, 58323, 58324, 58325, 58327, 58330, 58331, 58335, 58338, 58344, 58345, 58346, 58348, 58351, 58352, 58355, 58356, 58357, 58361, 58362, 58370, 58371, 58372, 58374, 58377, 58379, 58380, 58381, 58382, 58401, 58402, 58405, 58416, 58420, 58421, 58422, 58425, 58426, 58429, 58432, 58443, 58445, 58448, 58452, 58455, 58461, 58464, 58466, 58476, 58479, 58480, 58481, 58484, 58486, 58492, 58496, 58497)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
