| |
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 / 1227073033 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1150 and user_zip in (35005, 35006, 35015, 35020, 35021, 35022, 35023, 35034, 35035, 35038, 35042, 35048, 35060, 35061, 35062, 35064, 35073, 35074, 35080, 35111, 35118, 35123, 35127, 35130, 35139, 35148, 35181, 35184, 35188, 35202, 35219, 35220, 35221, 35224, 35225, 35228, 35230, 35231, 35232, 35236, 35237, 35238, 35245, 35246, 35249, 35253, 35254, 35255, 35259, 35260, 35261, 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, 35541, 35542, 35543, 35544, 35545, 35546, 35548, 35549, 35550, 35551, 35552, 35553, 35554, 35555, 35559, 35560, 35563, 35564, 35565, 35570, 35571, 35573, 35574, 35575, 35576, 35577, 35578, 35579, 35580, 35581, 35582, 35584, 35585, 35586, 35587, 35592, 35593, 35594, 36722, 36727, 36732, 36736, 36738, 36740, 36742, 36744, 36745, 36748, 36754, 36755, 36756, 36759, 36762, 36763, 36764, 36765, 36773, 36776, 36779, 36782, 36783, 36786, 36793, 36876, 36901, 36904, 36906, 36907, 36908, 36910, 36912, 36913, 36915, 36916, 36921, 36922, 36925, 38160, 38601, 38625, 38627, 38650, 38652, 38655, 38658, 38673, 38675, 38677, 38695, 38801, 38802, 38803, 38804, 38820, 38821, 38824, 38825, 38826, 38827, 38828, 38829, 38838, 38839, 38841, 38843, 38844, 38847, 38848, 38849, 38850, 38851, 38854, 38855, 38856, 38857, 38858, 38859, 38860, 38862, 38863, 38864, 38866, 38868, 38869, 38870, 38871, 38873, 38874, 38875, 38876, 38877, 38878, 38879, 38880, 38901, 38902, 38912, 38913, 38914, 38915, 38916, 38917, 38920, 38922, 38923, 38924, 38925, 38926, 38929, 38930, 38935, 38940, 38943, 38945, 38947, 38948, 38949, 38950, 38951, 38953, 38954, 38955, 38960, 38961, 38965, 38967, 39039, 39045, 39046, 39047, 39051, 39057, 39063, 39067, 39074, 39079, 39080, 39087, 39090, 39092, 39094, 39095, 39098, 39107, 39108, 39109, 39117, 39130, 39145, 39146, 39152, 39153, 39158, 39160, 39161, 39163, 39169, 39171, 39176, 39179, 39189, 39192, 39288, 39301, 39302, 39303, 39304, 39305, 39307, 39309, 39320, 39323, 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, 39363, 39364, 39365, 39366, 39422, 39439, 39460, 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)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
