| |
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 / 1227029021 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (13734, 13743, 13812, 13827, 13840, 13845, 13864, 14003, 14004, 14005, 14006, 14009, 14010, 14011, 14020, 14021, 14024, 14025, 14026, 14027, 14029, 14030, 14031, 14033, 14034, 14035, 14036, 14037, 14038, 14039, 14040, 14041, 14042, 14043, 14047, 14048, 14052, 14054, 14055, 14056, 14057, 14059, 14060, 14061, 14062, 14063, 14065, 14066, 14069, 14070, 14075, 14080, 14081, 14082, 14083, 14085, 14086, 14091, 14101, 14102, 14110, 14111, 14112, 14113, 14127, 14129, 14130, 14133, 14134, 14135, 14136, 14138, 14139, 14140, 14141, 14143, 14145, 14151, 14166, 14167, 14168, 14169, 14170, 14171, 14173, 14201, 14202, 14203, 14204, 14205, 14206, 14208, 14209, 14210, 14211, 14212, 14213, 14214, 14215, 14218, 14219, 14220, 14222, 14224, 14225, 14227, 14231, 14233, 14240, 14241, 14260, 14261, 14263, 14264, 14265, 14267, 14269, 14270, 14272, 14273, 14276, 14280, 14414, 14415, 14417, 14418, 14423, 14424, 14427, 14435, 14437, 14441, 14443, 14454, 14458, 14461, 14462, 14463, 14466, 14469, 14471, 14472, 14475, 14478, 14480, 14481, 14482, 14484, 14485, 14486, 14487, 14488, 14507, 14510, 14511, 14512, 14517, 14521, 14525, 14527, 14529, 14530, 14533, 14536, 14539, 14543, 14544, 14545, 14546, 14547, 14549, 14550, 14556, 14557, 14558, 14560, 14561, 14569, 14572, 14585, 14588, 14591, 14592, 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, 14805, 14806, 14807, 14808, 14809, 14810, 14812, 14813, 14814, 14815, 14816, 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, 14854, 14855, 14856, 14857, 14858, 14859, 14860, 14861, 14863, 14864, 14865, 14867, 14869, 14870, 14871, 14872, 14873, 14874, 14876, 14877, 14878, 14879, 14880, 14883, 14884, 14885, 14886, 14887, 14889, 14891, 14892, 14893, 14894, 14895, 14897, 14898, 14901, 14902, 14903, 14904, 14905, 14925, 15630, 15682, 15686, 15701, 15705, 15710, 15711, 15712, 15713, 15714, 15715, 15716, 15720, 15721, 15722, 15723, 15724, 15727, 15728, 15729, 15730, 15731, 15732, 15733, 15734, 15736, 15737, 15738, 15739, 15740, 15741, 15742, 15744, 15745, 15746, 15747, 15748, 15750, 15751, 15752, 15753, 15754, 15756, 15757, 15758, 15759, 15760, 15761, 15762, 15763, 15764, 15765, 15767, 15770, 15771, 15772, 15773, 15774, 15775, 15776, 15777, 15778, 15780, 15781, 15783, 15784, 15801, 15821, 15822, 15823, 15824, 15825, 15827, 15828, 15829, 15831, 15832, 15834, 15840, 15841, 15845, 15846, 15847, 15848, 15849, 15851, 15853, 15856, 15857, 15860, 15861, 15863, 15864, 15865, 15866, 15868, 15870, 15874, 15901, 15902, 15906, 15907, 15909, 15915, 15920, 15921, 15922, 15925, 15927, 15929, 15930, 15931, 15934, 15938, 15940, 15942, 15943, 15945, 15946, 15948, 15951, 15952, 15954, 15955, 15956, 15957, 15958, 15960, 15961, 15962, 15965, 16022, 16025, 16028, 16030, 16034, 16036, 16040, 16041, 16048, 16049, 16050, 16054, 16058, 16201, 16210, 16211, 16212, 16213, 16214, 16215, 16216, 16217, 16218, 16220, 16221, 16222, 16223, 16224, 16225, 16226, 16228, 16230, 16232, 16233, 16234, 16235, 16236, 16238, 16239, 16240, 16242, 16244, 16245, 16246, 16248, 16249, 16250, 16253, 16254, 16255, 16256, 16257, 16258, 16259, 16260, 16261, 16262, 16263, 16301, 16302, 16312, 16313, 16317, 16319, 16321, 16322, 16323, 16326, 16327, 16329, 16331, 16332, 16333, 16334, 16340, 16341, 16342, 16343, 16344, 16345, 16346, 16347, 16350, 16351, 16352, 16353, 16354, 16360, 16361, 16362, 16364, 16365, 16366, 16367, 16368, 16369, 16370, 16371, 16372, 16373, 16374, 16375, 16402, 16404, 16405, 16407, 16414, 16416, 16420, 16427, 16428, 16434, 16436, 16438, 16442, 16601, 16602, 16603, 16611, 16613, 16614, 16616, 16617, 16619, 16620, 16621, 16622, 16623, 16624, 16625, 16627, 16629, 16630, 16631, 16634, 16635, 16636, 16637, 16638, 16639, 16640, 16641, 16644, 16645, 16646, 16647, 16648, 16651, 16652, 16654, 16655, 16656, 16657, 16660, 16661, 16662, 16663, 16665, 16666, 16668, 16669, 16670, 16671, 16673, 16674, 16675, 16677, 16678, 16680, 16681, 16682, 16683, 16684, 16685, 16686, 16692, 16693, 16694, 16695, 16698, 16699, 16701, 16720, 16724, 16725, 16726, 16727, 16728, 16729, 16730, 16731, 16732, 16733, 16734, 16735, 16738, 16740, 16743, 16744, 16745, 16746, 16748, 16749, 16750, 16751, 16801, 16802, 16803, 16804, 16805, 16815, 16820, 16821, 16822, 16823, 16825, 16826, 16827, 16828, 16829, 16830, 16832, 16833, 16834, 16835, 16836, 16837, 16838, 16839, 16840, 16841, 16843, 16844, 16845, 16847, 16848, 16849, 16850, 16851, 16852, 16853, 16854, 16855, 16856, 16858, 16859, 16860, 16861, 16863, 16864, 16865, 16866, 16868, 16870, 16871, 16872, 16873, 16874, 16875, 16876, 16877, 16878, 16879, 16881, 16882, 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, 17002, 17004, 17005, 17006, 17009, 17014, 17017, 17020, 17021, 17023, 17024, 17029, 17030, 17031, 17032, 17035, 17037, 17040, 17044, 17045, 17047, 17048, 17049, 17051, 17052, 17054, 17056, 17058, 17059, 17060, 17061, 17062, 17063, 17066, 17068, 17069, 17071, 17074, 17075, 17076, 17080, 17082, 17084, 17086, 17090, 17094, 17099, 17213, 17217, 17219, 17220, 17243, 17249, 17253, 17260, 17264, 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, 17749, 17750, 17751, 17752, 17754, 17756, 17757, 17758, 17759, 17760, 17762, 17763, 17764, 17765, 17767, 17768, 17769, 17771, 17772, 17773, 17774, 17776, 17777, 17778, 17779, 17786, 17801, 17810, 17812, 17813, 17814, 17815, 17820, 17821, 17822, 17823, 17824, 17827, 17828, 17829, 17830, 17831, 17833, 17835, 17836, 17837, 17839, 17841, 17842, 17843, 17844, 17845, 17846, 17847, 17850, 17853, 17855, 17856, 17857, 17858, 17859, 17860, 17861, 17862, 17864, 17865, 17866, 17867, 17868, 17870, 17872, 17876, 17877, 17878, 17880, 17881, 17882, 17883, 17884, 17885, 17886, 17887, 17889, 17941, 18611, 18614, 18616, 18619, 18622, 18623, 18626, 18628, 18631, 18632, 18656, 18715, 18810, 18814, 18815, 18817, 18829, 18831, 18832, 18833, 18837, 18840, 18845, 18846, 18848, 18850, 18853, 18854)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
