| |
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 / 1227086745 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (7827, 7851, 12036, 12064, 12093, 12116, 12155, 12167, 12197, 12406, 12421, 12430, 12434, 12435, 12438, 12455, 12459, 12465, 12474, 12701, 12710, 12719, 12720, 12722, 12723, 12724, 12725, 12726, 12727, 12732, 12733, 12734, 12736, 12737, 12738, 12740, 12741, 12742, 12743, 12745, 12747, 12748, 12749, 12750, 12751, 12752, 12754, 12756, 12758, 12759, 12760, 12762, 12764, 12765, 12766, 12767, 12768, 12770, 12775, 12776, 12777, 12778, 12779, 12780, 12781, 12783, 12784, 12786, 12787, 12788, 12789, 12791, 12792, 12793, 13020, 13021, 13022, 13024, 13026, 13027, 13028, 13029, 13030, 13031, 13032, 13033, 13034, 13035, 13036, 13037, 13039, 13040, 13041, 13042, 13043, 13044, 13045, 13051, 13052, 13053, 13054, 13056, 13057, 13060, 13061, 13062, 13063, 13064, 13065, 13066, 13068, 13069, 13071, 13072, 13073, 13074, 13076, 13077, 13078, 13080, 13081, 13082, 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, 13122, 13123, 13124, 13126, 13129, 13131, 13132, 13133, 13134, 13135, 13136, 13137, 13138, 13139, 13140, 13141, 13143, 13146, 13147, 13148, 13149, 13152, 13153, 13154, 13155, 13156, 13157, 13158, 13159, 13160, 13162, 13163, 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, 13308, 13310, 13313, 13314, 13315, 13316, 13318, 13319, 13320, 13321, 13322, 13323, 13326, 13328, 13332, 13333, 13334, 13335, 13337, 13340, 13341, 13342, 13346, 13348, 13350, 13355, 13357, 13361, 13362, 13363, 13364, 13396, 13401, 13402, 13403, 13407, 13408, 13409, 13411, 13413, 13415, 13417, 13418, 13421, 13424, 13425, 13439, 13440, 13441, 13442, 13444, 13449, 13450, 13453, 13455, 13456, 13457, 13460, 13461, 13464, 13465, 13468, 13469, 13471, 13475, 13476, 13477, 13478, 13479, 13480, 13482, 13483, 13484, 13485, 13488, 13490, 13491, 13492, 13493, 13495, 13501, 13502, 13503, 13504, 13505, 13550, 13578, 13599, 13730, 13731, 13732, 13733, 13734, 13736, 13737, 13738, 13739, 13740, 13743, 13744, 13745, 13746, 13747, 13748, 13749, 13750, 13751, 13752, 13753, 13754, 13755, 13756, 13757, 13758, 13760, 13761, 13762, 13763, 13766, 13774, 13775, 13776, 13777, 13778, 13780, 13782, 13783, 13784, 13786, 13787, 13788, 13790, 13792, 13794, 13795, 13796, 13797, 13801, 13802, 13803, 13804, 13806, 13807, 13808, 13809, 13810, 13811, 13812, 13813, 13814, 13815, 13820, 13825, 13826, 13827, 13830, 13832, 13833, 13834, 13835, 13837, 13838, 13839, 13840, 13841, 13842, 13843, 13844, 13845, 13846, 13847, 13848, 13849, 13850, 13851, 13856, 13859, 13860, 13861, 13862, 13863, 13864, 13865, 13901, 13902, 13903, 13904, 13905, 13942, 14029, 14064, 14066, 14130, 14413, 14414, 14415, 14417, 14418, 14423, 14424, 14425, 14427, 14432, 14433, 14435, 14437, 14441, 14443, 14445, 14449, 14450, 14453, 14454, 14456, 14458, 14461, 14462, 14463, 14466, 14467, 14469, 14471, 14472, 14475, 14478, 14480, 14481, 14484, 14485, 14486, 14487, 14488, 14489, 14502, 14504, 14505, 14506, 14507, 14510, 14511, 14512, 14513, 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, 14558, 14560, 14561, 14563, 14564, 14568, 14572, 14580, 14585, 14586, 14588, 14589, 14590, 14592, 14603, 14604, 14605, 14607, 14608, 14609, 14610, 14611, 14613, 14614, 14618, 14619, 14620, 14621, 14622, 14623, 14624, 14625, 14627, 14707, 14708, 14709, 14711, 14714, 14715, 14717, 14721, 14727, 14735, 14739, 14744, 14745, 14754, 14770, 14771, 14774, 14776, 14777, 14786, 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, 15861, 16720, 16743, 16746, 16748, 16750, 16820, 16822, 16826, 16841, 16848, 16852, 16854, 16864, 16872, 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, 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, 17813, 17814, 17815, 17820, 17821, 17822, 17823, 17824, 17825, 17827, 17828, 17829, 17830, 17831, 17832, 17833, 17834, 17835, 17836, 17837, 17839, 17840, 17842, 17843, 17844, 17845, 17846, 17847, 17850, 17851, 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, 17888, 17889, 17901, 17920, 17921, 17923, 17925, 17927, 17929, 17930, 17931, 17932, 17934, 17935, 17936, 17938, 17941, 17942, 17943, 17944, 17945, 17946, 17948, 17949, 17951, 17952, 17953, 17954, 17959, 17960, 17961, 17964, 17965, 17966, 17967, 17968, 17970, 17974, 17976, 17978, 17981, 17982, 17983, 17985, 18012, 18021, 18030, 18038, 18058, 18071, 18079, 18080, 18088, 18160, 18201, 18202, 18210, 18211, 18212, 18214, 18216, 18218, 18219, 18220, 18221, 18222, 18223, 18224, 18225, 18229, 18230, 18231, 18232, 18234, 18235, 18237, 18239, 18240, 18241, 18242, 18243, 18244, 18245, 18246, 18247, 18248, 18249, 18250, 18251, 18252, 18254, 18255, 18256, 18301, 18320, 18321, 18322, 18323, 18324, 18325, 18326, 18327, 18328, 18330, 18331, 18332, 18333, 18334, 18335, 18336, 18337, 18340, 18341, 18342, 18344, 18346, 18347, 18348, 18349, 18350, 18352, 18353, 18354, 18355, 18356, 18357, 18360, 18370, 18371, 18372, 18373, 18377, 18401, 18403, 18405, 18407, 18410, 18411, 18413, 18414, 18415, 18416, 18417, 18419, 18420, 18421, 18424, 18425, 18426, 18427, 18428, 18430, 18431, 18433, 18434, 18435, 18436, 18437, 18438, 18439, 18440, 18441, 18443, 18444, 18445, 18446, 18447, 18448, 18449, 18451, 18452, 18453, 18454, 18455, 18456, 18457, 18458, 18459, 18460, 18461, 18462, 18463, 18464, 18465, 18466, 18469, 18470, 18471, 18472, 18473, 18501, 18502, 18503, 18504, 18505, 18507, 18508, 18509, 18510, 18512, 18514, 18515, 18517, 18518, 18519, 18522, 18540, 18577, 18601, 18602, 18603, 18610, 18611, 18612, 18614, 18615, 18616, 18617, 18618, 18619, 18621, 18622, 18623, 18624, 18625, 18626, 18627, 18628, 18629, 18630, 18631, 18632, 18634, 18635, 18636, 18640, 18641, 18642, 18643, 18644, 18651, 18653, 18654, 18655, 18656, 18657, 18660, 18661, 18690, 18701, 18702, 18703, 18704, 18705, 18706, 18707, 18708, 18709, 18710, 18711, 18715, 18761, 18762, 18763, 18764, 18765, 18766, 18767, 18768, 18769, 18773, 18774, 18801, 18810, 18812, 18813, 18814, 18815, 18816, 18817, 18818, 18820, 18821, 18822, 18823, 18824, 18825, 18826, 18827, 18828, 18829, 18830, 18831, 18832, 18833, 18834, 18837, 18839, 18840, 18842, 18843, 18844, 18845, 18846, 18847, 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 |
| |
|
