| |
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 / 1227051741 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1>1500 and user_zip in (28702, 28707, 28713, 28717, 28719, 28723, 28725, 28733, 28734, 28736, 28741, 28744, 28751, 28763, 28771, 28774, 28775, 28779, 28781, 28783, 28788, 28789, 28901, 28902, 28903, 28904, 28905, 28906, 28909, 29658, 29664, 30003, 30004, 30005, 30006, 30007, 30008, 30010, 30022, 30024, 30026, 30028, 30029, 30040, 30041, 30043, 30046, 30048, 30060, 30061, 30062, 30063, 30064, 30065, 30066, 30067, 30068, 30069, 30071, 30075, 30076, 30080, 30081, 30082, 30090, 30091, 30092, 30095, 30096, 30097, 30098, 30099, 30101, 30102, 30103, 30104, 30105, 30107, 30111, 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, 30327, 30328, 30338, 30339, 30340, 30341, 30342, 30346, 30350, 30358, 30360, 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, 35740, 35744, 35745, 35746, 35748, 35751, 35752, 35755, 35761, 35764, 35765, 35766, 35768, 35769, 35771, 35772, 35774, 35776, 35958, 35959, 35960, 35961, 35962, 35963, 35966, 35967, 35968, 35969, 35971, 35973, 35974, 35975, 35978, 35979, 35981, 35983, 35984, 35986, 35988, 35989, 36275, 37012, 37016, 37018, 37020, 37026, 37030, 37037, 37059, 37085, 37095, 37110, 37111, 37118, 37127, 37130, 37145, 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, 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, 37722, 37723, 37725, 37726, 37729, 37730, 37732, 37733, 37737, 37738, 37742, 37748, 37754, 37755, 37756, 37757, 37760, 37762, 37763, 37764, 37766, 37769, 37770, 37771, 37772, 37774, 37777, 37779, 37801, 37802, 37803, 37804, 37806, 37807, 37819, 37820, 37826, 37828, 37829, 37830, 37831, 37838, 37840, 37841, 37842, 37845, 37846, 37847, 37848, 37849, 37852, 37853, 37854, 37861, 37862, 37863, 37864, 37865, 37866, 37868, 37870, 37871, 37872, 37874, 37876, 37877, 37878, 37880, 37882, 37885, 37886, 37887, 37888, 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, 38551, 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, 38588, 38589, 42635, 42638, 42647, 42649)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
