| |
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 / 1227072852 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (30219, 30240, 31808, 31833, 35004, 35005, 35006, 35007, 35010, 35011, 35013, 35014, 35015, 35020, 35021, 35022, 35023, 35026, 35032, 35033, 35034, 35035, 35036, 35038, 35039, 35040, 35041, 35042, 35043, 35044, 35045, 35046, 35048, 35049, 35050, 35051, 35052, 35053, 35054, 35060, 35061, 35062, 35063, 35064, 35068, 35070, 35071, 35072, 35073, 35074, 35077, 35078, 35079, 35080, 35082, 35085, 35089, 35091, 35094, 35096, 35097, 35111, 35112, 35114, 35115, 35116, 35117, 35118, 35119, 35120, 35121, 35123, 35124, 35125, 35126, 35127, 35128, 35130, 35131, 35133, 35135, 35136, 35137, 35139, 35142, 35143, 35144, 35146, 35147, 35148, 35149, 35150, 35151, 35160, 35161, 35171, 35172, 35173, 35176, 35178, 35180, 35181, 35182, 35183, 35184, 35185, 35186, 35187, 35188, 35201, 35202, 35203, 35204, 35205, 35206, 35207, 35208, 35209, 35210, 35211, 35212, 35213, 35214, 35215, 35216, 35217, 35218, 35219, 35220, 35221, 35222, 35223, 35224, 35225, 35226, 35228, 35229, 35230, 35231, 35232, 35233, 35234, 35235, 35236, 35237, 35238, 35240, 35242, 35243, 35244, 35245, 35246, 35249, 35253, 35254, 35255, 35259, 35260, 35261, 35263, 35266, 35277, 35278, 35279, 35280, 35281, 35282, 35283, 35285, 35286, 35287, 35288, 35289, 35290, 35291, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35299, 35308, 35401, 35402, 35403, 35404, 35405, 35406, 35407, 35440, 35441, 35442, 35443, 35444, 35446, 35447, 35448, 35449, 35452, 35453, 35456, 35457, 35458, 35459, 35460, 35462, 35463, 35464, 35466, 35468, 35469, 35470, 35471, 35473, 35474, 35475, 35476, 35477, 35478, 35480, 35481, 35482, 35485, 35486, 35487, 35490, 35491, 35501, 35502, 35503, 35504, 35542, 35545, 35546, 35549, 35550, 35555, 35560, 35573, 35574, 35579, 35580, 35584, 35587, 35703, 35715, 35905, 35906, 35907, 35952, 35953, 35972, 35987, 36003, 36005, 36006, 36008, 36009, 36010, 36013, 36015, 36016, 36017, 36020, 36022, 36023, 36024, 36025, 36026, 36028, 36029, 36030, 36031, 36032, 36033, 36034, 36035, 36036, 36037, 36038, 36039, 36040, 36041, 36042, 36043, 36045, 36046, 36047, 36048, 36049, 36051, 36052, 36053, 36054, 36057, 36061, 36062, 36064, 36065, 36066, 36067, 36068, 36069, 36071, 36075, 36078, 36079, 36080, 36081, 36082, 36083, 36087, 36088, 36089, 36091, 36092, 36093, 36101, 36102, 36103, 36104, 36105, 36106, 36107, 36108, 36109, 36110, 36111, 36112, 36113, 36114, 36115, 36116, 36117, 36118, 36119, 36120, 36121, 36123, 36124, 36125, 36130, 36131, 36132, 36133, 36134, 36135, 36140, 36141, 36142, 36177, 36191, 36201, 36202, 36203, 36204, 36205, 36206, 36207, 36250, 36251, 36253, 36254, 36255, 36256, 36257, 36258, 36260, 36263, 36264, 36265, 36266, 36267, 36268, 36270, 36271, 36273, 36274, 36276, 36277, 36278, 36279, 36280, 36311, 36323, 36346, 36351, 36383, 36401, 36420, 36425, 36429, 36431, 36432, 36435, 36436, 36439, 36444, 36445, 36446, 36449, 36451, 36454, 36456, 36457, 36458, 36460, 36461, 36462, 36467, 36470, 36471, 36473, 36474, 36475, 36476, 36481, 36482, 36524, 36540, 36586, 36701, 36702, 36703, 36720, 36721, 36722, 36723, 36726, 36727, 36728, 36732, 36736, 36738, 36740, 36741, 36742, 36744, 36745, 36748, 36749, 36750, 36751, 36752, 36753, 36754, 36755, 36756, 36758, 36759, 36761, 36762, 36763, 36764, 36765, 36766, 36767, 36768, 36769, 36773, 36775, 36776, 36778, 36779, 36782, 36783, 36784, 36785, 36786, 36790, 36792, 36793, 36801, 36802, 36803, 36804, 36830, 36831, 36832, 36849, 36850, 36851, 36852, 36853, 36854, 36855, 36858, 36860, 36861, 36862, 36863, 36865, 36866, 36867, 36868, 36869, 36870, 36871, 36872, 36874, 36875, 36876, 36877, 36879, 36901, 36904, 36906, 36907, 36910, 36912, 36913, 36916, 36921, 36922, 36925)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
