| |
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 / 1227055967 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (59842, 59867, 83501, 83520, 83522, 83523, 83524, 83526, 83530, 83533, 83534, 83535, 83536, 83537, 83539, 83540, 83541, 83543, 83544, 83545, 83546, 83548, 83551, 83552, 83553, 83554, 83555, 83801, 83802, 83803, 83804, 83806, 83808, 83809, 83810, 83812, 83813, 83814, 83815, 83816, 83822, 83823, 83824, 83827, 83830, 83832, 83833, 83834, 83835, 83837, 83839, 83841, 83842, 83843, 83844, 83846, 83849, 83850, 83851, 83854, 83855, 83857, 83858, 83861, 83866, 83867, 83868, 83869, 83870, 83871, 83872, 83873, 83874, 83876, 83877, 97587, 97810, 97813, 97821, 97827, 97828, 97835, 97857, 97862, 97876, 97885, 97886, 98832, 98837, 98853, 98857, 98860, 99001, 99003, 99004, 99005, 99006, 99008, 99009, 99011, 99012, 99013, 99014, 99015, 99016, 99017, 99018, 99019, 99020, 99021, 99022, 99023, 99025, 99026, 99027, 99029, 99030, 99031, 99032, 99033, 99034, 99036, 99037, 99039, 99040, 99066, 99102, 99103, 99104, 99105, 99109, 99110, 99111, 99113, 99117, 99122, 99125, 99127, 99128, 99129, 99130, 99134, 99135, 99136, 99137, 99143, 99144, 99147, 99148, 99149, 99154, 99156, 99158, 99159, 99161, 99163, 99164, 99165, 99169, 99170, 99171, 99173, 99174, 99176, 99179, 99180, 99181, 99185, 99201, 99202, 99203, 99204, 99205, 99206, 99207, 99208, 99209, 99210, 99211, 99212, 99213, 99214, 99215, 99216, 99217, 99218, 99219, 99220, 99223, 99224, 99228, 99251, 99252, 99256, 99258, 99260, 99299, 99301, 99302, 99323, 99324, 99326, 99327, 99328, 99329, 99330, 99332, 99333, 99335, 99336, 99337, 99338, 99341, 99343, 99344, 99347, 99348, 99352, 99359, 99360, 99361, 99362, 99363, 99371, 99401, 99402, 99403, 99536)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
