| |
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 / 1227039427 * 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 (66727, 66736, 66747, 66757, 66759, 66777, 66840, 66842, 66843, 66851, 66853, 66855, 66861, 66862, 66863, 66866, 67001, 67002, 67003, 67004, 67005, 67008, 67009, 67010, 67012, 67013, 67016, 67017, 67018, 67019, 67020, 67022, 67023, 67024, 67025, 67026, 67028, 67030, 67031, 67033, 67035, 67036, 67037, 67038, 67039, 67041, 67042, 67045, 67047, 67049, 67050, 67051, 67052, 67053, 67055, 67056, 67057, 67058, 67060, 67061, 67062, 67063, 67065, 67066, 67067, 67068, 67069, 67070, 67071, 67072, 67073, 67074, 67101, 67102, 67103, 67104, 67105, 67106, 67107, 67108, 67110, 67111, 67112, 67114, 67117, 67118, 67119, 67120, 67122, 67123, 67124, 67128, 67131, 67132, 67133, 67134, 67135, 67137, 67138, 67140, 67142, 67143, 67144, 67146, 67147, 67149, 67150, 67151, 67152, 67154, 67156, 67159, 67201, 67202, 67203, 67204, 67205, 67206, 67207, 67208, 67209, 67210, 67211, 67212, 67213, 67214, 67215, 67216, 67217, 67218, 67219, 67220, 67221, 67222, 67223, 67226, 67227, 67228, 67230, 67231, 67232, 67233, 67235, 67236, 67251, 67256, 67257, 67259, 67260, 67275, 67276, 67277, 67278, 67301, 67333, 67334, 67337, 67340, 67344, 67345, 67346, 67347, 67349, 67351, 67352, 67353, 67355, 67360, 67361, 67363, 67364, 67411, 67428, 67435, 67443, 67501, 67502, 67504, 67505, 67510, 67514, 67522, 67543, 67546, 67561, 67566, 67568, 67570, 67578, 67579, 67581, 67583, 67585, 67630, 73003, 73007, 73013, 73016, 73022, 73027, 73028, 73034, 73044, 73049, 73050, 73054, 73056, 73058, 73061, 73063, 73073, 73077, 73078, 73083, 73084, 73105, 73111, 73112, 73113, 73114, 73116, 73118, 73120, 73121, 73122, 73123, 73124, 73126, 73131, 73132, 73134, 73136, 73137, 73140, 73141, 73142, 73143, 73144, 73146, 73147, 73148, 73151, 73152, 73153, 73154, 73155, 73156, 73157, 73162, 73163, 73164, 73167, 73172, 73177, 73178, 73180, 73184, 73185, 73189, 73190, 73193, 73194, 73196, 73197, 73198, 73199, 73371, 73701, 73702, 73703, 73705, 73706, 73716, 73717, 73718, 73719, 73720, 73722, 73724, 73726, 73727, 73728, 73729, 73730, 73731, 73733, 73734, 73735, 73736, 73737, 73738, 73739, 73741, 73742, 73743, 73744, 73746, 73747, 73749, 73750, 73753, 73754, 73755, 73756, 73757, 73758, 73759, 73760, 73761, 73762, 73763, 73764, 73766, 73768, 73770, 73771, 73772, 73773, 73838, 73860, 74001, 74002, 74003, 74004, 74005, 74006, 74009, 74010, 74013, 74020, 74021, 74022, 74023, 74026, 74027, 74028, 74029, 74030, 74032, 74034, 74035, 74037, 74038, 74039, 74041, 74042, 74044, 74045, 74046, 74048, 74050, 74051, 74052, 74053, 74054, 74055, 74056, 74058, 74059, 74060, 74061, 74062, 74063, 74064, 74066, 74067, 74068, 74070, 74071, 74072, 74073, 74074, 74075, 74076, 74077, 74078, 74079, 74080, 74081, 74082, 74083, 74084, 74085, 74103, 74104, 74105, 74106, 74107, 74110, 74112, 74114, 74115, 74116, 74117, 74119, 74120, 74121, 74126, 74127, 74128, 74129, 74130, 74131, 74132, 74135, 74136, 74141, 74145, 74147, 74148, 74149, 74150, 74152, 74153, 74155, 74156, 74157, 74158, 74159, 74169, 74170, 74171, 74172, 74177, 74182, 74183, 74184, 74186, 74187, 74189, 74192, 74193, 74194, 74601, 74602, 74603, 74604, 74630, 74631, 74632, 74633, 74636, 74637, 74640, 74641, 74643, 74644, 74646, 74647, 74650, 74651, 74652, 74653, 74824, 74832, 74834, 74869, 74875, 74881)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
