| |
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 / 1227072738 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (35005, 35006, 35007, 35015, 35020, 35021, 35022, 35023, 35026, 35034, 35035, 35036, 35038, 35039, 35040, 35041, 35042, 35043, 35045, 35046, 35048, 35050, 35051, 35060, 35061, 35062, 35063, 35064, 35068, 35071, 35073, 35074, 35080, 35085, 35091, 35111, 35114, 35115, 35116, 35117, 35118, 35119, 35123, 35124, 35127, 35130, 35137, 35139, 35142, 35143, 35144, 35147, 35148, 35171, 35181, 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, 35461, 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, 35544, 35545, 35546, 35548, 35549, 35550, 35552, 35554, 35555, 35559, 35560, 35563, 35570, 35573, 35574, 35575, 35576, 35577, 35578, 35579, 35580, 35584, 35586, 35587, 35592, 35594, 35703, 35715, 36003, 36006, 36008, 36022, 36030, 36040, 36051, 36054, 36066, 36067, 36068, 36091, 36425, 36431, 36435, 36436, 36444, 36445, 36446, 36449, 36451, 36458, 36460, 36461, 36462, 36470, 36471, 36481, 36482, 36501, 36515, 36518, 36524, 36538, 36539, 36540, 36545, 36548, 36558, 36569, 36570, 36581, 36583, 36585, 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, 36876, 36901, 36904, 36906, 36907, 36908, 36910, 36912, 36913, 36915, 36916, 36919, 36921, 36922, 36925, 38821, 38825, 38844, 38848, 38851, 38854, 38858, 38860, 38870, 38875, 38877, 39051, 39057, 39067, 39074, 39080, 39087, 39090, 39092, 39094, 39098, 39107, 39108, 39109, 39152, 39153, 39171, 39189, 39301, 39302, 39303, 39304, 39305, 39307, 39309, 39320, 39322, 39323, 39324, 39325, 39326, 39327, 39328, 39330, 39332, 39335, 39336, 39337, 39338, 39339, 39341, 39342, 39345, 39346, 39347, 39348, 39350, 39352, 39354, 39355, 39356, 39357, 39358, 39359, 39360, 39361, 39362, 39363, 39364, 39365, 39366, 39367, 39422, 39439, 39440, 39441, 39442, 39443, 39460, 39477, 39481, 39701, 39702, 39703, 39704, 39705, 39710, 39730, 39731, 39735, 39736, 39737, 39739, 39740, 39741, 39743, 39744, 39745, 39746, 39747, 39750, 39751, 39752, 39753, 39754, 39755, 39756, 39758, 39759, 39760, 39762, 39766, 39767, 39769, 39771, 39772, 39773, 39776, 39940)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
