| |
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 / 22 * 10) + user_session_time / 1227079757 * 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 (1008, 1011, 1026, 1029, 1034, 1050, 1070, 1071, 1084, 1086, 1097, 1098, 1201, 1202, 1203, 1220, 1222, 1223, 1224, 1225, 1226, 1227, 1229, 1230, 1231, 1235, 1236, 1237, 1238, 1240, 1242, 1243, 1244, 1245, 1247, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1262, 1263, 1264, 1266, 1267, 1270, 1343, 1634, 5201, 5257, 5260, 5261, 5352, 6013, 6018, 6019, 6020, 6021, 6022, 6024, 6027, 6031, 6039, 6057, 6058, 6059, 6060, 6061, 6063, 6065, 6068, 6069, 6079, 6090, 6091, 6094, 6098, 6436, 6440, 6468, 6470, 6478, 6482, 6488, 6491, 6601, 6612, 6650, 6673, 6699, 6702, 6704, 6706, 6708, 6710, 6731, 6748, 6750, 6751, 6752, 6753, 6754, 6755, 6756, 6757, 6758, 6759, 6762, 6763, 6770, 6776, 6777, 6778, 6779, 6781, 6782, 6783, 6784, 6785, 6786, 6787, 6790, 6791, 6793, 6794, 6795, 6796, 6798, 6801, 6804, 6807, 6810, 6811, 6812, 6813, 6814, 6816, 6817, 6819, 6820, 6829, 6830, 6831, 6832, 6836, 6840, 6842, 6850, 6851, 6852, 6857, 6859, 6860, 6870, 6875, 6876, 6877, 6878, 6879, 6881, 6883, 6888, 6896, 6897, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6910, 6911, 6912, 6913, 6914, 6920, 6921, 6922, 6925, 6926, 6927, 6928, 6993, 7003, 7004, 7005, 7006, 7007, 7009, 7011, 7012, 7013, 7014, 7015, 7017, 7019, 7021, 7024, 7026, 7028, 7031, 7034, 7035, 7039, 7042, 7043, 7044, 7045, 7046, 7050, 7051, 7052, 7054, 7055, 7057, 7058, 7068, 7070, 7071, 7072, 7073, 7074, 7075, 7082, 7109, 7110, 7175, 7182, 7184, 7188, 7189, 7191, 7192, 7193, 7194, 7195, 7197, 7198, 7199, 7401, 7403, 7405, 7407, 7410, 7416, 7417, 7418, 7419, 7420, 7421, 7422, 7423, 7424, 7427, 7428, 7430, 7432, 7435, 7436, 7438, 7439, 7440, 7442, 7444, 7446, 7450, 7451, 7452, 7456, 7457, 7458, 7460, 7461, 7462, 7463, 7465, 7470, 7474, 7477, 7480, 7481, 7495, 7498, 7501, 7502, 7503, 7504, 7505, 7506, 7507, 7508, 7509, 7510, 7511, 7512, 7513, 7514, 7522, 7524, 7530, 7533, 7538, 7543, 7544, 7571, 7601, 7602, 7603, 7604, 7605, 7606, 7607, 7608, 7610, 7620, 7621, 7624, 7626, 7627, 7628, 7630, 7631, 7632, 7640, 7641, 7642, 7643, 7644, 7645, 7646, 7647, 7648, 7649, 7650, 7652, 7653, 7656, 7657, 7660, 7661, 7662, 7663, 7666, 7670, 7675, 7676, 7677, 7688, 7801, 7802, 7803, 7806, 7819, 7820, 7821, 7822, 7823, 7825, 7826, 7827, 7828, 7829, 7830, 7831, 7832, 7833, 7834, 7836, 7837, 7838, 7839, 7840, 7841, 7842, 7843, 7844, 7845, 7846, 7847, 7848, 7849, 7850, 7851, 7852, 7853, 7855, 7856, 7857, 7860, 7863, 7865, 7866, 7869, 7870, 7871, 7874, 7875, 7876, 7877, 7878, 7879, 7880, 7881, 7882, 7885, 7890, 7919, 7924, 7926, 7927, 7930, 7932, 7934, 7935, 7936, 7940, 7945, 7950, 7952, 7960, 7961, 7962, 7963, 7970, 7976, 7979, 7981, 7983, 7997, 7999, 8808, 8826, 10033, 10034, 10040, 10463, 10466, 10468, 10470, 10471, 10501, 10502, 10503, 10504, 10505, 10506, 10507, 10509, 10510, 10511, 10512, 10514, 10516, 10517, 10518, 10519, 10520, 10521, 10522, 10523, 10524, 10526, 10527, 10528, 10530, 10532, 10533, 10535, 10536, 10537, 10538, 10540, 10541, 10542, 10543, 10545, 10546, 10547, 10548, 10549, 10550, 10551, 10552, 10553, 10557, 10558, 10559, 10560, 10562, 10566, 10567, 10570, 10571, 10572, 10573, 10576, 10577, 10578, 10579, 10580, 10581, 10583, 10586, 10587, 10588, 10589, 10590, 10591, 10592, 10594, 10595, 10596, 10597, 10598, 10601, 10602, 10603, 10604, 10605, 10606, 10607, 10610, 10625, 10629, 10633, 10650, 10701, 10702, 10703, 10704, 10705, 10706, 10707, 10708, 10709, 10710, 10730, 10801, 10802, 10803, 10804, 10901, 10910, 10911, 10912, 10913, 10914, 10915, 10916, 10917, 10918, 10919, 10920, 10921, 10922, 10923, 10924, 10925, 10926, 10927, 10928, 10930, 10931, 10932, 10933, 10940, 10941, 10943, 10946, 10950, 10952, 10953, 10954, 10956, 10957, 10958, 10959, 10960, 10962, 10963, 10964, 10965, 10968, 10969, 10970, 10973, 10974, 10975, 10976, 10977, 10979, 10980, 10981, 10982, 10983, 10984, 10985, 10986, 10987, 10988, 10989, 10990, 10992, 10993, 10994, 10995, 10996, 10997, 10998, 12007, 12008, 12009, 12010, 12015, 12016, 12017, 12018, 12019, 12020, 12022, 12023, 12024, 12025, 12027, 12028, 12029, 12031, 12032, 12033, 12035, 12036, 12037, 12040, 12041, 12042, 12043, 12045, 12046, 12047, 12050, 12051, 12052, 12053, 12054, 12055, 12056, 12057, 12058, 12059, 12060, 12061, 12062, 12063, 12064, 12065, 12066, 12067, 12068, 12069, 12070, 12071, 12072, 12073, 12074, 12075, 12076, 12077, 12078, 12081, 12082, 12083, 12084, 12085, 12086, 12087, 12089, 12090, 12092, 12093, 12094, 12095, 12103, 12106, 12107, 12108, 12110, 12111, 12115, 12116, 12117, 12118, 12120, 12121, 12122, 12123, 12124, 12125, 12128, 12130, 12131, 12132, 12133, 12134, 12136, 12137, 12138, 12139, 12140, 12141, 12143, 12144, 12147, 12148, 12149, 12150, 12151, 12153, 12154, 12155, 12156, 12157, 12158, 12159, 12160, 12161, 12162, 12164, 12165, 12166, 12167, 12168, 12169, 12170, 12172, 12173, 12174, 12175, 12176, 12177, 12179, 12180, 12181, 12182, 12183, 12184, 12185, 12186, 12187, 12188, 12189, 12190, 12192, 12193, 12194, 12195, 12196, 12197, 12198, 12201, 12202, 12203, 12204, 12205, 12206, 12207, 12208, 12209, 12210, 12211, 12212, 12214, 12220, 12222, 12223, 12224, 12225, 12226, 12227, 12228, 12229, 12230, 12231, 12232, 12233, 12234, 12235, 12236, 12237, 12238, 12239, 12240, 12241, 12242, 12243, 12244, 12245, 12246, 12247, 12248, 12249, 12250, 12252, 12255, 12256, 12257, 12260, 12261, 12262, 12288, 12301, 12302, 12303, 12304, 12305, 12306, 12307, 12308, 12309, 12325, 12345, 12401, 12402, 12404, 12405, 12406, 12407, 12409, 12410, 12411, 12412, 12413, 12414, 12416, 12417, 12418, 12419, 12420, 12421, 12422, 12423, 12424, 12427, 12428, 12429, 12430, 12431, 12432, 12433, 12434, 12435, 12436, 12438, 12439, 12440, 12441, 12442, 12443, 12444, 12446, 12447, 12448, 12449, 12450, 12451, 12452, 12453, 12454, 12455, 12456, 12457, 12458, 12459, 12460, 12461, 12463, 12464, 12465, 12466, 12468, 12469, 12470, 12471, 12472, 12473, 12474, 12475, 12477, 12480, 12481, 12482, 12483, 12484, 12485, 12486, 12487, 12489, 12490, 12491, 12492, 12493, 12494, 12495, 12496, 12498, 12501, 12502, 12503, 12504, 12506, 12507, 12508, 12509, 12510, 12511, 12512, 12513, 12514, 12515, 12516, 12517, 12518, 12520, 12521, 12522, 12523, 12524, 12525, 12526, 12527, 12528, 12529, 12530, 12531, 12533, 12534, 12537, 12538, 12540, 12541, 12542, 12543, 12544, 12545, 12546, 12547, 12548, 12549, 12550, 12551, 12552, 12553, 12555, 12557, 12561, 12563, 12564, 12565, 12566, 12567, 12568, 12569, 12570, 12571, 12572, 12574, 12575, 12577, 12578, 12580, 12581, 12582, 12583, 12584, 12585, 12586, 12588, 12589, 12590, 12592, 12593, 12594, 12601, 12602, 12603, 12604, 12701, 12710, 12719, 12720, 12721, 12722, 12723, 12724, 12725, 12726, 12727, 12729, 12732, 12733, 12734, 12736, 12737, 12738, 12739, 12740, 12741, 12742, 12743, 12745, 12746, 12747, 12748, 12749, 12750, 12751, 12752, 12754, 12756, 12758, 12759, 12760, 12762, 12763, 12764, 12765, 12766, 12767, 12768, 12769, 12770, 12771, 12775, 12776, 12777, 12778, 12779, 12780, 12781, 12782, 12783, 12784, 12785, 12786, 12787, 12788, 12789, 12790, 12791, 12792, 12793, 12801, 12803, 12804, 12807, 12816, 12822, 12823, 12825, 12828, 12830, 12831, 12833, 12834, 12835, 12846, 12848, 12850, 12859, 12863, 12866, 12871, 12878, 12884, 12938, 13020, 13028, 13030, 13031, 13032, 13035, 13037, 13039, 13040, 13042, 13043, 13045, 13051, 13052, 13053, 13054, 13056, 13057, 13061, 13062, 13063, 13066, 13068, 13071, 13072, 13073, 13077, 13078, 13082, 13084, 13087, 13088, 13089, 13092, 13101, 13102, 13104, 13108, 13110, 13116, 13118, 13120, 13122, 13123, 13124, 13129, 13133, 13134, 13136, 13138, 13141, 13149, 13152, 13155, 13157, 13158, 13159, 13162, 13163, 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, 13301, 13303, 13304, 13308, 13309, 13310, 13313, 13314, 13315, 13316, 13317, 13318, 13319, 13320, 13321, 13322, 13323, 13324, 13326, 13328, 13329, 13332, 13333, 13334, 13335, 13337, 13338, 13339, 13340, 13341, 13342, 13346, 13348, 13350, 13352, 13353, 13354, 13355, 13357, 13361, 13362, 13363, 13364, 13365, 13396, 13401, 13402, 13403, 13406, 13407, 13408, 13409, 13410, 13411, 13413, 13415, 13416, 13417, 13418, 13421, 13424, 13425, 13428, 13431, 13435, 13438, 13439, 13440, 13441, 13442, 13444, 13449, 13450, 13452, 13454, 13455, 13456, 13457, 13459, 13460, 13461, 13464, 13465, 13468, 13469, 13470, 13471, 13472, 13475, 13476, 13477, 13478, 13479, 13480, 13482, 13484, 13485, 13486, 13488, 13489, 13490, 13491, 13492, 13494, 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, 14817, 14824, 14825, 14838, 14850, 14851, 14852, 14853, 14854, 14859, 14861, 14867, 14881, 14882, 14883, 14886, 14889, 14892, 16910, 16945, 17735, 17743, 18013, 18043, 18058, 18063, 18072, 18083, 18091, 18160, 18210, 18221, 18222, 18223, 18224, 18229, 18255, 18301, 18320, 18321, 18322, 18323, 18324, 18325, 18326, 18327, 18328, 18330, 18331, 18332, 18333, 18334, 18335, 18336, 18337, 18340, 18341, 18342, 18343, 18344, 18346, 18347, 18348, 18349, 18350, 18351, 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, 18602, 18610, 18612, 18614, 18615, 18617, 18618, 18621, 18623, 18624, 18625, 18627, 18628, 18629, 18630, 18632, 18634, 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, 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 |
| |
|
