| |
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 / 15 * 10) + user_session_time / 1227079236 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (13020, 13021, 13022, 13024, 13026, 13027, 13028, 13029, 13030, 13031, 13033, 13034, 13036, 13039, 13041, 13044, 13045, 13053, 13056, 13057, 13060, 13062, 13063, 13064, 13065, 13066, 13068, 13069, 13071, 13073, 13074, 13076, 13077, 13078, 13080, 13081, 13082, 13083, 13084, 13087, 13088, 13089, 13090, 13092, 13093, 13101, 13102, 13103, 13104, 13107, 13108, 13110, 13111, 13112, 13113, 13114, 13115, 13116, 13117, 13118, 13119, 13120, 13121, 13126, 13131, 13132, 13135, 13137, 13138, 13139, 13140, 13141, 13142, 13143, 13144, 13145, 13146, 13147, 13148, 13149, 13152, 13153, 13154, 13156, 13159, 13160, 13164, 13165, 13166, 13167, 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, 13302, 13426, 13493, 13611, 13636, 13650, 13651, 13661, 13674, 13698, 13738, 13864, 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, 14703, 14704, 14706, 14707, 14708, 14709, 14711, 14714, 14715, 14716, 14717, 14718, 14719, 14721, 14723, 14726, 14727, 14729, 14730, 14731, 14732, 14733, 14735, 14737, 14739, 14740, 14741, 14743, 14744, 14745, 14747, 14748, 14751, 14752, 14753, 14754, 14755, 14758, 14760, 14766, 14769, 14770, 14771, 14772, 14774, 14776, 14777, 14778, 14779, 14782, 14783, 14784, 14786, 14788, 14801, 14802, 14803, 14804, 14805, 14806, 14807, 14808, 14809, 14810, 14812, 14813, 14814, 14815, 14816, 14817, 14818, 14819, 14820, 14821, 14822, 14823, 14824, 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, 14893, 14894, 14895, 14897, 14898, 14901, 14902, 14903, 14904, 14905, 14925, 16701, 16725, 16727, 16729, 16730, 16731, 16743, 16744, 16745, 16746, 16748, 16750, 16915, 16918, 16920, 16923, 16927, 16928, 16929, 16935, 16936, 16937, 16940, 16941, 16942, 16943, 16946, 16948, 16950)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
