| |
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 / 7 * 10) + (url_view_cnt / 200 * 5) + user_session_time / 1227059991 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (97002, 97004, 97005, 97006, 97007, 97008, 97009, 97010, 97011, 97013, 97014, 97015, 97016, 97017, 97018, 97019, 97020, 97021, 97022, 97023, 97024, 97026, 97027, 97028, 97029, 97030, 97031, 97032, 97034, 97035, 97036, 97037, 97038, 97039, 97040, 97041, 97042, 97044, 97045, 97048, 97049, 97050, 97051, 97053, 97054, 97055, 97056, 97057, 97058, 97060, 97062, 97063, 97064, 97065, 97067, 97068, 97070, 97071, 97075, 97076, 97077, 97078, 97080, 97101, 97102, 97103, 97104, 97106, 97107, 97108, 97109, 97110, 97111, 97112, 97113, 97114, 97115, 97116, 97117, 97118, 97119, 97121, 97122, 97123, 97124, 97125, 97127, 97128, 97130, 97131, 97132, 97133, 97134, 97135, 97136, 97137, 97138, 97140, 97141, 97143, 97144, 97145, 97146, 97147, 97148, 97149, 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, 97281, 97282, 97283, 97286, 97290, 97291, 97292, 97293, 97294, 97296, 97298, 97299, 97301, 97302, 97303, 97304, 97305, 97306, 97307, 97308, 97309, 97310, 97311, 97312, 97313, 97314, 97321, 97322, 97325, 97335, 97338, 97342, 97344, 97346, 97347, 97350, 97351, 97352, 97355, 97358, 97359, 97360, 97361, 97362, 97364, 97368, 97371, 97373, 97374, 97375, 97378, 97381, 97383, 97384, 97385, 97392, 97396, 97567, 97631, 97761, 98001, 98002, 98003, 98010, 98022, 98023, 98030, 98042, 98047, 98092, 98093, 98303, 98304, 98321, 98323, 98327, 98328, 98330, 98332, 98333, 98335, 98336, 98338, 98344, 98348, 98349, 98351, 98352, 98354, 98355, 98356, 98360, 98361, 98371, 98372, 98373, 98374, 98375, 98377, 98385, 98387, 98388, 98389, 98390, 98394, 98395, 98396, 98397, 98398, 98401, 98402, 98403, 98404, 98405, 98406, 98407, 98408, 98409, 98411, 98412, 98413, 98415, 98416, 98418, 98421, 98422, 98424, 98430, 98431, 98433, 98434, 98438, 98439, 98442, 98443, 98444, 98445, 98446, 98447, 98448, 98450, 98455, 98460, 98464, 98465, 98466, 98467, 98468, 98471, 98477, 98481, 98485, 98492, 98493, 98494, 98497, 98498, 98499, 98500, 98501, 98502, 98503, 98504, 98505, 98506, 98507, 98508, 98509, 98512, 98513, 98516, 98520, 98522, 98527, 98530, 98531, 98532, 98533, 98537, 98538, 98539, 98540, 98541, 98542, 98544, 98546, 98547, 98554, 98556, 98557, 98558, 98559, 98561, 98563, 98564, 98565, 98568, 98570, 98572, 98576, 98577, 98579, 98580, 98581, 98582, 98583, 98584, 98585, 98586, 98589, 98590, 98591, 98593, 98596, 98597, 98599, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98609, 98610, 98611, 98612, 98613, 98614, 98616, 98617, 98619, 98620, 98621, 98622, 98623, 98624, 98625, 98626, 98628, 98629, 98631, 98632, 98635, 98637, 98638, 98639, 98640, 98641, 98642, 98643, 98644, 98645, 98647, 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, 98731, 98903, 98904, 98908, 98909, 98920, 98923, 98929, 98933, 98937, 98939, 98947, 98952)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
