| |
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 / 1227058086 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1150 and user_zip in (50454, 50455, 50460, 50466, 50476, 50481, 50603, 50606, 50607, 50628, 50630, 50631, 50645, 50650, 50655, 50659, 50661, 50662, 50664, 50671, 50674, 50676, 50681, 52001, 52002, 52004, 52035, 52036, 52038, 52039, 52040, 52041, 52042, 52043, 52044, 52045, 52047, 52048, 52049, 52050, 52052, 52053, 52055, 52056, 52065, 52066, 52072, 52073, 52076, 52077, 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, 52820, 53503, 53504, 53506, 53507, 53510, 53515, 53516, 53517, 53518, 53526, 53528, 53529, 53530, 53532, 53533, 53535, 53540, 53543, 53544, 53553, 53554, 53555, 53556, 53560, 53561, 53562, 53565, 53569, 53571, 53572, 53573, 53574, 53577, 53578, 53580, 53581, 53582, 53583, 53584, 53586, 53588, 53590, 53591, 53593, 53595, 53596, 53597, 53598, 53698, 53701, 53702, 53703, 53704, 53705, 53706, 53707, 53708, 53709, 53710, 53711, 53713, 53714, 53715, 53717, 53719, 53725, 53726, 53744, 53777, 53778, 53779, 53780, 53782, 53783, 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, 53923, 53924, 53926, 53927, 53928, 53929, 53930, 53934, 53935, 53936, 53937, 53939, 53940, 53941, 53942, 53943, 53944, 53946, 53947, 53948, 53949, 53950, 53951, 53952, 53953, 53954, 53955, 53958, 53959, 53960, 53961, 53962, 53964, 53965, 53968, 53969, 53981, 53995, 54003, 54010, 54011, 54014, 54027, 54028, 54034, 54052, 54242, 54401, 54402, 54404, 54405, 54406, 54407, 54410, 54411, 54412, 54413, 54415, 54419, 54420, 54421, 54422, 54423, 54425, 54426, 54431, 54432, 54433, 54434, 54436, 54437, 54439, 54441, 54443, 54446, 54447, 54448, 54449, 54451, 54454, 54455, 54456, 54457, 54458, 54460, 54466, 54467, 54469, 54472, 54473, 54474, 54475, 54476, 54479, 54480, 54481, 54484, 54488, 54489, 54492, 54493, 54494, 54495, 54498, 54601, 54602, 54603, 54610, 54611, 54612, 54613, 54614, 54615, 54616, 54618, 54619, 54620, 54621, 54622, 54623, 54624, 54625, 54626, 54627, 54628, 54629, 54630, 54631, 54632, 54634, 54635, 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, 54701, 54702, 54703, 54720, 54721, 54722, 54723, 54724, 54725, 54726, 54727, 54729, 54730, 54732, 54735, 54736, 54737, 54738, 54739, 54740, 54741, 54742, 54743, 54745, 54746, 54747, 54748, 54749, 54750, 54751, 54754, 54755, 54756, 54757, 54758, 54759, 54760, 54761, 54764, 54765, 54766, 54767, 54768, 54769, 54770, 54771, 54772, 54773, 54774, 54909, 54921, 54930, 54941, 54943, 54946, 54960, 54965, 54966, 54968, 54970, 54976, 54977, 54981, 54982, 54984, 55026, 55027, 55041, 55066, 55089, 55901, 55902, 55903, 55904, 55905, 55906, 55909, 55910, 55918, 55919, 55920, 55921, 55922, 55923, 55925, 55926, 55927, 55929, 55931, 55932, 55933, 55934, 55935, 55936, 55939, 55940, 55941, 55942, 55943, 55944, 55945, 55947, 55949, 55950, 55951, 55952, 55954, 55955, 55956, 55957, 55959, 55960, 55961, 55962, 55963, 55964, 55965, 55967, 55968, 55969, 55970, 55971, 55972, 55973, 55974, 55975, 55976, 55977, 55978, 55979, 55981, 55982, 55983, 55985, 55987, 55988, 55990, 55991, 55992, 61025)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
