| |
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 / 2 * 10) + user_session_time / 1227073026 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1>1500 and user_zip in (39039, 39040, 39041, 39042, 39043, 39044, 39046, 39047, 39048, 39054, 39056, 39057, 39058, 39059, 39060, 39062, 39066, 39069, 39071, 39072, 39073, 39074, 39077, 39078, 39080, 39081, 39082, 39083, 39086, 39087, 39088, 39092, 39094, 39096, 39098, 39110, 39111, 39112, 39114, 39116, 39117, 39119, 39120, 39121, 39122, 39130, 39140, 39144, 39145, 39148, 39149, 39150, 39151, 39152, 39153, 39154, 39156, 39157, 39158, 39159, 39161, 39162, 39163, 39165, 39167, 39168, 39170, 39173, 39174, 39175, 39177, 39179, 39180, 39181, 39182, 39183, 39190, 39191, 39193, 39194, 39201, 39202, 39203, 39204, 39205, 39206, 39207, 39208, 39209, 39210, 39211, 39212, 39213, 39215, 39216, 39217, 39218, 39219, 39225, 39232, 39235, 39236, 39250, 39269, 39271, 39272, 39282, 39283, 39284, 39286, 39288, 39289, 39296, 39298, 39336, 39338, 39345, 39347, 39348, 39356, 39366, 39401, 39402, 39403, 39404, 39406, 39407, 39421, 39422, 39423, 39425, 39426, 39427, 39428, 39429, 39436, 39437, 39439, 39440, 39441, 39442, 39443, 39455, 39457, 39459, 39460, 39462, 39463, 39464, 39465, 39466, 39470, 39474, 39475, 39476, 39477, 39478, 39479, 39480, 39481, 39482, 39483, 39520, 39521, 39522, 39525, 39529, 39556, 39561, 39572, 39573, 39574, 39577, 39579, 39601, 39602, 39603, 39629, 39630, 39631, 39632, 39633, 39635, 39638, 39641, 39643, 39645, 39647, 39648, 39649, 39652, 39653, 39654, 39656, 39657, 39660, 39661, 39662, 39663, 39664, 39665, 39666, 39667, 39668, 39669, 39871, 39940, 39956, 70000, 70006, 70048, 70049, 70051, 70052, 70065, 70066, 70068, 70069, 70071, 70076, 70079, 70084, 70346, 70376, 70401, 70402, 70403, 70404, 70420, 70421, 70422, 70426, 70427, 70428, 70429, 70431, 70432, 70433, 70434, 70435, 70436, 70437, 70438, 70440, 70441, 70442, 70443, 70444, 70445, 70446, 70447, 70448, 70449, 70450, 70451, 70452, 70453, 70454, 70455, 70456, 70457, 70458, 70459, 70460, 70461, 70462, 70463, 70464, 70465, 70466, 70467, 70469, 70470, 70471, 70494, 70499, 70704, 70706, 70707, 70710, 70711, 70712, 70714, 70715, 70716, 70717, 70718, 70719, 70720, 70721, 70722, 70723, 70725, 70726, 70727, 70728, 70729, 70730, 70732, 70733, 70734, 70736, 70737, 70738, 70739, 70740, 70744, 70747, 70748, 70749, 70750, 70751, 70752, 70753, 70754, 70755, 70756, 70757, 70759, 70760, 70761, 70762, 70763, 70764, 70765, 70767, 70769, 70770, 70772, 70773, 70774, 70775, 70776, 70777, 70778, 70780, 70781, 70782, 70783, 70784, 70785, 70786, 70787, 70788, 70789, 70791, 70792, 70801, 70802, 70803, 70804, 70805, 70806, 70807, 70808, 70809, 70810, 70811, 70812, 70813, 70814, 70815, 70816, 70817, 70818, 70819, 70820, 70821, 70822, 70823, 70825, 70826, 70827, 70831, 70833, 70835, 70836, 70837, 70848, 70874, 70879, 70883, 70884, 70892, 70893, 70894, 70895, 70896, 70898, 71218, 71219, 71230, 71232, 71233, 71243, 71249, 71259, 71276, 71282, 71284, 71286, 71295, 71316, 71320, 71324, 71326, 71327, 71329, 71331, 71334, 71336, 71339, 71340, 71342, 71343, 71350, 71351, 71353, 71354, 71355, 71357, 71358, 71362, 71363, 71366, 71368, 71369, 71373, 71375, 71377, 71378, 71401, 71425)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
