| |
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 / 3 * 10) + user_session_time / 1227080364 * 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 (1001, 1002, 1003, 1004, 1008, 1011, 1012, 1013, 1014, 1020, 1021, 1022, 1026, 1027, 1029, 1030, 1032, 1033, 1034, 1035, 1038, 1039, 1040, 1041, 1050, 1053, 1054, 1059, 1060, 1061, 1062, 1063, 1066, 1070, 1071, 1072, 1073, 1075, 1077, 1084, 1085, 1086, 1088, 1089, 1090, 1093, 1096, 1097, 1098, 1101, 1102, 1103, 1104, 1105, 1107, 1111, 1114, 1115, 1116, 1133, 1138, 1139, 1144, 1152, 1199, 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, 1301, 1302, 1330, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1346, 1347, 1349, 1350, 1351, 1354, 1355, 1360, 1364, 1367, 1369, 1370, 1373, 1374, 1375, 1376, 1378, 1379, 1380, 1393, 1634, 3431, 3435, 3441, 3443, 3446, 3448, 3451, 3462, 3466, 3467, 3469, 3470, 3601, 3602, 3603, 3604, 3607, 3608, 3609, 3743, 5009, 5030, 5031, 5032, 5034, 5035, 5037, 5048, 5049, 5056, 5062, 5067, 5071, 5073, 5089, 5091, 5101, 5124, 5141, 5142, 5143, 5144, 5146, 5148, 5149, 5150, 5151, 5152, 5153, 5154, 5155, 5156, 5158, 5159, 5161, 5201, 5210, 5233, 5250, 5251, 5252, 5253, 5254, 5255, 5257, 5260, 5261, 5262, 5301, 5302, 5303, 5304, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5350, 5351, 5352, 5353, 5354, 5355, 5356, 5357, 5358, 5359, 5360, 5361, 5362, 5363, 5364, 5433, 5443, 5456, 5472, 5491, 5701, 5702, 5730, 5731, 5732, 5733, 5734, 5735, 5736, 5737, 5738, 5739, 5740, 5741, 5742, 5743, 5744, 5745, 5746, 5747, 5748, 5750, 5751, 5752, 5753, 5757, 5758, 5759, 5760, 5761, 5762, 5763, 5764, 5765, 5766, 5767, 5768, 5769, 5770, 5772, 5773, 5774, 5775, 5776, 5777, 5778, 5958, 6018, 6020, 6021, 6022, 6024, 6027, 6031, 6035, 6039, 6057, 6058, 6059, 6060, 6061, 6063, 6065, 6068, 6069, 6079, 6090, 6091, 6093, 6094, 6098, 6731, 6750, 6753, 6754, 6755, 6756, 6757, 6758, 6759, 6763, 6777, 6785, 6790, 6791, 6794, 6796, 10915, 10919, 10946, 10985, 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, 12521, 12522, 12523, 12524, 12525, 12526, 12527, 12528, 12529, 12530, 12533, 12534, 12537, 12538, 12540, 12541, 12542, 12544, 12545, 12546, 12547, 12548, 12549, 12550, 12557, 12561, 12564, 12565, 12566, 12567, 12568, 12569, 12570, 12571, 12572, 12574, 12578, 12580, 12581, 12582, 12583, 12585, 12586, 12588, 12589, 12590, 12592, 12593, 12594, 12601, 12602, 12603, 12604, 12701, 12710, 12720, 12721, 12722, 12723, 12724, 12725, 12726, 12727, 12733, 12734, 12736, 12738, 12740, 12741, 12742, 12745, 12747, 12748, 12749, 12750, 12751, 12752, 12754, 12756, 12758, 12759, 12760, 12762, 12763, 12765, 12766, 12767, 12768, 12769, 12775, 12776, 12777, 12778, 12779, 12781, 12782, 12783, 12784, 12786, 12787, 12788, 12789, 12790, 12791, 12793, 12801, 12803, 12804, 12805, 12807, 12808, 12809, 12810, 12811, 12812, 12814, 12815, 12816, 12817, 12819, 12820, 12821, 12822, 12823, 12824, 12825, 12827, 12828, 12830, 12831, 12832, 12833, 12834, 12835, 12836, 12837, 12838, 12839, 12841, 12842, 12843, 12844, 12845, 12846, 12847, 12848, 12849, 12850, 12851, 12852, 12853, 12854, 12855, 12856, 12857, 12858, 12859, 12860, 12861, 12862, 12863, 12864, 12865, 12866, 12870, 12871, 12872, 12873, 12874, 12877, 12878, 12879, 12883, 12884, 12885, 12886, 12887, 12922, 12927, 12928, 12932, 12936, 12938, 12942, 12943, 12945, 12946, 12956, 12960, 12961, 12964, 12973, 12974, 12977, 12983, 12986, 12987, 12993, 12997, 12998, 13020, 13028, 13030, 13032, 13035, 13037, 13039, 13040, 13042, 13043, 13044, 13051, 13052, 13054, 13056, 13057, 13061, 13063, 13066, 13072, 13078, 13082, 13084, 13101, 13104, 13116, 13122, 13123, 13124, 13129, 13133, 13134, 13136, 13138, 13155, 13157, 13158, 13159, 13162, 13163, 13167, 13202, 13203, 13205, 13206, 13210, 13211, 13214, 13220, 13224, 13244, 13301, 13302, 13303, 13304, 13305, 13308, 13309, 13310, 13312, 13313, 13314, 13315, 13316, 13317, 13318, 13319, 13320, 13321, 13322, 13323, 13324, 13325, 13326, 13327, 13328, 13329, 13331, 13332, 13333, 13334, 13335, 13337, 13338, 13339, 13340, 13341, 13342, 13343, 13345, 13346, 13348, 13350, 13352, 13353, 13354, 13355, 13357, 13360, 13361, 13362, 13363, 13364, 13365, 13367, 13368, 13388, 13396, 13401, 13402, 13403, 13404, 13406, 13407, 13408, 13409, 13410, 13411, 13413, 13415, 13416, 13417, 13418, 13420, 13421, 13424, 13425, 13428, 13431, 13433, 13435, 13436, 13437, 13438, 13439, 13440, 13441, 13442, 13444, 13449, 13450, 13452, 13453, 13454, 13455, 13456, 13457, 13459, 13460, 13461, 13464, 13465, 13468, 13469, 13470, 13471, 13472, 13473, 13475, 13476, 13477, 13478, 13479, 13480, 13482, 13483, 13484, 13485, 13486, 13488, 13489, 13490, 13491, 13492, 13493, 13494, 13495, 13501, 13502, 13503, 13504, 13505, 13550, 13578, 13599, 13610, 13620, 13627, 13631, 13670, 13690, 13695, 13730, 13731, 13733, 13739, 13740, 13746, 13747, 13749, 13750, 13751, 13752, 13753, 13754, 13755, 13756, 13757, 13758, 13761, 13762, 13763, 13774, 13775, 13776, 13778, 13780, 13782, 13783, 13786, 13787, 13788, 13792, 13796, 13801, 13804, 13806, 13807, 13808, 13809, 13810, 13813, 13814, 13815, 13820, 13825, 13826, 13830, 13832, 13833, 13834, 13837, 13838, 13839, 13841, 13842, 13843, 13844, 13846, 13847, 13848, 13849, 13851, 13856, 13859, 13860, 13861, 13862, 13863, 13865, 13942, 18415, 18417, 18437, 18439, 18455, 18461, 18462, 18469, 18827, 18847)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
