| |
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 / 1227057748 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1050 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, 54419, 54422, 54431, 54433, 54434, 54437, 54439, 54447, 54451, 54460, 54490, 54493, 54498, 54515, 54517, 54526, 54530, 54537, 54555, 54563, 54610, 54611, 54612, 54616, 54622, 54625, 54627, 54629, 54630, 54635, 54659, 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, 54810, 54812, 54813, 54817, 54818, 54819, 54820, 54821, 54822, 54824, 54826, 54828, 54829, 54830, 54832, 54834, 54835, 54836, 54837, 54838, 54839, 54840, 54841, 54842, 54843, 54845, 54847, 54848, 54849, 54851, 54853, 54854, 54856, 54857, 54858, 54859, 54862, 54863, 54864, 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, 55021, 55024, 55025, 55026, 55027, 55029, 55030, 55031, 55032, 55033, 55036, 55037, 55038, 55040, 55041, 55042, 55043, 55044, 55045, 55046, 55047, 55049, 55051, 55052, 55053, 55054, 55055, 55056, 55057, 55060, 55063, 55065, 55066, 55067, 55068, 55069, 55070, 55071, 55072, 55073, 55074, 55075, 55076, 55077, 55078, 55079, 55080, 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, 55272, 55301, 55302, 55303, 55304, 55305, 55306, 55307, 55308, 55309, 55311, 55313, 55315, 55316, 55317, 55318, 55319, 55320, 55321, 55322, 55323, 55325, 55327, 55328, 55330, 55331, 55336, 55337, 55338, 55339, 55340, 55341, 55343, 55344, 55345, 55346, 55347, 55348, 55349, 55352, 55353, 55354, 55356, 55357, 55358, 55359, 55360, 55361, 55362, 55363, 55364, 55365, 55367, 55368, 55369, 55370, 55371, 55372, 55373, 55374, 55375, 55376, 55377, 55378, 55379, 55380, 55381, 55382, 55383, 55384, 55386, 55387, 55388, 55390, 55391, 55392, 55393, 55394, 55395, 55397, 55398, 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, 55530, 55550, 55551, 55552, 55553, 55554, 55555, 55556, 55557, 55558, 55559, 55560, 55561, 55562, 55563, 55564, 55565, 55566, 55567, 55568, 55569, 55570, 55571, 55572, 55573, 55574, 55575, 55576, 55577, 55578, 55579, 55580, 55581, 55582, 55583, 55584, 55585, 55586, 55587, 55588, 55589, 55590, 55591, 55592, 55593, 55594, 55595, 55596, 55597, 55598, 55599, 55608, 55676, 55704, 55707, 55712, 55718, 55720, 55726, 55733, 55735, 55749, 55756, 55757, 55767, 55778, 55780, 55783, 55795, 55797, 55807, 55808, 55810, 55901, 55902, 55903, 55904, 55905, 55906, 55910, 55920, 55924, 55927, 55929, 55932, 55934, 55942, 55944, 55945, 55946, 55952, 55955, 55956, 55957, 55959, 55960, 55963, 55964, 55968, 55969, 55972, 55978, 55979, 55981, 55983, 55985, 55987, 55988, 55991, 55992, 56011, 56017, 56044, 56052, 56057, 56058, 56069, 56071, 56096, 56301, 56303, 56304, 56313, 56320, 56329, 56330, 56333, 56338, 56342, 56350, 56353, 56357, 56358, 56359, 56363, 56364, 56367, 56369, 56373, 56374, 56375, 56377, 56379, 56386, 56387, 56388, 56450)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
