| |
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 / 2 * 10) + user_session_time / 1227039340 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1020 and user_zip in (64810, 64831, 64842, 64843, 64847, 64850, 64853, 64854, 64856, 64858, 64861, 64863, 64864, 64865, 64867, 64868, 64874, 65647, 65730, 65745, 65772, 66713, 66778, 67332, 67336, 67337, 67339, 67342, 71932, 71937, 71945, 71953, 72613, 72631, 72632, 72701, 72702, 72703, 72704, 72711, 72712, 72714, 72715, 72716, 72717, 72718, 72719, 72721, 72722, 72727, 72728, 72729, 72730, 72732, 72733, 72734, 72735, 72736, 72737, 72738, 72739, 72740, 72741, 72742, 72744, 72745, 72747, 72749, 72751, 72752, 72753, 72756, 72757, 72758, 72760, 72761, 72762, 72764, 72765, 72766, 72768, 72769, 72770, 72773, 72774, 72776, 72820, 72821, 72826, 72830, 72832, 72838, 72840, 72841, 72842, 72852, 72854, 72855, 72863, 72865, 72901, 72902, 72903, 72904, 72905, 72906, 72908, 72913, 72914, 72916, 72917, 72918, 72919, 72921, 72923, 72924, 72926, 72927, 72928, 72930, 72932, 72933, 72934, 72935, 72936, 72937, 72938, 72940, 72941, 72943, 72944, 72945, 72946, 72947, 72948, 72949, 72950, 72951, 72952, 72955, 72956, 72957, 72958, 72959, 74001, 74002, 74003, 74004, 74005, 74006, 74008, 74009, 74010, 74011, 74012, 74013, 74014, 74015, 74016, 74017, 74018, 74020, 74021, 74022, 74023, 74026, 74027, 74028, 74029, 74030, 74031, 74033, 74034, 74035, 74036, 74037, 74038, 74039, 74041, 74042, 74043, 74044, 74045, 74046, 74047, 74048, 74050, 74051, 74052, 74053, 74054, 74055, 74056, 74060, 74061, 74062, 74063, 74066, 74067, 74068, 74070, 74071, 74072, 74073, 74079, 74080, 74081, 74082, 74083, 74084, 74085, 74101, 74102, 74103, 74104, 74105, 74106, 74107, 74108, 74110, 74112, 74114, 74115, 74116, 74117, 74119, 74120, 74121, 74126, 74127, 74128, 74129, 74130, 74131, 74132, 74133, 74134, 74135, 74136, 74137, 74141, 74145, 74146, 74147, 74148, 74149, 74150, 74152, 74153, 74155, 74156, 74157, 74158, 74159, 74169, 74170, 74171, 74172, 74177, 74182, 74183, 74184, 74186, 74187, 74189, 74192, 74193, 74194, 74301, 74328, 74330, 74331, 74332, 74333, 74334, 74335, 74336, 74337, 74338, 74339, 74340, 74342, 74343, 74344, 74345, 74346, 74347, 74349, 74350, 74352, 74353, 74354, 74355, 74358, 74359, 74360, 74361, 74362, 74363, 74364, 74365, 74366, 74367, 74368, 74369, 74370, 74399, 74401, 74402, 74403, 74421, 74422, 74423, 74425, 74426, 74427, 74428, 74429, 74430, 74431, 74432, 74434, 74435, 74436, 74437, 74438, 74440, 74441, 74442, 74444, 74445, 74446, 74447, 74450, 74451, 74452, 74454, 74455, 74456, 74457, 74458, 74459, 74460, 74461, 74462, 74463, 74464, 74465, 74466, 74467, 74468, 74469, 74470, 74471, 74472, 74477, 74501, 74502, 74521, 74522, 74528, 74529, 74531, 74534, 74536, 74538, 74540, 74542, 74543, 74545, 74546, 74547, 74549, 74552, 74553, 74554, 74557, 74558, 74559, 74560, 74561, 74562, 74563, 74565, 74567, 74569, 74570, 74571, 74574, 74576, 74577, 74578, 74722, 74724, 74818, 74824, 74825, 74827, 74829, 74830, 74833, 74834, 74837, 74839, 74840, 74844, 74845, 74848, 74849, 74850, 74853, 74854, 74855, 74859, 74860, 74864, 74867, 74868, 74869, 74880, 74883, 74884, 74901, 74902, 74930, 74931, 74932, 74935, 74936, 74937, 74939, 74940, 74941, 74942, 74943, 74944, 74945, 74946, 74947, 74948, 74949, 74951, 74953, 74954, 74955, 74956, 74957, 74959, 74960, 74962, 74963, 74964, 74965, 74966, 74968)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
