| |
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 / 1 * 10) + user_session_time / 1227080140 * 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 (14001, 14003, 14004, 14005, 14006, 14008, 14009, 14010, 14011, 14012, 14013, 14020, 14021, 14024, 14025, 14026, 14027, 14028, 14029, 14030, 14031, 14032, 14033, 14034, 14035, 14036, 14037, 14038, 14039, 14040, 14041, 14042, 14043, 14047, 14048, 14051, 14052, 14054, 14055, 14056, 14057, 14058, 14059, 14060, 14061, 14062, 14063, 14064, 14065, 14066, 14067, 14068, 14069, 14070, 14072, 14075, 14080, 14081, 14082, 14083, 14085, 14086, 14091, 14092, 14094, 14095, 14098, 14101, 14102, 14103, 14105, 14107, 14108, 14109, 14110, 14111, 14112, 14113, 14120, 14125, 14126, 14127, 14129, 14130, 14131, 14132, 14133, 14134, 14135, 14136, 14138, 14139, 14140, 14141, 14143, 14144, 14145, 14150, 14151, 14166, 14167, 14168, 14169, 14170, 14171, 14172, 14173, 14174, 14201, 14202, 14203, 14204, 14205, 14206, 14207, 14208, 14209, 14210, 14211, 14212, 14213, 14214, 14215, 14216, 14217, 14218, 14219, 14220, 14221, 14222, 14223, 14224, 14225, 14226, 14227, 14228, 14231, 14233, 14240, 14241, 14260, 14261, 14263, 14264, 14265, 14267, 14269, 14270, 14272, 14273, 14276, 14280, 14301, 14302, 14303, 14304, 14305, 14410, 14411, 14414, 14416, 14417, 14418, 14420, 14422, 14423, 14424, 14425, 14427, 14428, 14429, 14430, 14432, 14435, 14437, 14443, 14445, 14450, 14452, 14453, 14454, 14458, 14461, 14462, 14464, 14466, 14467, 14468, 14469, 14470, 14471, 14472, 14475, 14476, 14477, 14478, 14479, 14480, 14481, 14482, 14484, 14485, 14486, 14487, 14488, 14502, 14504, 14506, 14507, 14508, 14510, 14511, 14512, 14514, 14515, 14517, 14519, 14522, 14525, 14526, 14529, 14530, 14533, 14534, 14536, 14537, 14539, 14543, 14544, 14545, 14546, 14547, 14548, 14549, 14550, 14556, 14557, 14558, 14559, 14560, 14561, 14564, 14568, 14569, 14571, 14572, 14580, 14585, 14586, 14591, 14592, 14601, 14602, 14603, 14604, 14605, 14606, 14607, 14608, 14609, 14610, 14611, 14612, 14613, 14614, 14615, 14616, 14617, 14618, 14619, 14620, 14621, 14622, 14623, 14624, 14625, 14626, 14627, 14638, 14639, 14642, 14643, 14644, 14645, 14646, 14647, 14649, 14650, 14651, 14652, 14653, 14660, 14664, 14673, 14683, 14692, 14694, 14701, 14702, 14703, 14704, 14706, 14707, 14708, 14709, 14710, 14711, 14712, 14714, 14715, 14716, 14717, 14718, 14719, 14720, 14721, 14722, 14723, 14724, 14726, 14727, 14728, 14729, 14730, 14731, 14732, 14733, 14735, 14736, 14737, 14738, 14739, 14740, 14741, 14742, 14743, 14744, 14745, 14747, 14748, 14750, 14751, 14752, 14753, 14754, 14755, 14756, 14757, 14758, 14760, 14766, 14767, 14769, 14770, 14771, 14772, 14774, 14775, 14776, 14777, 14778, 14779, 14781, 14782, 14783, 14784, 14785, 14786, 14787, 14788, 14801, 14802, 14803, 14804, 14806, 14807, 14808, 14809, 14810, 14813, 14819, 14820, 14821, 14822, 14823, 14826, 14831, 14836, 14839, 14840, 14843, 14846, 14855, 14856, 14873, 14874, 14877, 14879, 14880, 14884, 14885, 14893, 14895, 14897, 14898, 15821, 15822, 15823, 15824, 15827, 15828, 15831, 15832, 15834, 15841, 15845, 15846, 15853, 15857, 15860, 15868, 15870, 16111, 16217, 16233, 16235, 16239, 16254, 16258, 16260, 16301, 16302, 16311, 16312, 16313, 16314, 16316, 16317, 16319, 16321, 16322, 16323, 16326, 16327, 16328, 16329, 16331, 16332, 16333, 16334, 16335, 16340, 16341, 16343, 16344, 16345, 16346, 16347, 16350, 16351, 16352, 16353, 16354, 16355, 16360, 16361, 16362, 16364, 16365, 16366, 16367, 16368, 16369, 16370, 16371, 16388, 16401, 16402, 16403, 16404, 16405, 16406, 16407, 16410, 16411, 16412, 16413, 16414, 16415, 16416, 16417, 16420, 16421, 16422, 16423, 16424, 16426, 16427, 16428, 16430, 16432, 16433, 16434, 16435, 16436, 16438, 16440, 16441, 16442, 16443, 16444, 16475, 16501, 16502, 16503, 16504, 16505, 16506, 16507, 16508, 16509, 16510, 16511, 16512, 16514, 16515, 16522, 16530, 16531, 16532, 16533, 16534, 16538, 16541, 16544, 16546, 16550, 16553, 16554, 16558, 16563, 16565, 16701, 16720, 16724, 16725, 16726, 16727, 16728, 16729, 16730, 16731, 16732, 16733, 16734, 16735, 16738, 16740, 16743, 16744, 16745, 16746, 16748, 16749, 16750, 16751, 16915, 16918, 16920, 16921, 16922, 16923, 16927, 16928, 16937, 16941, 16942, 16943, 16948, 16950, 44030, 44048, 44068, 44082)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
