| |
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 + user_session_time / 1227039703 * 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 (73001, 73002, 73003, 73004, 73005, 73006, 73008, 73009, 73010, 73011, 73012, 73013, 73014, 73015, 73016, 73017, 73018, 73019, 73021, 73022, 73023, 73024, 73028, 73029, 73031, 73033, 73036, 73038, 73040, 73041, 73042, 73043, 73047, 73048, 73052, 73053, 73055, 73059, 73062, 73064, 73065, 73067, 73069, 73071, 73072, 73078, 73079, 73082, 73083, 73085, 73089, 73090, 73092, 73093, 73094, 73096, 73097, 73099, 73101, 73102, 73103, 73104, 73105, 73106, 73107, 73108, 73109, 73111, 73112, 73114, 73115, 73116, 73117, 73118, 73119, 73120, 73121, 73122, 73125, 73127, 73128, 73129, 73131, 73132, 73134, 73135, 73139, 73140, 73142, 73149, 73154, 73159, 73160, 73162, 73169, 73170, 73172, 73173, 73179, 73367, 73371, 73501, 73502, 73503, 73505, 73506, 73507, 73521, 73522, 73523, 73526, 73527, 73528, 73529, 73530, 73531, 73532, 73533, 73534, 73536, 73537, 73538, 73539, 73540, 73541, 73542, 73543, 73544, 73546, 73547, 73548, 73549, 73550, 73551, 73552, 73553, 73554, 73555, 73556, 73557, 73558, 73559, 73560, 73562, 73564, 73566, 73567, 73568, 73570, 73571, 73572, 73575, 73601, 73620, 73622, 73624, 73625, 73626, 73627, 73628, 73632, 73638, 73639, 73641, 73642, 73644, 73645, 73646, 73647, 73648, 73650, 73651, 73654, 73655, 73656, 73658, 73659, 73660, 73661, 73662, 73663, 73664, 73666, 73667, 73668, 73669, 73673, 73716, 73718, 73720, 73724, 73726, 73729, 73731, 73734, 73735, 73737, 73739, 73741, 73742, 73744, 73746, 73747, 73750, 73754, 73755, 73756, 73760, 73762, 73763, 73764, 73768, 73770, 73772, 73773, 73801, 73802, 73832, 73835, 73838, 73840, 73841, 73843, 73848, 73851, 73852, 73853, 73857, 73858, 73859, 73860, 76354, 76360, 76364, 76369, 76373, 76384, 76385, 79002, 79003, 79011, 79014, 79024, 79034, 79046, 79054, 79056, 79057, 79059, 79061, 79077, 79079, 79095, 79096, 79201, 79222, 79225, 79230, 79233, 79237, 79238, 79240, 79245, 79247, 79251, 79252, 79259)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
