| |
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 / 1227058217 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (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, 54082, 54242, 54337, 54353, 54383, 54405, 54411, 54419, 54420, 54421, 54422, 54425, 54426, 54431, 54433, 54434, 54436, 54437, 54439, 54441, 54446, 54447, 54449, 54451, 54456, 54459, 54460, 54470, 54479, 54480, 54484, 54488, 54490, 54493, 54498, 54513, 54514, 54515, 54517, 54524, 54526, 54527, 54530, 54536, 54537, 54546, 54552, 54555, 54556, 54563, 54564, 54565, 54610, 54611, 54612, 54615, 54616, 54622, 54625, 54627, 54629, 54630, 54635, 54642, 54659, 54661, 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, 54801, 54805, 54806, 54810, 54812, 54813, 54816, 54817, 54818, 54819, 54820, 54821, 54822, 54824, 54826, 54828, 54829, 54830, 54832, 54834, 54835, 54836, 54837, 54838, 54839, 54840, 54841, 54842, 54843, 54844, 54845, 54846, 54847, 54848, 54849, 54851, 54853, 54854, 54855, 54856, 54857, 54858, 54859, 54862, 54863, 54864, 54865, 54867, 54868, 54870, 54871, 54872, 54873, 54874, 54875, 54876, 54880, 54886, 54888, 54889, 54890, 54893, 54895, 54896, 55001, 55002, 55003, 55005, 55006, 55007, 55008, 55009, 55010, 55011, 55012, 55013, 55014, 55016, 55017, 55018, 55019, 55020, 55024, 55025, 55026, 55027, 55029, 55030, 55031, 55032, 55033, 55036, 55037, 55038, 55040, 55041, 55042, 55043, 55044, 55045, 55046, 55047, 55051, 55053, 55054, 55055, 55056, 55057, 55063, 55065, 55066, 55067, 55068, 55069, 55070, 55071, 55072, 55073, 55074, 55075, 55076, 55077, 55078, 55079, 55080, 55082, 55083, 55084, 55085, 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, 55272, 55301, 55303, 55304, 55305, 55306, 55308, 55309, 55311, 55313, 55315, 55316, 55317, 55318, 55323, 55327, 55328, 55330, 55331, 55337, 55340, 55341, 55343, 55344, 55345, 55346, 55347, 55348, 55352, 55356, 55357, 55359, 55361, 55362, 55364, 55365, 55369, 55371, 55372, 55373, 55374, 55375, 55376, 55377, 55378, 55379, 55384, 55386, 55391, 55392, 55393, 55398, 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, 55474, 55478, 55479, 55480, 55483, 55484, 55485, 55486, 55487, 55488, 55530, 55565, 55569, 55570, 55571, 55572, 55573, 55574, 55575, 55576, 55577, 55578, 55579, 55580, 55581, 55582, 55584, 55585, 55586, 55587, 55589, 55590, 55591, 55592, 55593, 55595, 55596, 55597, 55598, 55599, 55608, 55676, 55704, 55707, 55712, 55718, 55720, 55733, 55735, 55749, 55756, 55757, 55767, 55780, 55783, 55795, 55797, 55802, 55805, 55806, 55807, 55808, 55810, 55811, 55812, 55901, 55905, 55906, 55910, 55929, 55932, 55934, 55942, 55945, 55946, 55952, 55956, 55957, 55959, 55960, 55963, 55964, 55968, 55969, 55972, 55978, 55981, 55983, 55985, 55987, 55988, 55991, 55992, 56313, 56330, 56342, 56350, 56353, 56357, 56358, 56359, 56363, 56386)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
