| |
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 / 4 * 10) + user_session_time / 1227058406 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (53009, 53014, 53049, 53062, 53065, 53088, 53555, 53561, 53577, 53578, 53581, 53583, 53584, 53698, 53901, 53910, 53911, 53913, 53919, 53920, 53923, 53924, 53926, 53927, 53928, 53929, 53930, 53931, 53932, 53933, 53934, 53935, 53936, 53937, 53939, 53940, 53941, 53942, 53943, 53944, 53946, 53947, 53948, 53949, 53950, 53951, 53952, 53953, 53954, 53955, 53956, 53957, 53958, 53959, 53960, 53961, 53962, 53963, 53964, 53965, 53968, 53969, 53981, 53995, 54034, 54035, 54052, 54061, 54101, 54106, 54107, 54111, 54112, 54113, 54114, 54115, 54123, 54124, 54126, 54127, 54128, 54129, 54130, 54131, 54135, 54136, 54137, 54138, 54139, 54140, 54141, 54149, 54150, 54152, 54154, 54155, 54161, 54162, 54165, 54166, 54169, 54170, 54171, 54173, 54174, 54175, 54180, 54182, 54242, 54301, 54302, 54303, 54304, 54305, 54306, 54307, 54313, 54324, 54344, 54401, 54402, 54403, 54404, 54405, 54406, 54407, 54408, 54409, 54410, 54411, 54412, 54413, 54414, 54415, 54416, 54417, 54418, 54419, 54420, 54421, 54422, 54423, 54424, 54425, 54426, 54427, 54428, 54429, 54430, 54431, 54432, 54433, 54434, 54435, 54436, 54437, 54439, 54440, 54441, 54442, 54443, 54444, 54446, 54447, 54448, 54449, 54450, 54451, 54452, 54454, 54455, 54456, 54457, 54458, 54459, 54460, 54462, 54463, 54464, 54465, 54466, 54467, 54469, 54470, 54471, 54472, 54473, 54474, 54475, 54476, 54479, 54480, 54481, 54484, 54485, 54486, 54487, 54488, 54489, 54490, 54491, 54492, 54493, 54494, 54495, 54498, 54499, 54501, 54511, 54512, 54513, 54514, 54515, 54520, 54521, 54524, 54526, 54529, 54530, 54531, 54532, 54537, 54538, 54539, 54541, 54543, 54548, 54552, 54555, 54556, 54558, 54560, 54562, 54563, 54564, 54566, 54568, 54601, 54602, 54603, 54610, 54611, 54612, 54613, 54614, 54615, 54616, 54618, 54619, 54620, 54621, 54622, 54623, 54625, 54627, 54629, 54630, 54632, 54634, 54635, 54636, 54637, 54638, 54639, 54641, 54642, 54643, 54644, 54646, 54648, 54649, 54650, 54651, 54652, 54653, 54655, 54656, 54658, 54659, 54660, 54661, 54662, 54664, 54665, 54666, 54667, 54669, 54670, 54699, 54701, 54702, 54703, 54720, 54722, 54724, 54726, 54727, 54728, 54729, 54730, 54731, 54732, 54735, 54736, 54737, 54738, 54739, 54741, 54742, 54743, 54745, 54746, 54747, 54748, 54751, 54754, 54755, 54756, 54757, 54758, 54760, 54763, 54764, 54765, 54766, 54768, 54770, 54771, 54772, 54773, 54774, 54819, 54822, 54835, 54848, 54862, 54867, 54886, 54895, 54896, 54901, 54902, 54903, 54904, 54906, 54909, 54911, 54912, 54913, 54914, 54915, 54919, 54921, 54922, 54923, 54926, 54927, 54928, 54929, 54930, 54931, 54932, 54933, 54934, 54935, 54936, 54937, 54940, 54941, 54942, 54943, 54944, 54945, 54946, 54947, 54948, 54949, 54950, 54951, 54952, 54956, 54957, 54960, 54961, 54962, 54963, 54964, 54965, 54966, 54967, 54968, 54969, 54970, 54971, 54974, 54975, 54976, 54977, 54978, 54979, 54980, 54981, 54982, 54983, 54984, 54985, 54986, 54990, 55919, 55925, 55941, 55942, 55943, 55947, 55959, 55969, 55987, 55988)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
