| |
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 / 4 * 10) + user_session_time / 1227040984 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (97001, 97002, 97004, 97005, 97006, 97007, 97008, 97009, 97010, 97011, 97013, 97015, 97017, 97019, 97020, 97021, 97022, 97023, 97024, 97026, 97027, 97028, 97030, 97032, 97034, 97035, 97036, 97037, 97038, 97041, 97042, 97045, 97049, 97055, 97057, 97060, 97062, 97063, 97067, 97068, 97070, 97071, 97078, 97080, 97101, 97111, 97114, 97115, 97123, 97127, 97128, 97132, 97137, 97140, 97148, 97180, 97201, 97202, 97204, 97205, 97206, 97207, 97208, 97209, 97210, 97211, 97212, 97213, 97214, 97215, 97216, 97218, 97219, 97220, 97221, 97222, 97223, 97224, 97225, 97226, 97227, 97228, 97229, 97230, 97232, 97233, 97236, 97238, 97239, 97240, 97242, 97251, 97253, 97255, 97256, 97258, 97259, 97266, 97267, 97268, 97269, 97271, 97272, 97280, 97282, 97283, 97286, 97290, 97292, 97293, 97294, 97296, 97299, 97301, 97302, 97303, 97304, 97305, 97306, 97307, 97308, 97309, 97310, 97311, 97312, 97313, 97314, 97321, 97322, 97324, 97325, 97326, 97327, 97329, 97330, 97331, 97333, 97335, 97336, 97338, 97339, 97342, 97343, 97344, 97345, 97346, 97347, 97348, 97350, 97351, 97352, 97355, 97357, 97358, 97359, 97360, 97361, 97362, 97365, 97366, 97370, 97371, 97372, 97373, 97374, 97375, 97376, 97377, 97378, 97380, 97381, 97383, 97384, 97385, 97386, 97389, 97390, 97391, 97392, 97394, 97396, 97401, 97402, 97403, 97404, 97405, 97408, 97409, 97412, 97413, 97419, 97424, 97425, 97426, 97427, 97428, 97429, 97430, 97431, 97432, 97434, 97435, 97436, 97437, 97438, 97439, 97440, 97443, 97446, 97447, 97448, 97451, 97452, 97453, 97454, 97455, 97456, 97457, 97461, 97462, 97463, 97467, 97470, 97472, 97473, 97477, 97478, 97479, 97480, 97482, 97484, 97486, 97487, 97488, 97489, 97490, 97492, 97493, 97494, 97495, 97496, 97498, 97499, 97536, 97602, 97604, 97631, 97638, 97641, 97701, 97702, 97707, 97708, 97709, 97711, 97712, 97730, 97731, 97733, 97734, 97735, 97737, 97739, 97741, 97752, 97753, 97754, 97756, 97759, 97760, 97761, 97795, 98607, 98671)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
