| |
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 + user_session_time / 1227008248 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1070 and user_zip in (501, 544, 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, 1824, 1826, 1827, 1840, 1841, 1843, 1844, 1845, 1850, 1851, 1852, 1853, 1854, 1856, 1862, 1863, 1864, 1865, 1866, 1867, 1876, 1879, 1880, 1886, 1887, 1888, 1889, 1890, 1901, 1902, 1904, 1905, 1906, 1907, 1908, 1910, 1923, 1940, 1945, 1949, 1960, 1970, 2018, 2019, 2020, 2021, 2025, 2026, 2027, 2029, 2030, 2031, 2032, 2035, 2038, 2040, 2041, 2043, 2044, 2045, 2047, 2048, 2050, 2051, 2052, 2053, 2054, 2055, 2056, 2059, 2060, 2061, 2062, 2065, 2066, 2067, 2070, 2071, 2072, 2081, 2085, 2090, 2093, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2111, 2112, 2113, 2114, 2115, 2116, 2117, 2118, 2119, 2120, 2121, 2122, 2123, 2124, 2125, 2126, 2127, 2128, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2151, 2152, 2153, 2154, 2155, 2156, 2157, 2158, 2159, 2160, 2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2179, 2180, 2181, 2184, 2185, 2186, 2187, 2188, 2189, 2190, 2191, 2192, 2193, 2194, 2195, 2196, 2199, 2201, 2202, 2203, 2204, 2205, 2206, 2207, 2208, 2209, 2210, 2211, 2212, 2215, 2216, 2217, 2222, 2238, 2239, 2241, 2254, 2258, 2266, 2269, 2272, 2277, 2283, 2284, 2293, 2295, 2297, 2301, 2302, 2303, 2304, 2305, 2322, 2324, 2325, 2327, 2330, 2331, 2332, 2333, 2334, 2337, 2338, 2339, 2341, 2343, 2344, 2345, 2346, 2347, 2348, 2349, 2350, 2351, 2355, 2356, 2357, 2358, 2359, 2360, 2361, 2362, 2363, 2364, 2366, 2367, 2368, 2370, 2375, 2379, 2381, 2382, 2401, 2402, 2403, 2404, 2405, 2407, 2420, 2421, 2445, 2446, 2447, 2451, 2452, 2453, 2454, 2456, 2457, 2458, 2459, 2460, 2461, 2462, 2464, 2465, 2466, 2467, 2468, 2471, 2472, 2474, 2475, 2476, 2477, 2478, 2479, 2481, 2482, 2492, 2493, 2494, 2495, 2532, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2542, 2543, 2549, 2551, 2552, 2553, 2556, 2557, 2558, 2559, 2561, 2562, 2563, 2567, 2568, 2571, 2573, 2574, 2575, 2576, 2595, 2625, 2635, 2644, 2649, 2702, 2703, 2712, 2713, 2714, 2715, 2717, 2718, 2719, 2720, 2721, 2722, 2723, 2724, 2725, 2726, 2735, 2738, 2739, 2740, 2741, 2742, 2743, 2744, 2745, 2746, 2747, 2748, 2760, 2761, 2762, 2763, 2764, 2766, 2767, 2768, 2769, 2770, 2771, 2777, 2779, 2780, 2781, 2783, 2789, 2790, 2791, 2801, 2802, 2804, 2805, 2806, 2807, 2808, 2809, 2812, 2813, 2814, 2815, 2816, 2817, 2818, 2822, 2823, 2824, 2825, 2826, 2827, 2828, 2829, 2830, 2831, 2832, 2833, 2835, 2836, 2837, 2838, 2839, 2840, 2841, 2842, 2852, 2854, 2857, 2858, 2859, 2860, 2861, 2862, 2863, 2864, 2865, 2871, 2872, 2873, 2874, 2875, 2876, 2877, 2878, 2879, 2880, 2881, 2882, 2883, 2885, 2886, 2887, 2888, 2889, 2891, 2892, 2893, 2894, 2895, 2896, 2898, 2901, 2902, 2903, 2904, 2905, 2906, 2907, 2908, 2909, 2910, 2911, 2912, 2914, 2915, 2916, 2917, 2918, 2919, 2920, 2921, 2940, 3030, 3031, 3033, 3043, 3047, 3048, 3049, 3051, 3052, 3054, 3055, 3057, 3058, 3060, 3061, 3062, 3063, 3064, 3070, 3071, 3076, 3079, 3082, 3084, 3086, 3087, 3105, 3107, 3108, 3111, 3342, 3431, 3435, 3438, 3441, 3442, 3443, 3444, 3445, 3446, 3447, 3448, 3449, 3450, 3451, 3452, 3455, 3457, 3458, 3461, 3462, 3465, 3466, 3467, 3468, 3469, 3470, 3477, 3604, 3608, 5141, 5201, 5210, 5260, 5261, 5301, 5302, 5303, 5304, 5341, 5342, 5344, 5345, 5346, 5350, 5351, 5352, 5353, 5354, 5355, 5356, 5357, 5358, 5361, 5362, 5363, 5364, 5501, 5544, 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, 6320, 6330, 6331, 6332, 6333, 6334, 6335, 6336, 6337, 6339, 6340, 6349, 6350, 6351, 6353, 6354, 6355, 6357, 6359, 6360, 6365, 6370, 6371, 6372, 6373, 6374, 6375, 6376, 6377, 6378, 6379, 6380, 6382, 6383, 6384, 6385, 6386, 6387, 6388, 6389, 6390, 6401, 6403, 6404, 6405, 6408, 6409, 6410, 6411, 6412, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6422, 6423, 6424, 6426, 6430, 6431, 6432, 6436, 6437, 6438, 6439, 6440, 6441, 6442, 6443, 6444, 6447, 6450, 6451, 6454, 6455, 6456, 6457, 6459, 6460, 6467, 6468, 6469, 6470, 6471, 6472, 6473, 6474, 6475, 6477, 6478, 6479, 6480, 6481, 6482, 6483, 6484, 6487, 6488, 6489, 6490, 6491, 6492, 6493, 6494, 6497, 6498, 6501, 6502, 6503, 6504, 6505, 6506, 6507, 6508, 6509, 6510, 6511, 6512, 6513, 6514, 6515, 6516, 6517, 6518, 6519, 6520, 6521, 6524, 6525, 6530, 6531, 6532, 6533, 6534, 6535, 6536, 6537, 6538, 6540, 6601, 6602, 6604, 6605, 6606, 6607, 6608, 6610, 6611, 6612, 6614, 6615, 6650, 6673, 6699, 6701, 6702, 6703, 6704, 6705, 6706, 6708, 6710, 6712, 6716, 6720, 6721, 6722, 6723, 6724, 6725, 6726, 6731, 6748, 6749, 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, 6815, 6816, 6817, 6819, 6820, 6824, 6825, 6829, 6830, 6831, 6832, 6836, 6840, 6842, 6850, 6851, 6852, 6853, 6854, 6855, 6856, 6857, 6858, 6859, 6860, 6870, 6875, 6876, 6877, 6878, 6879, 6880, 6881, 6883, 6888, 6889, 6890, 6896, 6897, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6910, 6911, 6912, 6913, 6914, 6920, 6921, 6922, 6925, 6926, 6927, 6928, 6993, 7020, 7024, 7423, 7446, 7458, 7605, 7610, 7620, 7621, 7624, 7626, 7627, 7628, 7630, 7631, 7632, 7640, 7641, 7642, 7645, 7646, 7647, 7648, 7649, 7652, 7656, 7661, 7666, 7670, 7675, 7676, 7677, 10027, 10030, 10031, 10032, 10033, 10034, 10035, 10037, 10039, 10040, 10422, 10451, 10452, 10453, 10454, 10455, 10456, 10457, 10458, 10459, 10460, 10461, 10462, 10463, 10464, 10465, 10466, 10467, 10468, 10469, 10470, 10471, 10472, 10473, 10474, 10475, 10499, 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, 10805, 10901, 10910, 10911, 10913, 10914, 10916, 10917, 10918, 10920, 10922, 10923, 10926, 10927, 10928, 10930, 10931, 10950, 10952, 10953, 10954, 10956, 10957, 10960, 10962, 10964, 10965, 10968, 10970, 10974, 10975, 10976, 10977, 10980, 10982, 10983, 10984, 10986, 10987, 10989, 10992, 10993, 10994, 10995, 10996, 11001, 11002, 11003, 11004, 11005, 11010, 11020, 11021, 11022, 11023, 11024, 11025, 11026, 11027, 11030, 11040, 11041, 11042, 11043, 11044, 11050, 11051, 11052, 11053, 11054, 11055, 11096, 11099, 11103, 11105, 11302, 11351, 11354, 11355, 11356, 11357, 11358, 11359, 11360, 11361, 11362, 11363, 11364, 11365, 11366, 11367, 11368, 11369, 11370, 11371, 11372, 11373, 11374, 11375, 11411, 11412, 11413, 11415, 11418, 11419, 11420, 11422, 11423, 11426, 11427, 11428, 11429, 11432, 11433, 11434, 11435, 11436, 11439, 11501, 11507, 11510, 11514, 11516, 11518, 11520, 11530, 11531, 11535, 11536, 11542, 11545, 11547, 11548, 11549, 11550, 11551, 11552, 11553, 11554, 11555, 11556, 11557, 11558, 11559, 11560, 11561, 11562, 11563, 11564, 11565, 11566, 11568, 11569, 11570, 11571, 11572, 11575, 11576, 11577, 11579, 11580, 11581, 11582, 11583, 11588, 11590, 11592, 11593, 11594, 11595, 11596, 11597, 11598, 11701, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11713, 11714, 11715, 11716, 11717, 11718, 11719, 11720, 11721, 11722, 11724, 11725, 11726, 11727, 11729, 11730, 11731, 11732, 11733, 11735, 11736, 11737, 11738, 11739, 11740, 11741, 11742, 11743, 11745, 11746, 11747, 11749, 11750, 11751, 11752, 11753, 11754, 11755, 11756, 11757, 11758, 11760, 11762, 11763, 11764, 11765, 11766, 11767, 11768, 11769, 11770, 11771, 11772, 11773, 11774, 11775, 11776, 11777, 11778, 11779, 11780, 11782, 11783, 11784, 11786, 11787, 11788, 11789, 11790, 11791, 11792, 11793, 11794, 11795, 11796, 11797, 11798, 11801, 11802, 11803, 11804, 11805, 11815, 11819, 11853, 11854, 11855, 11901, 11930, 11931, 11932, 11933, 11934, 11935, 11937, 11939, 11940, 11941, 11942, 11944, 11946, 11947, 11948, 11949, 11950, 11951, 11952, 11953, 11954, 11955, 11956, 11957, 11958, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11967, 11968, 11969, 11970, 11971, 11972, 11973, 11975, 11976, 11977, 11978, 11980, 12015, 12017, 12018, 12022, 12024, 12029, 12033, 12037, 12040, 12042, 12045, 12046, 12050, 12051, 12052, 12058, 12060, 12061, 12062, 12063, 12075, 12077, 12081, 12082, 12087, 12089, 12106, 12115, 12123, 12124, 12125, 12130, 12132, 12136, 12138, 12140, 12143, 12144, 12153, 12156, 12158, 12161, 12162, 12165, 12168, 12169, 12172, 12173, 12174, 12176, 12179, 12184, 12192, 12195, 12196, 12198, 12401, 12404, 12409, 12411, 12413, 12414, 12417, 12419, 12427, 12429, 12431, 12432, 12433, 12436, 12440, 12443, 12447, 12448, 12449, 12451, 12453, 12456, 12461, 12463, 12466, 12470, 12471, 12472, 12473, 12475, 12477, 12481, 12482, 12484, 12485, 12486, 12487, 12490, 12491, 12493, 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, 12553, 12557, 12561, 12563, 12564, 12565, 12567, 12568, 12569, 12570, 12571, 12572, 12574, 12575, 12577, 12578, 12580, 12581, 12582, 12583, 12584, 12585, 12586, 12589, 12590, 12592, 12593, 12594, 12601, 12602, 12603, 12604, 12807, 12938)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
