| |
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 / 3 * 10) + user_session_time / 1227057829 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (49802, 49812, 49813, 49821, 49847, 49848, 49852, 49858, 49863, 49870, 49876, 49887, 49892, 49893, 53001, 53002, 53003, 53004, 53005, 53006, 53007, 53008, 53009, 53010, 53011, 53012, 53013, 53014, 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, 53062, 53063, 53064, 53065, 53066, 53069, 53070, 53072, 53073, 53074, 53075, 53076, 53078, 53079, 53080, 53081, 53082, 53083, 53085, 53086, 53088, 53089, 53090, 53091, 53092, 53093, 53094, 53095, 53097, 53098, 53099, 53118, 53122, 53137, 53178, 53183, 53186, 53187, 53188, 53202, 53203, 53205, 53206, 53208, 53209, 53210, 53211, 53212, 53213, 53214, 53216, 53217, 53218, 53222, 53223, 53224, 53225, 53226, 53233, 53245, 53259, 53263, 53267, 53268, 53270, 53277, 53278, 53280, 53281, 53288, 53290, 53293, 53449, 53527, 53529, 53531, 53532, 53549, 53551, 53555, 53557, 53559, 53561, 53571, 53578, 53579, 53590, 53594, 53596, 53597, 53598, 53704, 53718, 53783, 53901, 53910, 53911, 53913, 53916, 53917, 53919, 53920, 53922, 53923, 53925, 53926, 53927, 53928, 53930, 53931, 53932, 53933, 53934, 53935, 53936, 53939, 53940, 53944, 53946, 53947, 53948, 53949, 53950, 53951, 53952, 53953, 53954, 53955, 53956, 53957, 53959, 53960, 53961, 53963, 53964, 53965, 53969, 53995, 54035, 54061, 54101, 54102, 54103, 54104, 54106, 54107, 54110, 54111, 54112, 54113, 54114, 54115, 54119, 54120, 54123, 54124, 54125, 54126, 54127, 54128, 54129, 54130, 54131, 54135, 54136, 54137, 54138, 54139, 54140, 54141, 54143, 54149, 54150, 54151, 54152, 54153, 54154, 54155, 54156, 54157, 54159, 54160, 54161, 54162, 54165, 54166, 54169, 54170, 54171, 54173, 54174, 54175, 54177, 54180, 54182, 54201, 54202, 54203, 54204, 54205, 54206, 54207, 54208, 54209, 54210, 54211, 54212, 54213, 54214, 54215, 54216, 54217, 54220, 54221, 54226, 54227, 54228, 54229, 54230, 54232, 54234, 54235, 54240, 54241, 54245, 54247, 54301, 54302, 54303, 54304, 54305, 54306, 54307, 54308, 54310, 54311, 54313, 54324, 54344, 54401, 54402, 54403, 54404, 54405, 54406, 54407, 54408, 54409, 54410, 54411, 54412, 54413, 54414, 54415, 54416, 54417, 54418, 54420, 54421, 54423, 54424, 54426, 54427, 54428, 54429, 54430, 54432, 54435, 54436, 54440, 54441, 54442, 54443, 54444, 54448, 54449, 54450, 54452, 54454, 54455, 54457, 54458, 54462, 54463, 54464, 54465, 54466, 54467, 54469, 54471, 54472, 54473, 54474, 54475, 54476, 54479, 54481, 54484, 54485, 54486, 54487, 54488, 54489, 54491, 54492, 54494, 54495, 54499, 54501, 54511, 54520, 54532, 54541, 54566, 54613, 54618, 54637, 54641, 54646, 54649, 54666, 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)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
