| |
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 / 1 * 10) + user_session_time / 1227055299 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1050 and user_zip in (97001, 97002, 97004, 97005, 97006, 97007, 97008, 97009, 97010, 97011, 97013, 97014, 97015, 97017, 97018, 97019, 97020, 97021, 97022, 97023, 97024, 97027, 97028, 97029, 97030, 97031, 97032, 97033, 97034, 97035, 97036, 97037, 97038, 97039, 97040, 97041, 97042, 97044, 97045, 97048, 97049, 97050, 97051, 97053, 97054, 97055, 97056, 97057, 97058, 97060, 97062, 97063, 97065, 97067, 97068, 97070, 97071, 97078, 97080, 97104, 97123, 97124, 97133, 97140, 97180, 97201, 97202, 97203, 97204, 97205, 97206, 97207, 97208, 97209, 97210, 97211, 97212, 97213, 97214, 97215, 97216, 97217, 97218, 97219, 97220, 97221, 97222, 97223, 97224, 97225, 97226, 97227, 97228, 97229, 97230, 97231, 97232, 97233, 97236, 97238, 97239, 97240, 97242, 97251, 97253, 97254, 97255, 97256, 97258, 97259, 97266, 97267, 97268, 97269, 97271, 97272, 97280, 97282, 97283, 97286, 97290, 97292, 97293, 97294, 97296, 97299, 97307, 97308, 97309, 97342, 97346, 97350, 97358, 97359, 97360, 97362, 97373, 97375, 97711, 97730, 97734, 97741, 97750, 97760, 97761, 97812, 97818, 97823, 97826, 97830, 97836, 97838, 97839, 97843, 97844, 97848, 97861, 97864, 97874, 97875, 97882, 98304, 98330, 98336, 98355, 98356, 98361, 98377, 98533, 98564, 98582, 98585, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98609, 98610, 98613, 98616, 98617, 98619, 98620, 98622, 98623, 98625, 98626, 98628, 98629, 98635, 98639, 98642, 98645, 98648, 98649, 98650, 98651, 98653, 98655, 98660, 98661, 98662, 98663, 98664, 98665, 98666, 98667, 98668, 98670, 98671, 98672, 98673, 98674, 98675, 98682, 98683, 98684, 98685, 98686, 98687, 98901, 98902, 98903, 98904, 98907, 98908, 98909, 98920, 98921, 98923, 98926, 98929, 98930, 98932, 98933, 98934, 98935, 98936, 98937, 98938, 98939, 98942, 98944, 98946, 98947, 98948, 98950, 98951, 98952, 98953, 99301, 99302, 99309, 99319, 99320, 99321, 99322, 99336, 99337, 99338, 99345, 99346, 99349, 99350, 99352, 99353, 99356, 99536)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
