| |
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 / 2 * 10) + user_session_time / 1227058696 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1020 and user_zip in (210, 211, 212, 213, 214, 215, 1001, 1002, 1003, 1004, 1005, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1020, 1021, 1022, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1050, 1053, 1054, 1056, 1057, 1059, 1060, 1061, 1062, 1063, 1066, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1077, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1088, 1089, 1090, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1111, 1114, 1115, 1116, 1118, 1119, 1128, 1129, 1133, 1138, 1139, 1144, 1151, 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, 1331, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1346, 1347, 1349, 1350, 1351, 1354, 1355, 1360, 1364, 1366, 1367, 1368, 1369, 1370, 1373, 1374, 1375, 1376, 1378, 1379, 1380, 1393, 1420, 1427, 1430, 1431, 1432, 1436, 1438, 1440, 1441, 1450, 1451, 1452, 1453, 1460, 1462, 1463, 1464, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1477, 1501, 1503, 1504, 1505, 1506, 1507, 1508, 1509, 1510, 1515, 1516, 1517, 1518, 1519, 1520, 1521, 1522, 1523, 1524, 1525, 1526, 1527, 1529, 1531, 1532, 1534, 1535, 1536, 1537, 1538, 1540, 1541, 1542, 1543, 1545, 1546, 1550, 1560, 1561, 1562, 1564, 1566, 1568, 1569, 1570, 1571, 1580, 1581, 1582, 1583, 1585, 1586, 1588, 1590, 1601, 1602, 1603, 1604, 1605, 1606, 1607, 1608, 1609, 1610, 1611, 1612, 1613, 1614, 1615, 1634, 1653, 1654, 1655, 1701, 1702, 1703, 1704, 1705, 1718, 1719, 1720, 1721, 1730, 1731, 1740, 1741, 1742, 1745, 1746, 1747, 1748, 1749, 1750, 1752, 1754, 1756, 1757, 1760, 1770, 1772, 1773, 1775, 1776, 1778, 1784, 1801, 1803, 1805, 1806, 1807, 1808, 1810, 1812, 1813, 1815, 1820, 1821, 1822, 1823, 1824, 1826, 1827, 1830, 1831, 1832, 1833, 1834, 1835, 1840, 1841, 1842, 1843, 1844, 1845, 1850, 1851, 1852, 1853, 1854, 1856, 1860, 1862, 1863, 1864, 1865, 1866, 1867, 1876, 1879, 1880, 1885, 1886, 1887, 1888, 1889, 1890, 1899, 1901, 1902, 1903, 1904, 1905, 1906, 1910, 1913, 1921, 1922, 1923, 1931, 1936, 1937, 1940, 1947, 1949, 1950, 1951, 1952, 1960, 1961, 1969, 1971, 1983, 1985, 2019, 2026, 2030, 2032, 2035, 2038, 2052, 2053, 2054, 2056, 2062, 2071, 2081, 2085, 2090, 2093, 2101, 2106, 2108, 2109, 2110, 2111, 2113, 2114, 2115, 2116, 2118, 2119, 2120, 2121, 2122, 2124, 2125, 2126, 2127, 2128, 2129, 2130, 2131, 2132, 2134, 2135, 2136, 2138, 2139, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2148, 2149, 2150, 2151, 2153, 2154, 2155, 2156, 2157, 2158, 2159, 2160, 2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2179, 2180, 2181, 2186, 2193, 2194, 2195, 2199, 2202, 2203, 2205, 2210, 2212, 2215, 2222, 2238, 2239, 2254, 2258, 2272, 2277, 2420, 2421, 2445, 2446, 2451, 2452, 2453, 2454, 2456, 2458, 2459, 2460, 2461, 2462, 2464, 2465, 2466, 2467, 2468, 2471, 2472, 2474, 2475, 2476, 2477, 2478, 2479, 2481, 2482, 2492, 2493, 2494, 2495, 2762, 2802, 2805, 2814, 2815, 2824, 2825, 2826, 2828, 2829, 2830, 2838, 2839, 2857, 2858, 2859, 2864, 2876, 2895, 2896, 2917, 2940, 3004, 3030, 3031, 3032, 3033, 3034, 3036, 3037, 3038, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3051, 3052, 3053, 3054, 3055, 3057, 3058, 3060, 3061, 3062, 3063, 3064, 3070, 3071, 3073, 3076, 3077, 3079, 3082, 3084, 3086, 3087, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111, 3215, 3216, 3217, 3218, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3237, 3238, 3240, 3241, 3242, 3243, 3244, 3245, 3246, 3247, 3249, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3266, 3268, 3269, 3270, 3272, 3273, 3274, 3275, 3276, 3278, 3279, 3280, 3281, 3282, 3284, 3287, 3289, 3290, 3291, 3293, 3298, 3299, 3301, 3302, 3303, 3304, 3305, 3307, 3342, 3386, 3431, 3435, 3438, 3440, 3441, 3442, 3443, 3444, 3445, 3446, 3447, 3448, 3449, 3450, 3451, 3452, 3455, 3456, 3457, 3458, 3461, 3462, 3464, 3465, 3466, 3467, 3468, 3469, 3470, 3477, 3572, 3578, 3585, 3601, 3602, 3603, 3604, 3605, 3607, 3608, 3609, 3648, 3678, 3688, 3733, 3740, 3741, 3743, 3745, 3746, 3747, 3748, 3749, 3750, 3751, 3752, 3753, 3754, 3755, 3756, 3757, 3765, 3766, 3768, 3769, 3770, 3771, 3773, 3774, 3777, 3779, 3780, 3781, 3782, 3784, 3785, 3802, 3803, 3804, 3805, 3809, 3810, 3811, 3815, 3816, 3819, 3820, 3821, 3822, 3824, 3825, 3826, 3827, 3833, 3835, 3837, 3839, 3840, 3841, 3842, 3843, 3844, 3848, 3850, 3851, 3852, 3853, 3855, 3856, 3857, 3858, 3859, 3862, 3864, 3865, 3866, 3867, 3868, 3872, 3873, 3874, 3878, 3883, 3884, 3885, 3886, 3887, 3891, 3894, 3896, 3897, 5001, 5009, 5030, 5031, 5032, 5033, 5034, 5035, 5036, 5037, 5038, 5039, 5040, 5041, 5042, 5043, 5045, 5046, 5047, 5048, 5049, 5051, 5052, 5053, 5054, 5055, 5056, 5058, 5059, 5060, 5061, 5062, 5065, 5067, 5068, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5077, 5079, 5080, 5081, 5083, 5084, 5085, 5086, 5088, 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, 5445, 5456, 5461, 5462, 5466, 5469, 5472, 5473, 5477, 5487, 5491, 5501, 5544, 5601, 5602, 5603, 5604, 5609, 5620, 5626, 5633, 5640, 5641, 5648, 5649, 5651, 5654, 5658, 5660, 5663, 5664, 5666, 5667, 5669, 5670, 5671, 5673, 5674, 5675, 5676, 5677, 5678, 5679, 5682, 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, 5801, 5958, 6001, 6002, 6006, 6010, 6011, 6013, 6016, 6018, 6019, 6020, 6021, 6022, 6023, 6024, 6025, 6026, 6027, 6028, 6029, 6030, 6031, 6032, 6033, 6034, 6035, 6037, 6039, 6040, 6041, 6043, 6045, 6049, 6050, 6051, 6052, 6053, 6057, 6058, 6059, 6060, 6061, 6062, 6063, 6064, 6065, 6066, 6067, 6068, 6069, 6070, 6071, 6072, 6073, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6087, 6088, 6089, 6090, 6091, 6092, 6093, 6094, 6095, 6096, 6098, 6101, 6102, 6103, 6104, 6105, 6106, 6107, 6108, 6109, 6110, 6111, 6112, 6114, 6115, 6117, 6118, 6119, 6120, 6123, 6126, 6127, 6128, 6129, 6131, 6132, 6133, 6134, 6137, 6138, 6140, 6141, 6142, 6143, 6144, 6145, 6146, 6147, 6150, 6151, 6152, 6153, 6154, 6155, 6156, 6160, 6161, 6167, 6176, 6180, 6183, 6199, 6226, 6230, 6231, 6232, 6233, 6234, 6235, 6237, 6238, 6239, 6241, 6242, 6243, 6244, 6245, 6246, 6247, 6248, 6249, 6250, 6251, 6254, 6255, 6256, 6258, 6259, 6260, 6262, 6263, 6264, 6265, 6266, 6267, 6268, 6269, 6277, 6278, 6279, 6280, 6281, 6282, 6330, 6331, 6332, 6336, 6350, 6354, 6374, 6377, 6387, 6411, 6414, 6415, 6416, 6424, 6444, 6447, 6450, 6451, 6455, 6456, 6457, 6459, 6467, 6479, 6480, 6481, 6489, 6702, 6704, 6705, 6706, 6708, 6710, 6716, 6731, 6748, 6750, 6751, 6753, 6754, 6755, 6756, 6757, 6758, 6759, 6762, 6763, 6776, 6777, 6778, 6779, 6781, 6782, 6783, 6785, 6786, 6787, 6790, 6791, 6793, 6794, 6795, 6796, 6798, 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, 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, 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, 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, 12405, 12407, 12409, 12411, 12412, 12413, 12414, 12416, 12417, 12418, 12422, 12423, 12424, 12427, 12429, 12431, 12432, 12433, 12434, 12436, 12439, 12442, 12443, 12444, 12447, 12448, 12449, 12450, 12451, 12452, 12453, 12454, 12456, 12457, 12460, 12463, 12464, 12466, 12468, 12469, 12470, 12471, 12473, 12475, 12477, 12480, 12481, 12482, 12485, 12487, 12490, 12491, 12492, 12493, 12495, 12496, 12498, 12501, 12502, 12503, 12504, 12506, 12507, 12510, 12511, 12513, 12514, 12516, 12517, 12521, 12522, 12523, 12526, 12529, 12530, 12534, 12538, 12541, 12544, 12545, 12546, 12565, 12567, 12569, 12571, 12572, 12574, 12578, 12580, 12581, 12583, 12585, 12592, 12593, 12594, 12602, 12604, 12801, 12803, 12804, 12805, 12807, 12808, 12809, 12810, 12811, 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, 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, 12928, 12932, 12936, 12938, 12943, 12956, 12960, 12961, 12964, 12974, 12977, 12993, 12997, 12998, 13317, 13320, 13329, 13339, 13410, 13428, 13452, 13459, 13470)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
