| |
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 / 1227058037 * 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 (50426, 50435, 50440, 50448, 50454, 50455, 50456, 50459, 50460, 50461, 50464, 50466, 50471, 50472, 50476, 50481, 50603, 50616, 50620, 50628, 50630, 50645, 50659, 50661, 52101, 52131, 52132, 52133, 52134, 52135, 52136, 52140, 52141, 52144, 52146, 52147, 52149, 52151, 52154, 52155, 52156, 52157, 52158, 52159, 52160, 52161, 52162, 52163, 52165, 52166, 52168, 52170, 52171, 52172, 52175, 53518, 53581, 53698, 53821, 53826, 53924, 53927, 53929, 53948, 53950, 53962, 53968, 54001, 54002, 54003, 54004, 54005, 54006, 54007, 54009, 54010, 54011, 54012, 54013, 54014, 54015, 54016, 54017, 54020, 54021, 54022, 54023, 54024, 54025, 54026, 54027, 54028, 54034, 54052, 54082, 54242, 54337, 54353, 54404, 54405, 54410, 54412, 54413, 54415, 54419, 54420, 54421, 54422, 54425, 54426, 54431, 54433, 54434, 54436, 54437, 54439, 54441, 54446, 54447, 54449, 54451, 54454, 54456, 54457, 54460, 54466, 54469, 54472, 54479, 54480, 54484, 54488, 54489, 54490, 54493, 54495, 54498, 54526, 54530, 54563, 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, 54728, 54729, 54730, 54731, 54732, 54733, 54734, 54735, 54736, 54737, 54738, 54739, 54740, 54741, 54742, 54743, 54744, 54745, 54746, 54747, 54748, 54749, 54750, 54751, 54754, 54755, 54756, 54757, 54758, 54759, 54760, 54761, 54762, 54763, 54764, 54765, 54766, 54767, 54768, 54769, 54770, 54771, 54772, 54773, 54774, 54805, 54810, 54812, 54813, 54817, 54818, 54819, 54822, 54824, 54826, 54829, 54834, 54835, 54837, 54841, 54848, 54851, 54853, 54857, 54858, 54863, 54868, 54870, 54871, 54889, 54895, 55001, 55002, 55003, 55005, 55009, 55010, 55011, 55012, 55013, 55014, 55016, 55018, 55019, 55020, 55021, 55024, 55025, 55026, 55027, 55031, 55033, 55038, 55041, 55042, 55043, 55044, 55045, 55046, 55047, 55049, 55052, 55053, 55054, 55055, 55056, 55057, 55060, 55065, 55066, 55068, 55071, 55073, 55074, 55075, 55076, 55077, 55078, 55079, 55082, 55083, 55084, 55085, 55087, 55088, 55089, 55090, 55092, 55101, 55102, 55103, 55104, 55105, 55106, 55107, 55108, 55109, 55110, 55111, 55112, 55113, 55114, 55115, 55116, 55117, 55118, 55119, 55120, 55121, 55122, 55123, 55124, 55125, 55126, 55127, 55128, 55129, 55133, 55144, 55145, 55146, 55150, 55155, 55161, 55164, 55165, 55166, 55168, 55169, 55170, 55171, 55172, 55175, 55177, 55182, 55187, 55188, 55189, 55190, 55191, 55303, 55304, 55305, 55306, 55311, 55315, 55316, 55317, 55318, 55322, 55323, 55327, 55331, 55337, 55340, 55343, 55344, 55345, 55346, 55347, 55348, 55352, 55356, 55361, 55364, 55369, 55372, 55378, 55379, 55383, 55384, 55386, 55391, 55392, 55394, 55399, 55401, 55402, 55403, 55404, 55405, 55406, 55407, 55408, 55409, 55410, 55411, 55412, 55413, 55414, 55415, 55416, 55417, 55418, 55419, 55420, 55421, 55422, 55423, 55424, 55425, 55426, 55427, 55428, 55429, 55430, 55431, 55432, 55433, 55434, 55435, 55436, 55437, 55438, 55439, 55440, 55441, 55442, 55443, 55444, 55445, 55446, 55447, 55448, 55449, 55450, 55454, 55455, 55458, 55459, 55460, 55468, 55470, 55472, 55473, 55474, 55478, 55479, 55480, 55483, 55484, 55485, 55486, 55487, 55488, 55550, 55551, 55552, 55553, 55554, 55555, 55556, 55557, 55558, 55559, 55560, 55561, 55562, 55563, 55564, 55566, 55567, 55568, 55569, 55570, 55571, 55572, 55573, 55574, 55575, 55576, 55577, 55578, 55579, 55583, 55593, 55594, 55595, 55596, 55597, 55598, 55599, 55608, 55901, 55902, 55903, 55904, 55905, 55906, 55909, 55910, 55912, 55917, 55918, 55919, 55920, 55921, 55922, 55923, 55924, 55925, 55926, 55927, 55929, 55931, 55932, 55933, 55934, 55935, 55936, 55939, 55940, 55941, 55942, 55943, 55944, 55945, 55946, 55947, 55949, 55950, 55951, 55952, 55953, 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, 56007, 56009, 56011, 56016, 56017, 56020, 56026, 56028, 56032, 56035, 56036, 56042, 56043, 56045, 56046, 56048, 56052, 56057, 56063, 56064, 56069, 56071, 56072, 56076, 56078, 56089, 56091, 56093, 56096)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
