| |
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 / 142 * 10) + user_session_time / 1227058296 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (46301, 46302, 46303, 46304, 46305, 46307, 46308, 46310, 46311, 46312, 46319, 46320, 46321, 46322, 46323, 46324, 46325, 46327, 46340, 46341, 46342, 46345, 46346, 46347, 46348, 46350, 46352, 46355, 46356, 46360, 46361, 46365, 46368, 46371, 46373, 46375, 46376, 46377, 46379, 46381, 46382, 46383, 46384, 46385, 46386, 46390, 46391, 46393, 46394, 46401, 46402, 46403, 46404, 46405, 46406, 46407, 46408, 46409, 46410, 46411, 46530, 46532, 46535, 46544, 46545, 46546, 46552, 46554, 46556, 46574, 46601, 46604, 46612, 46613, 46614, 46615, 46616, 46617, 46619, 46620, 46624, 46626, 46628, 46629, 46634, 46635, 46637, 46660, 46680, 46699, 49010, 49013, 49022, 49023, 49026, 49027, 49031, 49038, 49039, 49043, 49045, 49047, 49055, 49056, 49057, 49062, 49063, 49064, 49065, 49071, 49078, 49079, 49084, 49085, 49090, 49098, 49101, 49102, 49103, 49104, 49106, 49107, 49111, 49112, 49113, 49115, 49116, 49117, 49119, 49120, 49121, 49125, 49126, 49127, 49128, 49129, 49226, 49314, 49315, 49323, 49328, 49401, 49403, 49404, 49406, 49408, 49409, 49415, 49416, 49417, 49418, 49419, 49422, 49423, 49424, 49425, 49426, 49427, 49428, 49429, 49430, 49434, 49435, 49436, 49437, 49440, 49441, 49442, 49443, 49444, 49445, 49446, 49448, 49450, 49451, 49452, 49453, 49455, 49456, 49457, 49460, 49461, 49463, 49464, 53001, 53002, 53003, 53004, 53005, 53006, 53007, 53008, 53009, 53010, 53011, 53012, 53013, 53015, 53016, 53017, 53018, 53019, 53020, 53021, 53022, 53023, 53024, 53026, 53027, 53029, 53031, 53032, 53033, 53034, 53035, 53036, 53037, 53038, 53039, 53040, 53042, 53044, 53045, 53046, 53047, 53048, 53049, 53050, 53051, 53052, 53056, 53057, 53058, 53059, 53060, 53061, 53063, 53064, 53065, 53066, 53069, 53070, 53072, 53073, 53074, 53075, 53076, 53078, 53079, 53080, 53081, 53082, 53083, 53085, 53086, 53089, 53090, 53091, 53092, 53093, 53094, 53095, 53097, 53098, 53099, 53101, 53102, 53103, 53104, 53105, 53108, 53109, 53110, 53114, 53115, 53118, 53119, 53120, 53121, 53122, 53125, 53126, 53127, 53128, 53129, 53130, 53132, 53134, 53137, 53138, 53139, 53140, 53141, 53142, 53143, 53144, 53146, 53147, 53148, 53149, 53150, 53151, 53152, 53153, 53154, 53156, 53157, 53158, 53159, 53167, 53168, 53170, 53171, 53172, 53176, 53177, 53178, 53179, 53181, 53182, 53183, 53184, 53185, 53186, 53187, 53188, 53189, 53190, 53191, 53192, 53194, 53195, 53197, 53201, 53202, 53203, 53204, 53205, 53206, 53207, 53208, 53209, 53210, 53211, 53212, 53213, 53214, 53215, 53216, 53217, 53218, 53219, 53220, 53221, 53222, 53223, 53224, 53225, 53226, 53227, 53228, 53233, 53234, 53235, 53237, 53259, 53263, 53267, 53268, 53270, 53274, 53277, 53278, 53280, 53281, 53284, 53285, 53288, 53290, 53293, 53295, 53401, 53402, 53403, 53404, 53405, 53406, 53407, 53408, 53449, 53490, 53501, 53502, 53505, 53508, 53511, 53512, 53520, 53521, 53523, 53525, 53527, 53531, 53532, 53534, 53536, 53537, 53538, 53542, 53545, 53546, 53547, 53549, 53550, 53551, 53557, 53558, 53559, 53563, 53570, 53571, 53575, 53576, 53579, 53585, 53589, 53590, 53591, 53594, 53596, 53598, 53648, 53701, 53702, 53703, 53704, 53705, 53706, 53707, 53708, 53709, 53710, 53711, 53713, 53714, 53715, 53716, 53718, 53719, 53725, 53726, 53744, 53777, 53778, 53779, 53780, 53782, 53783, 53784, 53785, 53786, 53787, 53788, 53789, 53790, 53791, 53792, 53793, 53794, 53916, 53917, 53919, 53922, 53925, 53928, 53932, 53933, 53935, 53956, 53957, 53960, 53963, 54035, 54232, 54932, 54935, 54936, 54937, 54974, 54979, 60001, 60002, 60004, 60005, 60006, 60007, 60008, 60009, 60010, 60011, 60012, 60013, 60014, 60015, 60016, 60017, 60018, 60019, 60020, 60021, 60022, 60025, 60026, 60029, 60030, 60031, 60033, 60034, 60035, 60037, 60038, 60039, 60040, 60041, 60042, 60043, 60044, 60045, 60046, 60047, 60048, 60049, 60050, 60051, 60053, 60054, 60055, 60056, 60060, 60061, 60062, 60064, 60065, 60067, 60068, 60069, 60070, 60071, 60072, 60073, 60074, 60075, 60076, 60077, 60078, 60079, 60080, 60081, 60082, 60083, 60084, 60085, 60086, 60087, 60088, 60089, 60090, 60091, 60092, 60093, 60094, 60095, 60096, 60097, 60098, 60099, 60101, 60102, 60103, 60104, 60105, 60106, 60107, 60108, 60109, 60110, 60111, 60112, 60113, 60114, 60115, 60116, 60117, 60118, 60119, 60120, 60121, 60122, 60123, 60125, 60126, 60127, 60128, 60129, 60130, 60131, 60132, 60133, 60134, 60135, 60136, 60137, 60138, 60139, 60140, 60141, 60142, 60143, 60144, 60145, 60146, 60147, 60148, 60149, 60150, 60151, 60152, 60153, 60154, 60155, 60156, 60157, 60159, 60160, 60161, 60162, 60163, 60164, 60165, 60168, 60170, 60171, 60172, 60173, 60174, 60175, 60176, 60177, 60178, 60179, 60180, 60181, 60182, 60183, 60184, 60185, 60186, 60187, 60188, 60189, 60190, 60191, 60192, 60193, 60194, 60195, 60196, 60197, 60198, 60199, 60201, 60202, 60203, 60204, 60208, 60209, 60301, 60302, 60303, 60304, 60305, 60330, 60401, 60402, 60406, 60407, 60408, 60409, 60410, 60411, 60412, 60415, 60416, 60417, 60419, 60421, 60422, 60423, 60425, 60426, 60429, 60430, 60431, 60432, 60433, 60434, 60435, 60436, 60438, 60439, 60440, 60441, 60442, 60443, 60444, 60445, 60446, 60447, 60448, 60449, 60450, 60451, 60452, 60453, 60454, 60455, 60456, 60457, 60458, 60459, 60461, 60462, 60463, 60464, 60465, 60466, 60467, 60468, 60469, 60471, 60472, 60473, 60475, 60476, 60477, 60478, 60480, 60481, 60482, 60490, 60499, 60501, 60504, 60505, 60506, 60507, 60510, 60511, 60512, 60513, 60514, 60515, 60516, 60517, 60518, 60519, 60520, 60521, 60522, 60523, 60525, 60526, 60527, 60530, 60531, 60532, 60534, 60536, 60537, 60538, 60539, 60540, 60541, 60542, 60543, 60544, 60545, 60546, 60548, 60549, 60550, 60551, 60552, 60553, 60554, 60555, 60556, 60557, 60558, 60559, 60560, 60561, 60563, 60564, 60565, 60566, 60567, 60568, 60570, 60572, 60597, 60598, 60599, 60601, 60602, 60603, 60604, 60605, 60606, 60607, 60608, 60609, 60610, 60611, 60612, 60613, 60614, 60615, 60616, 60617, 60618, 60619, 60620, 60621, 60622, 60623, 60624, 60625, 60626, 60628, 60629, 60630, 60631, 60632, 60633, 60634, 60636, 60637, 60638, 60639, 60640, 60641, 60643, 60644, 60645, 60646, 60647, 60648, 60649, 60650, 60651, 60652, 60653, 60654, 60655, 60656, 60657, 60659, 60660, 60661, 60663, 60664, 60665, 60666, 60667, 60668, 60669, 60670, 60671, 60672, 60673, 60674, 60675, 60677, 60678, 60679, 60680, 60681, 60683, 60684, 60685, 60687, 60690, 60691, 60692, 60693, 60694, 60697, 60699, 60701, 60706, 60707, 60712, 60714, 60803, 60804, 60805, 60827, 60902, 60914, 60915, 60940, 60944, 60950, 60954, 61006, 61008, 61010, 61011, 61012, 61015, 61016, 61018, 61019, 61020, 61024, 61031, 61038, 61039, 61043, 61047, 61049, 61052, 61054, 61061, 61063, 61065, 61067, 61068, 61070, 61072, 61073, 61077, 61079, 61080, 61084, 61088, 61101, 61102, 61103, 61104, 61105, 61106, 61107, 61108, 61109, 61110, 61111, 61112, 61114, 61115, 61125, 61126, 61130, 61131, 61132, 61318, 61353, 61360, 61378)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
