| |
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 / 6 * 10) + user_session_time / 1227079873 * 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 (13020, 13021, 13022, 13024, 13026, 13027, 13029, 13031, 13033, 13034, 13039, 13040, 13041, 13045, 13051, 13052, 13053, 13056, 13057, 13060, 13062, 13063, 13065, 13066, 13068, 13069, 13071, 13073, 13074, 13077, 13078, 13080, 13081, 13084, 13087, 13088, 13089, 13090, 13092, 13101, 13102, 13104, 13108, 13110, 13111, 13112, 13113, 13115, 13116, 13117, 13118, 13119, 13120, 13122, 13124, 13126, 13132, 13135, 13136, 13137, 13138, 13139, 13140, 13141, 13143, 13146, 13147, 13148, 13149, 13152, 13153, 13154, 13156, 13158, 13159, 13160, 13164, 13165, 13166, 13201, 13202, 13203, 13204, 13205, 13206, 13207, 13208, 13209, 13210, 13211, 13212, 13214, 13215, 13217, 13218, 13219, 13220, 13221, 13224, 13225, 13244, 13250, 13251, 13252, 13260, 13261, 13290, 13732, 13734, 13736, 13737, 13738, 13743, 13744, 13745, 13746, 13760, 13766, 13777, 13778, 13784, 13790, 13794, 13797, 13801, 13802, 13803, 13811, 13812, 13827, 13835, 13840, 13841, 13845, 13850, 13862, 13863, 13864, 13901, 13902, 13903, 13904, 13905, 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, 14413, 14414, 14415, 14416, 14417, 14418, 14420, 14422, 14423, 14424, 14425, 14427, 14428, 14429, 14430, 14432, 14433, 14435, 14437, 14441, 14443, 14445, 14449, 14450, 14452, 14453, 14454, 14456, 14458, 14461, 14462, 14463, 14464, 14466, 14467, 14468, 14469, 14470, 14471, 14472, 14475, 14476, 14477, 14478, 14479, 14480, 14481, 14482, 14484, 14485, 14486, 14487, 14488, 14489, 14502, 14504, 14505, 14506, 14507, 14508, 14510, 14511, 14512, 14513, 14514, 14515, 14516, 14517, 14518, 14519, 14520, 14521, 14522, 14525, 14526, 14527, 14529, 14530, 14532, 14533, 14534, 14536, 14537, 14538, 14539, 14541, 14542, 14543, 14544, 14545, 14546, 14547, 14548, 14549, 14550, 14551, 14555, 14556, 14557, 14558, 14559, 14560, 14561, 14563, 14564, 14568, 14569, 14571, 14572, 14580, 14585, 14586, 14588, 14589, 14590, 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, 14726, 14727, 14728, 14729, 14730, 14731, 14732, 14733, 14735, 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, 14776, 14777, 14778, 14779, 14781, 14782, 14783, 14784, 14785, 14786, 14787, 14788, 14801, 14802, 14803, 14804, 14805, 14806, 14807, 14808, 14809, 14810, 14812, 14813, 14814, 14815, 14816, 14817, 14818, 14819, 14820, 14821, 14822, 14823, 14824, 14825, 14826, 14827, 14830, 14831, 14836, 14837, 14838, 14839, 14840, 14841, 14842, 14843, 14844, 14845, 14846, 14847, 14850, 14851, 14852, 14853, 14854, 14855, 14856, 14857, 14858, 14859, 14860, 14861, 14863, 14864, 14865, 14867, 14869, 14870, 14871, 14872, 14873, 14874, 14876, 14877, 14878, 14879, 14880, 14881, 14882, 14883, 14884, 14885, 14886, 14887, 14889, 14891, 14892, 14893, 14894, 14895, 14897, 14898, 14901, 14902, 14903, 14904, 14905, 14925, 15821, 15822, 15823, 15824, 15827, 15831, 15832, 15834, 15841, 15845, 15846, 15849, 15853, 15857, 15861, 15868, 15870, 16239, 16312, 16313, 16329, 16333, 16340, 16345, 16347, 16350, 16351, 16352, 16365, 16366, 16367, 16368, 16369, 16371, 16402, 16405, 16416, 16436, 16701, 16720, 16724, 16725, 16726, 16727, 16728, 16729, 16730, 16731, 16732, 16733, 16734, 16735, 16738, 16740, 16743, 16744, 16745, 16746, 16748, 16749, 16750, 16751, 16804, 16805, 16822, 16826, 16829, 16834, 16836, 16839, 16841, 16845, 16848, 16859, 16864, 16871, 16874, 16901, 16910, 16911, 16912, 16914, 16915, 16917, 16918, 16920, 16921, 16922, 16923, 16925, 16926, 16927, 16928, 16929, 16930, 16932, 16933, 16935, 16936, 16937, 16938, 16939, 16940, 16941, 16942, 16943, 16945, 16946, 16947, 16948, 16950, 17701, 17702, 17703, 17705, 17720, 17721, 17722, 17723, 17724, 17726, 17727, 17728, 17729, 17730, 17731, 17735, 17737, 17738, 17739, 17740, 17741, 17742, 17743, 17744, 17745, 17747, 17748, 17750, 17751, 17752, 17754, 17756, 17757, 17758, 17759, 17760, 17762, 17763, 17764, 17765, 17767, 17768, 17769, 17771, 17773, 17776, 17778, 17779, 17786, 17810, 18614, 18616, 18619, 18623, 18626, 18628, 18632, 18810, 18812, 18814, 18815, 18817, 18818, 18828, 18829, 18830, 18831, 18832, 18833, 18837, 18839, 18840, 18845, 18846, 18848, 18850, 18851, 18853, 18854)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
