| |
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 / 1227051730 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (24248, 37012, 37013, 37014, 37016, 37018, 37020, 37022, 37026, 37027, 37030, 37031, 37037, 37048, 37049, 37057, 37059, 37063, 37066, 37070, 37071, 37072, 37073, 37074, 37075, 37076, 37077, 37080, 37083, 37085, 37086, 37087, 37088, 37089, 37090, 37095, 37110, 37111, 37115, 37116, 37118, 37119, 37121, 37122, 37127, 37128, 37129, 37130, 37131, 37132, 37133, 37135, 37136, 37138, 37141, 37145, 37148, 37149, 37150, 37151, 37152, 37153, 37166, 37167, 37172, 37183, 37184, 37186, 37188, 37189, 37190, 37201, 37202, 37203, 37204, 37206, 37207, 37208, 37209, 37210, 37211, 37212, 37213, 37214, 37215, 37216, 37217, 37218, 37219, 37220, 37224, 37227, 37228, 37229, 37230, 37232, 37234, 37235, 37236, 37237, 37238, 37239, 37240, 37241, 37242, 37243, 37244, 37245, 37246, 37247, 37248, 37249, 37250, 37301, 37303, 37304, 37305, 37308, 37309, 37310, 37311, 37312, 37313, 37320, 37321, 37322, 37325, 37327, 37329, 37331, 37332, 37336, 37337, 37338, 37339, 37341, 37342, 37343, 37349, 37354, 37355, 37356, 37357, 37360, 37364, 37365, 37366, 37367, 37370, 37371, 37373, 37374, 37377, 37378, 37379, 37381, 37382, 37384, 37385, 37387, 37389, 37394, 37395, 37397, 37414, 37422, 37424, 37450, 37499, 37701, 37705, 37707, 37709, 37710, 37714, 37715, 37716, 37717, 37719, 37721, 37723, 37724, 37726, 37729, 37730, 37732, 37733, 37737, 37742, 37748, 37752, 37754, 37755, 37756, 37757, 37760, 37762, 37763, 37764, 37766, 37769, 37770, 37771, 37772, 37773, 37774, 37777, 37779, 37801, 37802, 37803, 37804, 37806, 37807, 37819, 37820, 37824, 37825, 37826, 37828, 37829, 37830, 37831, 37840, 37841, 37842, 37845, 37846, 37847, 37848, 37849, 37851, 37852, 37853, 37854, 37861, 37864, 37865, 37866, 37867, 37870, 37871, 37872, 37874, 37878, 37879, 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, 38575, 38577, 38578, 38579, 38580, 38581, 38582, 38583, 38585, 38587, 38588, 38589, 40004, 40008, 40009, 40012, 40013, 40020, 40033, 40037, 40040, 40048, 40049, 40051, 40052, 40053, 40060, 40061, 40062, 40063, 40069, 40078, 40080, 40107, 40110, 40140, 40145, 40150, 40159, 40160, 40162, 40175, 40310, 40328, 40330, 40339, 40340, 40356, 40372, 40385, 40390, 40402, 40403, 40404, 40405, 40409, 40410, 40419, 40421, 40422, 40423, 40434, 40437, 40440, 40442, 40444, 40445, 40446, 40447, 40448, 40452, 40456, 40460, 40461, 40464, 40467, 40468, 40469, 40473, 40475, 40476, 40481, 40484, 40486, 40488, 40489, 40492, 40495, 40695, 40701, 40702, 40724, 40729, 40730, 40734, 40737, 40740, 40741, 40742, 40743, 40744, 40745, 40746, 40747, 40748, 40751, 40754, 40755, 40759, 40763, 40769, 40771, 40813, 40819, 40827, 40840, 40845, 40856, 40863, 40873, 40874, 40902, 40903, 40906, 40913, 40914, 40915, 40921, 40923, 40930, 40931, 40932, 40935, 40939, 40940, 40941, 40943, 40944, 40946, 40949, 40951, 40953, 40955, 40958, 40962, 40965, 40972, 40977, 40979, 40982, 40983, 40988, 40995, 40997, 40999, 41338, 41351, 41386, 41714, 42101, 42102, 42103, 42104, 42109, 42120, 42122, 42123, 42124, 42127, 42128, 42129, 42130, 42131, 42133, 42134, 42135, 42140, 42141, 42142, 42150, 42151, 42152, 42153, 42154, 42156, 42157, 42159, 42160, 42163, 42164, 42166, 42167, 42170, 42171, 42201, 42202, 42206, 42207, 42209, 42210, 42214, 42219, 42235, 42252, 42253, 42257, 42259, 42261, 42270, 42274, 42275, 42276, 42283, 42285, 42287, 42288, 42501, 42502, 42503, 42516, 42518, 42519, 42528, 42533, 42539, 42541, 42544, 42553, 42558, 42564, 42565, 42566, 42567, 42602, 42603, 42629, 42631, 42632, 42633, 42634, 42635, 42637, 42638, 42642, 42647, 42649, 42653, 42701, 42702, 42711, 42712, 42713, 42715, 42716, 42717, 42718, 42719, 42720, 42721, 42722, 42724, 42726, 42728, 42729, 42731, 42732, 42733, 42735, 42740, 42741, 42742, 42743, 42746, 42748, 42749, 42753, 42754, 42755, 42757, 42758, 42759, 42761, 42762, 42764, 42765, 42776, 42782, 42783, 42784, 42786, 42788)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
