| |
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 / 1227058366 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (52001, 52002, 52003, 52004, 52031, 52032, 52035, 52039, 52040, 52042, 52043, 52044, 52045, 52046, 52047, 52048, 52049, 52052, 52053, 52054, 52055, 52056, 52065, 52066, 52068, 52071, 52072, 52073, 52075, 52079, 52099, 52133, 52140, 52146, 52149, 52151, 52156, 52157, 52158, 52159, 52160, 52162, 52170, 52172, 52820, 53001, 53002, 53003, 53004, 53005, 53006, 53007, 53008, 53009, 53010, 53011, 53012, 53013, 53014, 53016, 53017, 53018, 53019, 53020, 53021, 53022, 53023, 53024, 53027, 53029, 53031, 53032, 53033, 53034, 53035, 53036, 53037, 53038, 53039, 53040, 53042, 53045, 53046, 53047, 53048, 53049, 53050, 53051, 53052, 53056, 53057, 53058, 53059, 53060, 53061, 53062, 53064, 53065, 53066, 53069, 53070, 53072, 53073, 53074, 53075, 53076, 53078, 53079, 53080, 53085, 53086, 53088, 53089, 53090, 53091, 53092, 53093, 53094, 53095, 53097, 53098, 53099, 53103, 53105, 53114, 53115, 53118, 53119, 53120, 53121, 53122, 53125, 53127, 53128, 53129, 53130, 53132, 53134, 53137, 53138, 53139, 53146, 53147, 53148, 53149, 53150, 53151, 53152, 53153, 53156, 53157, 53159, 53167, 53176, 53178, 53183, 53184, 53185, 53186, 53187, 53188, 53189, 53190, 53191, 53195, 53197, 53201, 53202, 53203, 53204, 53205, 53206, 53207, 53208, 53209, 53210, 53211, 53212, 53213, 53214, 53215, 53216, 53217, 53218, 53219, 53220, 53221, 53222, 53223, 53224, 53225, 53226, 53227, 53228, 53233, 53245, 53259, 53263, 53267, 53268, 53270, 53277, 53278, 53280, 53281, 53288, 53290, 53293, 53449, 53501, 53502, 53503, 53504, 53505, 53506, 53507, 53508, 53510, 53511, 53512, 53515, 53516, 53517, 53518, 53520, 53521, 53522, 53523, 53525, 53526, 53527, 53528, 53529, 53530, 53531, 53532, 53533, 53534, 53535, 53536, 53537, 53538, 53540, 53541, 53542, 53543, 53544, 53545, 53546, 53547, 53549, 53550, 53551, 53553, 53554, 53555, 53556, 53557, 53558, 53559, 53560, 53561, 53562, 53563, 53565, 53566, 53569, 53570, 53571, 53572, 53573, 53574, 53575, 53576, 53577, 53578, 53579, 53580, 53581, 53582, 53583, 53584, 53585, 53586, 53587, 53588, 53589, 53590, 53591, 53593, 53594, 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, 53916, 53917, 53919, 53920, 53922, 53923, 53924, 53925, 53926, 53927, 53928, 53929, 53930, 53931, 53932, 53933, 53934, 53935, 53936, 53937, 53939, 53940, 53941, 53942, 53943, 53944, 53946, 53947, 53948, 53949, 53950, 53951, 53952, 53953, 53954, 53955, 53956, 53957, 53958, 53959, 53960, 53961, 53962, 53963, 53964, 53965, 53968, 53969, 53981, 53995, 54034, 54035, 54052, 54061, 54106, 54110, 54113, 54123, 54129, 54130, 54131, 54136, 54140, 54152, 54160, 54169, 54170, 54180, 54207, 54232, 54402, 54404, 54406, 54407, 54410, 54412, 54413, 54415, 54420, 54423, 54426, 54427, 54429, 54432, 54436, 54437, 54440, 54441, 54443, 54446, 54449, 54454, 54455, 54456, 54457, 54458, 54466, 54467, 54469, 54472, 54473, 54474, 54475, 54476, 54479, 54481, 54484, 54486, 54488, 54489, 54492, 54494, 54495, 54499, 54601, 54602, 54603, 54611, 54613, 54614, 54615, 54616, 54618, 54619, 54620, 54621, 54623, 54624, 54625, 54626, 54627, 54628, 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, 54741, 54746, 54754, 54760, 54773, 54901, 54902, 54903, 54904, 54906, 54909, 54911, 54912, 54913, 54914, 54915, 54919, 54921, 54922, 54923, 54926, 54927, 54928, 54929, 54930, 54931, 54932, 54933, 54934, 54935, 54936, 54937, 54940, 54941, 54942, 54943, 54944, 54945, 54946, 54947, 54948, 54949, 54950, 54951, 54952, 54956, 54957, 54960, 54961, 54962, 54963, 54964, 54965, 54966, 54967, 54968, 54969, 54970, 54971, 54974, 54975, 54976, 54977, 54979, 54980, 54981, 54982, 54983, 54984, 54985, 54986, 54990, 55919, 55921, 55925, 55931, 55941, 55943, 55947, 55974, 60033, 60034, 61001, 61007, 61008, 61010, 61011, 61012, 61013, 61016, 61018, 61019, 61024, 61025, 61027, 61028, 61030, 61032, 61036, 61038, 61039, 61041, 61044, 61046, 61047, 61048, 61050, 61053, 61059, 61060, 61062, 61063, 61065, 61067, 61070, 61072, 61073, 61074, 61075, 61076, 61077, 61078, 61079, 61080, 61084, 61085, 61087, 61088, 61089, 61101, 61102, 61103, 61104, 61105, 61106, 61107, 61108, 61109, 61110, 61111, 61112, 61114, 61115, 61125, 61126, 61130, 61131, 61132)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
