| |
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 / 1227055404 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1120 and user_zip in (97002, 97004, 97005, 97006, 97007, 97008, 97009, 97010, 97011, 97013, 97014, 97015, 97016, 97018, 97019, 97020, 97022, 97024, 97027, 97030, 97031, 97034, 97035, 97044, 97045, 97048, 97051, 97053, 97054, 97055, 97056, 97060, 97062, 97064, 97068, 97070, 97075, 97076, 97077, 97078, 97080, 97102, 97103, 97104, 97106, 97107, 97108, 97109, 97110, 97111, 97113, 97114, 97115, 97116, 97117, 97118, 97119, 97121, 97123, 97124, 97125, 97127, 97128, 97130, 97131, 97132, 97133, 97134, 97136, 97137, 97138, 97140, 97141, 97143, 97144, 97145, 97146, 97147, 97148, 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, 97271, 97272, 97280, 97281, 97282, 97283, 97286, 97290, 97291, 97292, 97293, 97294, 97296, 97298, 97299, 98001, 98002, 98003, 98004, 98005, 98006, 98007, 98008, 98009, 98010, 98011, 98012, 98013, 98014, 98015, 98019, 98020, 98021, 98022, 98023, 98024, 98025, 98026, 98027, 98028, 98029, 98030, 98031, 98032, 98033, 98034, 98035, 98036, 98037, 98038, 98039, 98040, 98041, 98042, 98043, 98045, 98047, 98050, 98051, 98052, 98053, 98054, 98055, 98056, 98057, 98058, 98059, 98060, 98061, 98062, 98063, 98064, 98065, 98067, 98068, 98070, 98071, 98072, 98073, 98074, 98075, 98082, 98083, 98092, 98093, 98101, 98102, 98103, 98104, 98105, 98106, 98107, 98108, 98109, 98110, 98111, 98112, 98113, 98114, 98115, 98116, 98117, 98118, 98119, 98121, 98122, 98124, 98125, 98126, 98129, 98130, 98131, 98132, 98133, 98134, 98136, 98138, 98140, 98144, 98145, 98146, 98148, 98150, 98151, 98154, 98155, 98158, 98160, 98161, 98164, 98166, 98168, 98171, 98174, 98177, 98178, 98181, 98184, 98185, 98188, 98190, 98191, 98195, 98198, 98199, 98203, 98204, 98206, 98208, 98236, 98249, 98272, 98275, 98291, 98296, 98303, 98304, 98310, 98311, 98312, 98314, 98315, 98319, 98320, 98321, 98322, 98323, 98325, 98327, 98328, 98329, 98330, 98332, 98333, 98335, 98336, 98337, 98338, 98339, 98340, 98342, 98344, 98345, 98346, 98348, 98349, 98351, 98352, 98353, 98354, 98355, 98356, 98358, 98359, 98360, 98361, 98364, 98365, 98366, 98367, 98370, 98371, 98372, 98373, 98374, 98375, 98376, 98377, 98378, 98380, 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, 98601, 98602, 98603, 98604, 98605, 98606, 98607, 98609, 98610, 98611, 98612, 98614, 98616, 98619, 98621, 98622, 98623, 98624, 98625, 98626, 98629, 98631, 98632, 98637, 98638, 98639, 98640, 98641, 98642, 98643, 98644, 98645, 98647, 98648, 98649, 98650, 98651, 98655, 98660, 98661, 98662, 98663, 98664, 98665, 98666, 98667, 98668, 98671, 98672, 98674, 98675, 98682, 98683, 98684, 98685, 98686, 98687, 98731, 98925, 98929, 98937)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
