| |
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 / 1227052079 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1050 and user_zip in (28702, 28713, 28717, 28719, 28723, 28725, 28733, 28734, 28736, 28741, 28744, 28763, 28771, 28775, 28779, 28781, 28788, 28789, 28901, 28902, 28903, 28904, 28905, 28906, 28909, 29658, 29664, 30003, 30004, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30019, 30022, 30023, 30024, 30026, 30028, 30029, 30031, 30033, 30036, 30037, 30040, 30041, 30042, 30043, 30044, 30045, 30046, 30047, 30048, 30060, 30061, 30062, 30063, 30064, 30065, 30066, 30067, 30068, 30069, 30071, 30074, 30075, 30076, 30077, 30080, 30081, 30082, 30084, 30085, 30086, 30090, 30091, 30092, 30093, 30095, 30096, 30097, 30098, 30099, 30101, 30102, 30103, 30104, 30105, 30106, 30107, 30111, 30113, 30114, 30115, 30120, 30121, 30122, 30123, 30124, 30125, 30126, 30127, 30129, 30132, 30134, 30137, 30138, 30139, 30140, 30141, 30142, 30143, 30144, 30145, 30146, 30147, 30148, 30149, 30151, 30152, 30153, 30157, 30161, 30162, 30163, 30164, 30165, 30168, 30171, 30172, 30173, 30175, 30177, 30178, 30179, 30183, 30184, 30188, 30189, 30202, 30301, 30302, 30304, 30305, 30309, 30318, 30319, 30321, 30323, 30324, 30325, 30326, 30327, 30328, 30329, 30332, 30333, 30338, 30339, 30340, 30341, 30342, 30343, 30345, 30346, 30347, 30348, 30350, 30351, 30353, 30355, 30356, 30357, 30358, 30359, 30360, 30361, 30362, 30363, 30364, 30365, 30366, 30367, 30368, 30369, 30370, 30371, 30374, 30375, 30376, 30377, 30378, 30379, 30380, 30381, 30384, 30385, 30386, 30387, 30388, 30389, 30390, 30392, 30394, 30396, 30398, 30399, 30501, 30502, 30503, 30504, 30505, 30506, 30507, 30510, 30511, 30512, 30513, 30514, 30515, 30517, 30518, 30519, 30522, 30523, 30525, 30527, 30528, 30531, 30533, 30534, 30535, 30537, 30539, 30540, 30541, 30542, 30543, 30544, 30545, 30546, 30547, 30548, 30552, 30554, 30555, 30558, 30559, 30560, 30562, 30563, 30564, 30566, 30567, 30568, 30571, 30572, 30573, 30575, 30576, 30577, 30580, 30581, 30582, 30596, 30597, 30598, 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, 30881, 31106, 31107, 31119, 31126, 31131, 31139, 31141, 31145, 31146, 31150, 31156, 31191, 31192, 31193, 31195, 31196, 31197, 31198, 31199, 35740, 35741, 35744, 35745, 35746, 35747, 35748, 35750, 35751, 35752, 35755, 35759, 35760, 35761, 35762, 35763, 35764, 35765, 35766, 35767, 35768, 35769, 35771, 35772, 35774, 35776, 35807, 35809, 35811, 35812, 35813, 35814, 35815, 35893, 35894, 35895, 35896, 35897, 35898, 35902, 35950, 35951, 35957, 35958, 35959, 35960, 35961, 35962, 35963, 35966, 35967, 35968, 35969, 35971, 35973, 35974, 35975, 35976, 35978, 35979, 35981, 35983, 35984, 35986, 35988, 35989, 36272, 36275, 37012, 37016, 37018, 37020, 37026, 37030, 37037, 37059, 37085, 37095, 37110, 37111, 37118, 37127, 37128, 37130, 37149, 37160, 37161, 37162, 37166, 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, 37709, 37710, 37714, 37716, 37717, 37719, 37721, 37723, 37726, 37732, 37733, 37737, 37738, 37742, 37748, 37754, 37755, 37756, 37757, 37763, 37764, 37766, 37769, 37770, 37771, 37772, 37774, 37777, 37779, 37801, 37802, 37803, 37804, 37806, 37807, 37820, 37826, 37828, 37829, 37830, 37831, 37838, 37840, 37841, 37842, 37845, 37846, 37847, 37848, 37849, 37852, 37853, 37854, 37862, 37863, 37864, 37865, 37868, 37871, 37872, 37874, 37876, 37878, 37880, 37882, 37885, 37886, 37887, 37892, 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, 38501, 38502, 38503, 38504, 38505, 38506, 38541, 38542, 38543, 38544, 38545, 38547, 38548, 38549, 38550, 38552, 38553, 38554, 38555, 38556, 38557, 38558, 38559, 38560, 38562, 38563, 38564, 38565, 38567, 38568, 38569, 38570, 38571, 38572, 38573, 38574, 38577, 38578, 38579, 38580, 38581, 38582, 38583, 38585, 38587, 38589, 39901)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
