| |
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 / 1227072744 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1070 and user_zip in (35004, 35005, 35006, 35007, 35013, 35015, 35016, 35019, 35020, 35021, 35022, 35023, 35031, 35033, 35034, 35035, 35036, 35038, 35039, 35040, 35041, 35042, 35043, 35048, 35049, 35050, 35051, 35052, 35053, 35054, 35055, 35056, 35057, 35058, 35060, 35061, 35062, 35063, 35064, 35068, 35070, 35071, 35073, 35074, 35077, 35078, 35079, 35080, 35083, 35087, 35091, 35094, 35097, 35098, 35111, 35112, 35114, 35115, 35116, 35117, 35118, 35119, 35120, 35121, 35123, 35124, 35125, 35126, 35127, 35128, 35130, 35131, 35133, 35135, 35137, 35139, 35142, 35144, 35146, 35147, 35148, 35172, 35173, 35175, 35176, 35178, 35179, 35180, 35181, 35182, 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, 35444, 35446, 35447, 35448, 35449, 35452, 35453, 35456, 35457, 35458, 35461, 35462, 35463, 35466, 35468, 35469, 35471, 35473, 35474, 35475, 35476, 35477, 35478, 35480, 35481, 35482, 35485, 35486, 35487, 35490, 35491, 35501, 35502, 35503, 35504, 35540, 35541, 35542, 35543, 35544, 35545, 35546, 35548, 35549, 35550, 35551, 35552, 35553, 35554, 35555, 35559, 35560, 35563, 35564, 35565, 35570, 35571, 35572, 35573, 35574, 35575, 35576, 35577, 35578, 35579, 35580, 35581, 35582, 35584, 35585, 35586, 35587, 35592, 35593, 35594, 35601, 35602, 35603, 35609, 35610, 35611, 35612, 35613, 35614, 35615, 35616, 35617, 35618, 35619, 35620, 35621, 35622, 35630, 35631, 35632, 35633, 35634, 35640, 35643, 35645, 35646, 35647, 35648, 35649, 35650, 35651, 35652, 35653, 35654, 35659, 35660, 35661, 35662, 35670, 35671, 35672, 35673, 35674, 35677, 35699, 35703, 35715, 35739, 35741, 35742, 35745, 35747, 35748, 35749, 35750, 35751, 35754, 35755, 35756, 35757, 35758, 35759, 35760, 35761, 35762, 35763, 35764, 35766, 35767, 35768, 35769, 35773, 35774, 35775, 35776, 35801, 35802, 35803, 35804, 35805, 35806, 35807, 35808, 35809, 35810, 35811, 35812, 35813, 35814, 35815, 35816, 35824, 35893, 35894, 35895, 35896, 35897, 35898, 35899, 35904, 35906, 35907, 35950, 35951, 35952, 35953, 35954, 35956, 35957, 35962, 35964, 35972, 35974, 35975, 35976, 35980, 35987, 35990, 37019, 37047, 37091, 37096, 37144, 37147, 37328, 37334, 37335, 37345, 37348, 38044, 38052, 38061, 38067, 38074, 38160, 38310, 38311, 38315, 38326, 38327, 38329, 38332, 38334, 38339, 38340, 38347, 38350, 38352, 38357, 38359, 38361, 38365, 38367, 38368, 38370, 38371, 38372, 38374, 38375, 38376, 38377, 38379, 38393, 38425, 38449, 38450, 38451, 38452, 38453, 38455, 38456, 38457, 38459, 38460, 38461, 38462, 38463, 38464, 38468, 38469, 38471, 38472, 38473, 38474, 38475, 38477, 38478, 38481, 38483, 38485, 38486, 38488, 38603, 38610, 38625, 38627, 38629, 38633, 38650, 38652, 38659, 38663, 38674, 38683, 38801, 38802, 38803, 38804, 38820, 38821, 38824, 38825, 38826, 38827, 38828, 38829, 38833, 38834, 38835, 38838, 38839, 38841, 38843, 38844, 38846, 38847, 38848, 38849, 38850, 38851, 38852, 38854, 38855, 38856, 38857, 38858, 38859, 38860, 38862, 38863, 38864, 38865, 38866, 38868, 38869, 38870, 38871, 38873, 38874, 38875, 38876, 38877, 38878, 38879, 38880, 38913, 38915, 38916, 38949, 38951, 39341, 39361, 39701, 39702, 39703, 39704, 39705, 39710, 39730, 39731, 39736, 39739, 39740, 39741, 39743, 39746, 39750, 39751, 39752, 39753, 39754, 39755, 39756, 39758, 39759, 39760, 39762, 39766, 39769, 39771, 39773, 39776)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
