| |
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 / 1227039916 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (73002, 73003, 73004, 73007, 73008, 73010, 73011, 73012, 73013, 73018, 73019, 73020, 73023, 73026, 73027, 73030, 73031, 73032, 73034, 73044, 73045, 73049, 73050, 73051, 73052, 73054, 73055, 73057, 73058, 73064, 73065, 73066, 73067, 73068, 73069, 73070, 73071, 73072, 73074, 73075, 73078, 73080, 73082, 73083, 73084, 73085, 73086, 73089, 73093, 73095, 73097, 73098, 73099, 73101, 73102, 73103, 73104, 73105, 73106, 73107, 73108, 73109, 73110, 73111, 73112, 73113, 73114, 73115, 73116, 73117, 73118, 73119, 73120, 73121, 73122, 73123, 73124, 73125, 73126, 73127, 73128, 73129, 73130, 73131, 73132, 73134, 73135, 73136, 73137, 73139, 73140, 73141, 73142, 73143, 73144, 73145, 73146, 73147, 73148, 73149, 73150, 73151, 73152, 73153, 73154, 73155, 73156, 73157, 73159, 73160, 73162, 73163, 73164, 73165, 73167, 73169, 73170, 73172, 73173, 73177, 73178, 73179, 73180, 73184, 73185, 73189, 73190, 73193, 73194, 73196, 73197, 73198, 73199, 73401, 73402, 73403, 73425, 73430, 73432, 73433, 73434, 73435, 73436, 73437, 73438, 73439, 73440, 73441, 73442, 73443, 73444, 73445, 73446, 73447, 73448, 73449, 73450, 73453, 73455, 73456, 73458, 73459, 73460, 73461, 73463, 73476, 73481, 73487, 73488, 73491, 73536, 73575, 74008, 74010, 74011, 74012, 74013, 74014, 74015, 74020, 74023, 74026, 74028, 74030, 74032, 74033, 74034, 74036, 74037, 74038, 74039, 74041, 74043, 74044, 74045, 74046, 74047, 74050, 74052, 74054, 74055, 74059, 74060, 74062, 74063, 74066, 74067, 74068, 74071, 74073, 74074, 74075, 74076, 74077, 74078, 74079, 74081, 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, 74337, 74401, 74402, 74403, 74421, 74422, 74423, 74425, 74426, 74427, 74428, 74429, 74430, 74431, 74432, 74434, 74435, 74436, 74437, 74438, 74440, 74441, 74442, 74445, 74446, 74447, 74450, 74451, 74454, 74455, 74456, 74458, 74459, 74460, 74461, 74462, 74463, 74464, 74465, 74466, 74467, 74468, 74469, 74470, 74471, 74472, 74477, 74501, 74502, 74520, 74521, 74522, 74523, 74525, 74528, 74529, 74530, 74531, 74533, 74534, 74535, 74536, 74538, 74540, 74542, 74543, 74545, 74546, 74547, 74549, 74552, 74553, 74554, 74555, 74556, 74557, 74558, 74559, 74560, 74561, 74562, 74563, 74565, 74567, 74569, 74570, 74571, 74572, 74574, 74576, 74577, 74578, 74701, 74702, 74720, 74721, 74722, 74723, 74724, 74726, 74727, 74728, 74729, 74730, 74731, 74733, 74735, 74737, 74738, 74741, 74743, 74747, 74748, 74750, 74753, 74754, 74755, 74756, 74759, 74760, 74761, 74764, 74766, 74801, 74802, 74804, 74807, 74818, 74820, 74821, 74824, 74825, 74826, 74827, 74829, 74830, 74831, 74832, 74833, 74834, 74836, 74837, 74839, 74840, 74842, 74843, 74844, 74845, 74848, 74849, 74850, 74851, 74852, 74853, 74854, 74855, 74856, 74857, 74859, 74860, 74864, 74865, 74866, 74867, 74868, 74869, 74871, 74872, 74873, 74875, 74878, 74880, 74881, 74883, 74884, 74894, 74930, 74931, 74932, 74935, 74936, 74937, 74939, 74940, 74941, 74942, 74943, 74944, 74945, 74947, 74949, 74951, 74953, 74955, 74956, 74957, 74959, 74962, 74966, 74968, 75020, 75021, 75076, 75090, 75091, 75092, 75411, 75412, 75414, 75416, 75418, 75421, 75425, 75438, 75439, 75446, 75447, 75460, 75461, 75462, 75470, 75473, 75476, 75479, 75486, 75488, 75489, 75491, 75492, 75499, 76245, 76264, 76268, 76273)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
