| |
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 / 1227051096 * 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 (24215, 24216, 24218, 24219, 24221, 24243, 24244, 24246, 24248, 24263, 24265, 24277, 24281, 24282, 28701, 28702, 28707, 28713, 28715, 28716, 28717, 28719, 28721, 28723, 28725, 28728, 28733, 28734, 28736, 28738, 28741, 28743, 28744, 28745, 28748, 28751, 28753, 28763, 28771, 28775, 28779, 28781, 28783, 28785, 28786, 28788, 28789, 28802, 28901, 28902, 28903, 28904, 28905, 28906, 28909, 30512, 30513, 30514, 30522, 30537, 30541, 30546, 30555, 30559, 30560, 30562, 30568, 30572, 30582, 30708, 30710, 30711, 30724, 30726, 30736, 30741, 30742, 30751, 30755, 30756, 37012, 37030, 37057, 37059, 37083, 37095, 37110, 37111, 37145, 37150, 37151, 37166, 37301, 37302, 37303, 37304, 37305, 37307, 37308, 37309, 37310, 37311, 37312, 37313, 37314, 37315, 37316, 37317, 37320, 37321, 37322, 37323, 37325, 37326, 37327, 37329, 37331, 37332, 37333, 37336, 37337, 37338, 37339, 37341, 37343, 37350, 37351, 37353, 37354, 37357, 37361, 37362, 37363, 37364, 37365, 37367, 37369, 37370, 37371, 37373, 37377, 37378, 37379, 37381, 37384, 37385, 37391, 37394, 37395, 37397, 37401, 37402, 37403, 37404, 37405, 37406, 37407, 37408, 37409, 37410, 37411, 37412, 37414, 37415, 37416, 37419, 37421, 37422, 37424, 37450, 37499, 37616, 37641, 37642, 37645, 37656, 37657, 37681, 37690, 37701, 37705, 37707, 37708, 37709, 37710, 37711, 37713, 37714, 37715, 37716, 37717, 37719, 37721, 37722, 37723, 37724, 37725, 37726, 37727, 37729, 37730, 37731, 37732, 37733, 37737, 37738, 37742, 37743, 37744, 37745, 37748, 37752, 37753, 37754, 37755, 37756, 37757, 37760, 37762, 37763, 37764, 37765, 37766, 37769, 37770, 37771, 37772, 37773, 37774, 37777, 37778, 37779, 37801, 37802, 37803, 37804, 37806, 37807, 37809, 37810, 37811, 37813, 37814, 37815, 37816, 37818, 37819, 37820, 37821, 37822, 37824, 37825, 37826, 37828, 37829, 37830, 37831, 37840, 37841, 37842, 37843, 37845, 37846, 37847, 37848, 37849, 37851, 37852, 37853, 37854, 37857, 37860, 37861, 37862, 37863, 37864, 37865, 37866, 37867, 37868, 37869, 37870, 37871, 37872, 37873, 37874, 37876, 37877, 37878, 37879, 37880, 37881, 37882, 37885, 37886, 37887, 37888, 37890, 37891, 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, 40402, 40403, 40409, 40419, 40421, 40434, 40437, 40442, 40445, 40447, 40448, 40456, 40460, 40461, 40467, 40469, 40473, 40481, 40484, 40486, 40488, 40489, 40492, 40695, 40701, 40702, 40724, 40729, 40730, 40734, 40737, 40740, 40741, 40742, 40743, 40744, 40745, 40746, 40747, 40748, 40751, 40754, 40755, 40759, 40763, 40769, 40771, 40801, 40803, 40806, 40807, 40808, 40810, 40813, 40815, 40816, 40818, 40819, 40820, 40823, 40824, 40827, 40828, 40829, 40830, 40831, 40840, 40843, 40844, 40845, 40847, 40849, 40854, 40855, 40856, 40858, 40862, 40863, 40865, 40867, 40868, 40870, 40873, 40874, 40902, 40903, 40906, 40913, 40914, 40915, 40921, 40923, 40927, 40930, 40931, 40932, 40935, 40939, 40940, 40941, 40943, 40944, 40946, 40949, 40951, 40953, 40955, 40958, 40962, 40964, 40965, 40972, 40977, 40979, 40981, 40982, 40983, 40988, 40995, 40997, 40999, 41314, 41338, 41351, 41364, 41377, 41386, 41701, 41713, 41714, 41719, 41721, 41723, 41727, 41729, 41730, 41731, 41735, 41745, 41746, 41749, 41751, 41754, 41760, 41762, 41763, 41764, 41766, 41774, 41775, 41776, 41777, 41778, 41804, 41819, 41821, 41833, 42124, 42129, 42130, 42140, 42151, 42157, 42166, 42167, 42253, 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, 42711, 42715, 42717, 42720, 42728, 42731, 42733, 42735, 42741, 42742, 42753, 42758, 42759, 42761, 42786)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
