| |
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 / 1227051896 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (28702, 28713, 28733, 28771, 28781, 28901, 28902, 28903, 28904, 28905, 28906, 28909, 30004, 30005, 30006, 30007, 30008, 30022, 30028, 30040, 30041, 30060, 30061, 30062, 30063, 30064, 30065, 30066, 30067, 30068, 30069, 30075, 30076, 30081, 30090, 30101, 30102, 30103, 30104, 30105, 30107, 30111, 30113, 30114, 30115, 30120, 30121, 30123, 30124, 30125, 30127, 30129, 30132, 30137, 30138, 30139, 30140, 30141, 30142, 30143, 30144, 30145, 30146, 30147, 30148, 30149, 30151, 30152, 30153, 30157, 30161, 30162, 30163, 30164, 30165, 30171, 30172, 30173, 30175, 30177, 30178, 30183, 30184, 30188, 30189, 30202, 30350, 30358, 30503, 30504, 30505, 30506, 30512, 30513, 30514, 30522, 30527, 30528, 30533, 30534, 30539, 30540, 30541, 30545, 30546, 30555, 30559, 30560, 30564, 30571, 30572, 30582, 30597, 30701, 30703, 30705, 30707, 30708, 30710, 30711, 30719, 30720, 30721, 30722, 30724, 30725, 30726, 30728, 30730, 30731, 30732, 30733, 30734, 30735, 30736, 30738, 30739, 30740, 30741, 30742, 30746, 30747, 30750, 30751, 30752, 30753, 30754, 30755, 30756, 30757, 35016, 35175, 35613, 35739, 35740, 35741, 35742, 35744, 35745, 35746, 35747, 35748, 35749, 35750, 35751, 35752, 35754, 35755, 35756, 35757, 35758, 35759, 35760, 35761, 35762, 35763, 35764, 35765, 35766, 35767, 35768, 35769, 35771, 35772, 35773, 35774, 35775, 35776, 35801, 35802, 35803, 35804, 35805, 35806, 35807, 35808, 35809, 35810, 35811, 35812, 35813, 35814, 35815, 35816, 35824, 35893, 35894, 35895, 35896, 35897, 35898, 35899, 35901, 35902, 35903, 35904, 35905, 35950, 35951, 35954, 35956, 35957, 35958, 35959, 35960, 35961, 35962, 35963, 35964, 35966, 35967, 35968, 35969, 35971, 35973, 35974, 35975, 35976, 35978, 35979, 35980, 35981, 35983, 35984, 35986, 35988, 35989, 36272, 36275, 37012, 37013, 37014, 37016, 37018, 37019, 37020, 37026, 37030, 37034, 37037, 37046, 37047, 37057, 37059, 37060, 37063, 37071, 37074, 37085, 37086, 37087, 37088, 37089, 37090, 37091, 37095, 37110, 37111, 37118, 37121, 37122, 37127, 37128, 37129, 37130, 37131, 37132, 37133, 37135, 37136, 37144, 37145, 37149, 37150, 37151, 37153, 37160, 37161, 37162, 37166, 37167, 37180, 37183, 37184, 37190, 37301, 37302, 37303, 37304, 37305, 37306, 37307, 37308, 37309, 37310, 37311, 37312, 37313, 37314, 37315, 37316, 37317, 37318, 37320, 37321, 37322, 37323, 37324, 37325, 37326, 37327, 37328, 37329, 37330, 37331, 37332, 37333, 37334, 37335, 37336, 37337, 37338, 37339, 37340, 37341, 37342, 37343, 37345, 37347, 37348, 37349, 37350, 37351, 37352, 37353, 37354, 37355, 37356, 37357, 37359, 37360, 37361, 37362, 37363, 37364, 37365, 37366, 37367, 37369, 37370, 37371, 37372, 37373, 37374, 37375, 37376, 37377, 37378, 37379, 37380, 37381, 37382, 37383, 37384, 37385, 37387, 37388, 37389, 37391, 37394, 37395, 37396, 37397, 37398, 37401, 37402, 37403, 37404, 37405, 37406, 37407, 37408, 37409, 37410, 37411, 37412, 37414, 37415, 37416, 37419, 37421, 37422, 37424, 37450, 37499, 37701, 37705, 37710, 37714, 37716, 37717, 37719, 37723, 37726, 37732, 37733, 37737, 37742, 37748, 37754, 37755, 37756, 37757, 37763, 37769, 37770, 37771, 37772, 37774, 37777, 37801, 37802, 37803, 37804, 37826, 37828, 37829, 37830, 37831, 37838, 37840, 37841, 37842, 37845, 37846, 37847, 37849, 37852, 37853, 37854, 37865, 37872, 37874, 37878, 37880, 37882, 37885, 37886, 37887, 37893, 37901, 37902, 37909, 37912, 37913, 37914, 37915, 37916, 37917, 37918, 37919, 37920, 37921, 37922, 37923, 37924, 37927, 37928, 37929, 37930, 37931, 37932, 37933, 37937, 37938, 37939, 37940, 37950, 37951, 37990, 37995, 37996, 37997, 37998, 37999, 38449, 38453, 38455, 38459, 38488, 38501, 38502, 38503, 38504, 38505, 38506, 38541, 38542, 38543, 38544, 38545, 38547, 38548, 38549, 38550, 38551, 38552, 38553, 38554, 38555, 38556, 38557, 38558, 38559, 38560, 38562, 38563, 38564, 38565, 38567, 38568, 38569, 38570, 38571, 38572, 38573, 38574, 38575, 38577, 38578, 38579, 38580, 38581, 38582, 38583, 38585, 38587, 38588, 38589, 42151)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
