| |
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 / 1227051498 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1>1500 and user_zip in (37501, 38001, 38002, 38004, 38006, 38007, 38008, 38010, 38011, 38012, 38014, 38015, 38016, 38017, 38018, 38019, 38021, 38023, 38024, 38025, 38026, 38027, 38028, 38029, 38030, 38034, 38036, 38037, 38039, 38040, 38041, 38042, 38043, 38044, 38045, 38046, 38047, 38048, 38049, 38050, 38052, 38053, 38054, 38055, 38056, 38057, 38058, 38059, 38060, 38061, 38063, 38066, 38067, 38068, 38069, 38070, 38071, 38073, 38074, 38075, 38076, 38077, 38079, 38080, 38083, 38088, 38101, 38103, 38104, 38105, 38106, 38107, 38108, 38109, 38110, 38111, 38112, 38113, 38114, 38115, 38116, 38117, 38118, 38119, 38120, 38122, 38124, 38125, 38126, 38127, 38128, 38130, 38131, 38132, 38133, 38134, 38135, 38136, 38137, 38138, 38139, 38140, 38141, 38142, 38143, 38145, 38146, 38147, 38148, 38150, 38151, 38152, 38157, 38159, 38160, 38161, 38163, 38165, 38166, 38167, 38168, 38173, 38174, 38175, 38177, 38181, 38182, 38183, 38184, 38186, 38187, 38188, 38190, 38193, 38194, 38195, 38197, 38201, 38220, 38224, 38225, 38226, 38229, 38230, 38231, 38232, 38233, 38235, 38236, 38237, 38238, 38240, 38241, 38242, 38253, 38254, 38255, 38257, 38258, 38259, 38260, 38261, 38271, 38281, 38301, 38302, 38303, 38305, 38308, 38310, 38311, 38313, 38314, 38315, 38316, 38317, 38318, 38321, 38324, 38326, 38327, 38328, 38329, 38330, 38331, 38332, 38334, 38336, 38337, 38338, 38339, 38340, 38341, 38342, 38343, 38344, 38345, 38346, 38347, 38348, 38351, 38352, 38355, 38356, 38357, 38358, 38359, 38361, 38362, 38363, 38365, 38366, 38367, 38368, 38369, 38370, 38371, 38372, 38374, 38375, 38376, 38377, 38378, 38379, 38381, 38382, 38384, 38387, 38388, 38389, 38390, 38391, 38392, 38393, 38528, 38601, 38602, 38603, 38606, 38609, 38610, 38611, 38617, 38618, 38619, 38620, 38621, 38622, 38623, 38625, 38626, 38627, 38628, 38629, 38631, 38632, 38633, 38634, 38635, 38637, 38638, 38639, 38641, 38642, 38643, 38644, 38645, 38646, 38647, 38649, 38650, 38651, 38652, 38654, 38655, 38658, 38659, 38661, 38663, 38664, 38665, 38666, 38668, 38670, 38671, 38672, 38673, 38674, 38675, 38676, 38677, 38679, 38680, 38683, 38685, 38686, 38695, 38824, 38828, 38829, 38833, 38834, 38835, 38841, 38846, 38865, 38869, 38871, 38874, 38880, 38927, 38949, 38965, 42021, 42031, 42032, 42041, 42050, 42085, 42088, 63588, 63735, 63784, 63801, 63820, 63821, 63822, 63823, 63825, 63826, 63827, 63828, 63829, 63830, 63833, 63834, 63837, 63838, 63839, 63840, 63841, 63845, 63846, 63847, 63848, 63849, 63850, 63851, 63852, 63853, 63855, 63857, 63859, 63860, 63862, 63863, 63866, 63867, 63868, 63869, 63870, 63871, 63872, 63873, 63874, 63875, 63876, 63877, 63878, 63879, 63880, 63881, 63882, 63901, 63902, 63931, 63932, 63933, 63935, 63936, 63938, 63939, 63940, 63942, 63945, 63953, 63954, 63955, 63960, 63961, 63962, 63966, 72005, 72006, 72010, 72014, 72020, 72021, 72036, 72043, 72059, 72071, 72074, 72075, 72101, 72108, 72112, 72123, 72139, 72165, 72169, 72189, 72301, 72303, 72310, 72311, 72312, 72313, 72314, 72315, 72316, 72319, 72320, 72321, 72322, 72324, 72325, 72326, 72327, 72329, 72330, 72331, 72332, 72335, 72336, 72338, 72339, 72340, 72341, 72342, 72345, 72346, 72347, 72348, 72350, 72351, 72352, 72354, 72355, 72358, 72359, 72360, 72364, 72365, 72366, 72368, 72369, 72370, 72372, 72373, 72374, 72376, 72377, 72381, 72384, 72385, 72386, 72387, 72390, 72391, 72392, 72394, 72395, 72396, 72397, 72401, 72402, 72403, 72404, 72410, 72411, 72412, 72413, 72414, 72415, 72416, 72417, 72419, 72421, 72422, 72423, 72424, 72425, 72426, 72427, 72428, 72429, 72430, 72431, 72432, 72433, 72434, 72435, 72436, 72437, 72438, 72439, 72440, 72441, 72442, 72443, 72444, 72445, 72447, 72448, 72449, 72450, 72451, 72452, 72453, 72454, 72455, 72456, 72457, 72458, 72459, 72460, 72461, 72462, 72464, 72465, 72466, 72467, 72469, 72470, 72471, 72472, 72473, 72474, 72475, 72476, 72477, 72478, 72479, 72503, 72522, 72524, 72553, 72562, 72564, 72569, 72571, 72572, 72579)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
