| |
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 / 1227039356 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1140 and user_zip in (73001, 73002, 73003, 73004, 73005, 73006, 73007, 73008, 73009, 73010, 73011, 73012, 73013, 73014, 73015, 73016, 73017, 73018, 73019, 73020, 73021, 73022, 73023, 73024, 73026, 73029, 73030, 73031, 73032, 73033, 73034, 73036, 73038, 73040, 73041, 73042, 73043, 73044, 73045, 73047, 73048, 73049, 73051, 73052, 73053, 73054, 73055, 73057, 73058, 73059, 73062, 73064, 73065, 73066, 73067, 73068, 73069, 73070, 73071, 73072, 73074, 73075, 73078, 73079, 73080, 73082, 73083, 73084, 73085, 73086, 73089, 73090, 73092, 73093, 73094, 73095, 73096, 73097, 73098, 73099, 73101, 73102, 73103, 73104, 73105, 73106, 73107, 73108, 73109, 73110, 73111, 73112, 73113, 73114, 73115, 73116, 73117, 73118, 73119, 73120, 73121, 73122, 73123, 73124, 73125, 73126, 73127, 73128, 73129, 73130, 73131, 73132, 73134, 73135, 73136, 73137, 73139, 73140, 73141, 73142, 73143, 73144, 73145, 73146, 73147, 73148, 73149, 73150, 73151, 73152, 73153, 73154, 73155, 73156, 73157, 73159, 73160, 73162, 73163, 73164, 73165, 73167, 73169, 73170, 73172, 73173, 73177, 73178, 73179, 73180, 73184, 73185, 73189, 73190, 73193, 73194, 73196, 73197, 73198, 73199, 73367, 73401, 73402, 73403, 73425, 73430, 73432, 73433, 73434, 73435, 73436, 73437, 73438, 73439, 73440, 73441, 73442, 73443, 73444, 73445, 73446, 73447, 73448, 73449, 73450, 73453, 73455, 73456, 73458, 73459, 73460, 73461, 73463, 73476, 73481, 73487, 73488, 73491, 73501, 73502, 73503, 73505, 73506, 73507, 73520, 73521, 73522, 73523, 73526, 73527, 73528, 73529, 73530, 73531, 73532, 73533, 73534, 73536, 73538, 73539, 73540, 73541, 73542, 73543, 73546, 73547, 73548, 73549, 73551, 73552, 73553, 73554, 73555, 73556, 73557, 73558, 73559, 73560, 73561, 73562, 73564, 73565, 73566, 73567, 73568, 73569, 73570, 73572, 73573, 73575, 73601, 73622, 73624, 73632, 73641, 73651, 73655, 73661, 73664, 73750, 73762, 73764, 74520, 74525, 74530, 74531, 74533, 74534, 74535, 74538, 74556, 74572, 74701, 74720, 74729, 74730, 74731, 74733, 74747, 74748, 74753, 74801, 74802, 74804, 74807, 74818, 74820, 74821, 74825, 74826, 74827, 74830, 74831, 74836, 74837, 74840, 74842, 74843, 74844, 74848, 74849, 74851, 74852, 74854, 74855, 74856, 74857, 74864, 74865, 74866, 74867, 74868, 74869, 74871, 74872, 74873, 74878, 74881, 74884, 74894, 75008, 75020, 75021, 75027, 75029, 75058, 75076, 75090, 75091, 75092, 75459, 76023, 76073, 76078, 76201, 76202, 76203, 76204, 76206, 76207, 76208, 76209, 76225, 76227, 76228, 76230, 76233, 76234, 76238, 76239, 76240, 76241, 76245, 76246, 76249, 76250, 76251, 76252, 76253, 76255, 76258, 76259, 76261, 76263, 76264, 76265, 76266, 76267, 76268, 76270, 76271, 76272, 76273, 76299, 76301, 76302, 76303, 76304, 76305, 76306, 76307, 76308, 76309, 76310, 76311, 76351, 76352, 76354, 76356, 76357, 76360, 76364, 76365, 76366, 76367, 76369, 76370, 76373, 76374, 76377, 76379, 76384, 76385, 76389, 76426, 76427, 76431, 76458, 76459, 76460, 79225, 79247)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
