| |
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 / 4 * 10) + user_session_time / 1227058388 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (50435, 50454, 50455, 50460, 50461, 50466, 50481, 50602, 50603, 50606, 50607, 50612, 50613, 50614, 50616, 50619, 50620, 50622, 50623, 50624, 50626, 50628, 50629, 50630, 50631, 50634, 50636, 50638, 50641, 50642, 50643, 50644, 50645, 50647, 50648, 50650, 50651, 50652, 50653, 50654, 50655, 50657, 50658, 50659, 50660, 50661, 50662, 50664, 50665, 50666, 50667, 50668, 50669, 50670, 50671, 50673, 50674, 50675, 50676, 50677, 50681, 50682, 50701, 50702, 50703, 50704, 50706, 50707, 50799, 52001, 52002, 52003, 52004, 52030, 52031, 52032, 52033, 52035, 52036, 52037, 52038, 52039, 52040, 52041, 52042, 52043, 52044, 52045, 52046, 52047, 52048, 52049, 52050, 52052, 52053, 52054, 52055, 52056, 52057, 52060, 52064, 52065, 52066, 52068, 52069, 52070, 52071, 52072, 52073, 52074, 52075, 52076, 52077, 52078, 52079, 52099, 52101, 52131, 52132, 52133, 52134, 52135, 52136, 52140, 52141, 52142, 52144, 52146, 52147, 52149, 52151, 52154, 52155, 52156, 52157, 52158, 52159, 52160, 52161, 52162, 52163, 52164, 52165, 52166, 52168, 52169, 52170, 52171, 52172, 52175, 52202, 52203, 52204, 52205, 52206, 52207, 52208, 52209, 52210, 52212, 52213, 52214, 52215, 52216, 52217, 52218, 52219, 52220, 52223, 52224, 52225, 52226, 52227, 52228, 52229, 52233, 52235, 52236, 52237, 52240, 52241, 52242, 52243, 52244, 52245, 52246, 52249, 52252, 52253, 52254, 52255, 52257, 52301, 52302, 52305, 52306, 52307, 52309, 52310, 52312, 52313, 52314, 52315, 52317, 52318, 52319, 52320, 52321, 52322, 52323, 52324, 52326, 52328, 52329, 52330, 52332, 52333, 52334, 52336, 52337, 52338, 52340, 52341, 52344, 52345, 52346, 52348, 52349, 52350, 52351, 52352, 52354, 52358, 52362, 52401, 52402, 52403, 52404, 52405, 52406, 52407, 52408, 52409, 52410, 52411, 52497, 52498, 52499, 52701, 52706, 52720, 52721, 52722, 52726, 52727, 52728, 52729, 52730, 52731, 52732, 52733, 52736, 52742, 52745, 52746, 52747, 52748, 52750, 52751, 52753, 52755, 52756, 52757, 52758, 52759, 52760, 52765, 52766, 52767, 52768, 52769, 52771, 52772, 52773, 52774, 52776, 52777, 52778, 52801, 52802, 52803, 52804, 52805, 52806, 52807, 52808, 52809, 52820, 53501, 53502, 53503, 53504, 53506, 53507, 53508, 53510, 53511, 53512, 53515, 53516, 53517, 53518, 53520, 53521, 53522, 53523, 53526, 53527, 53528, 53529, 53530, 53531, 53532, 53533, 53534, 53535, 53536, 53537, 53540, 53541, 53542, 53543, 53544, 53545, 53546, 53547, 53550, 53553, 53554, 53555, 53556, 53558, 53559, 53560, 53561, 53562, 53565, 53566, 53569, 53570, 53571, 53572, 53573, 53574, 53575, 53576, 53577, 53578, 53580, 53581, 53582, 53583, 53584, 53586, 53587, 53588, 53589, 53590, 53591, 53593, 53595, 53596, 53597, 53598, 53599, 53698, 53701, 53702, 53703, 53704, 53705, 53706, 53707, 53708, 53709, 53710, 53711, 53713, 53714, 53715, 53716, 53717, 53718, 53719, 53725, 53726, 53744, 53777, 53778, 53779, 53780, 53782, 53783, 53784, 53785, 53786, 53787, 53788, 53789, 53790, 53791, 53792, 53793, 53794, 53801, 53802, 53803, 53804, 53805, 53806, 53807, 53808, 53809, 53810, 53811, 53812, 53813, 53816, 53817, 53818, 53820, 53821, 53824, 53825, 53826, 53827, 53886, 53901, 53910, 53911, 53913, 53920, 53924, 53927, 53928, 53929, 53930, 53934, 53936, 53937, 53940, 53941, 53942, 53943, 53944, 53948, 53950, 53951, 53952, 53953, 53954, 53955, 53958, 53959, 53960, 53961, 53962, 53965, 53968, 53969, 53981, 53995, 54034, 54052, 54601, 54602, 54603, 54612, 54613, 54614, 54615, 54616, 54618, 54619, 54620, 54621, 54623, 54624, 54625, 54626, 54627, 54628, 54629, 54630, 54631, 54632, 54634, 54636, 54637, 54638, 54639, 54640, 54641, 54642, 54643, 54644, 54645, 54646, 54648, 54649, 54650, 54651, 54652, 54653, 54654, 54655, 54656, 54657, 54658, 54659, 54660, 54661, 54662, 54664, 54665, 54666, 54667, 54669, 54670, 54699, 55919, 55921, 55922, 55923, 55925, 55929, 55931, 55935, 55939, 55941, 55942, 55943, 55947, 55949, 55951, 55952, 55954, 55959, 55961, 55962, 55965, 55969, 55971, 55972, 55974, 55975, 55977, 55979, 55987, 55988, 55990, 61001, 61007, 61010, 61013, 61014, 61017, 61018, 61019, 61024, 61025, 61027, 61028, 61030, 61032, 61036, 61037, 61039, 61041, 61044, 61046, 61047, 61048, 61050, 61051, 61053, 61054, 61059, 61060, 61062, 61063, 61064, 61067, 61070, 61071, 61072, 61074, 61075, 61076, 61077, 61078, 61079, 61081, 61085, 61087, 61088, 61089, 61091, 61105, 61106, 61110, 61125, 61126, 61130, 61131, 61132, 61201, 61202, 61204, 61206, 61230, 61232, 61236, 61239, 61242, 61244, 61250, 61251, 61252, 61256, 61257, 61261, 61265, 61266, 61270, 61275, 61278, 61282, 61285, 61299)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
