| |
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 / 1227055876 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1070 and user_zip in (97016, 97048, 97064, 97102, 97103, 97110, 97121, 97130, 97131, 97138, 97145, 97146, 97147, 98001, 98002, 98003, 98004, 98005, 98006, 98020, 98023, 98026, 98030, 98031, 98032, 98039, 98040, 98042, 98043, 98047, 98055, 98056, 98058, 98059, 98061, 98070, 98092, 98093, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98108, 98109, 98110, 98112, 98113, 98115, 98116, 98117, 98118, 98119, 98121, 98122, 98125, 98126, 98133, 98134, 98136, 98144, 98146, 98148, 98154, 98155, 98164, 98166, 98168, 98174, 98177, 98178, 98188, 98198, 98199, 98249, 98303, 98305, 98310, 98311, 98312, 98314, 98315, 98320, 98321, 98322, 98324, 98325, 98326, 98327, 98328, 98329, 98330, 98331, 98332, 98333, 98335, 98337, 98338, 98339, 98340, 98342, 98343, 98344, 98345, 98346, 98348, 98349, 98350, 98351, 98352, 98353, 98354, 98356, 98357, 98358, 98359, 98360, 98362, 98363, 98364, 98365, 98366, 98367, 98368, 98370, 98371, 98372, 98373, 98374, 98375, 98376, 98378, 98380, 98381, 98382, 98383, 98384, 98385, 98386, 98387, 98388, 98389, 98390, 98392, 98393, 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, 98524, 98526, 98527, 98528, 98530, 98531, 98532, 98533, 98535, 98536, 98537, 98538, 98539, 98540, 98541, 98542, 98544, 98546, 98547, 98548, 98550, 98552, 98554, 98555, 98556, 98557, 98558, 98559, 98560, 98561, 98562, 98563, 98564, 98565, 98566, 98568, 98569, 98570, 98571, 98572, 98575, 98576, 98577, 98579, 98580, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98590, 98591, 98592, 98593, 98595, 98596, 98597, 98599, 98609, 98611, 98612, 98614, 98621, 98624, 98625, 98626, 98631, 98632, 98637, 98638, 98640, 98641, 98643, 98644, 98645, 98647, 98649, 98731)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
