| |
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 / 1 * 10) + user_session_time / 1227048309 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1120 and user_zip in (50510, 50535, 50565, 50567, 50568, 50576, 50583, 50585, 50588, 50592, 50593, 51001, 51002, 51003, 51004, 51005, 51006, 51007, 51008, 51009, 51010, 51011, 51012, 51014, 51015, 51016, 51017, 51018, 51019, 51020, 51022, 51023, 51024, 51025, 51026, 51027, 51028, 51029, 51030, 51031, 51033, 51034, 51035, 51036, 51037, 51038, 51039, 51040, 51041, 51044, 51045, 51046, 51047, 51048, 51049, 51050, 51051, 51052, 51053, 51054, 51055, 51056, 51057, 51058, 51059, 51060, 51061, 51062, 51063, 51101, 51102, 51103, 51104, 51105, 51106, 51107, 51108, 51109, 51111, 51201, 51230, 51231, 51232, 51234, 51235, 51237, 51238, 51239, 51240, 51241, 51242, 51243, 51244, 51245, 51246, 51247, 51248, 51249, 51250, 51301, 51330, 51331, 51333, 51338, 51340, 51341, 51343, 51345, 51346, 51347, 51349, 51350, 51351, 51354, 51355, 51357, 51358, 51360, 51364, 51366, 51431, 51439, 51441, 51442, 51445, 51448, 51450, 51458, 51460, 51461, 51465, 51466, 51520, 51523, 51528, 51529, 51545, 51546, 51547, 51550, 51555, 51556, 51557, 51558, 51564, 51572, 51579, 56110, 56116, 56117, 56119, 56122, 56126, 56128, 56129, 56131, 56134, 56138, 56139, 56140, 56141, 56144, 56146, 56147, 56151, 56153, 56155, 56156, 56158, 56161, 56164, 56165, 56167, 56168, 56172, 56173, 56177, 56185, 56186, 56187, 57001, 57003, 57004, 57005, 57010, 57012, 57013, 57014, 57015, 57016, 57017, 57018, 57020, 57021, 57022, 57024, 57025, 57027, 57028, 57029, 57030, 57031, 57032, 57033, 57034, 57035, 57036, 57037, 57038, 57039, 57040, 57041, 57042, 57043, 57044, 57045, 57046, 57047, 57048, 57049, 57050, 57052, 57053, 57054, 57055, 57056, 57057, 57058, 57059, 57061, 57062, 57063, 57064, 57065, 57066, 57067, 57068, 57069, 57070, 57072, 57073, 57074, 57075, 57076, 57077, 57078, 57079, 57101, 57103, 57104, 57105, 57106, 57107, 57108, 57109, 57110, 57115, 57117, 57118, 57188, 57189, 57192, 57193, 57194, 57195, 57196, 57197, 57198, 57301, 57309, 57311, 57313, 57315, 57319, 57321, 57328, 57329, 57330, 57331, 57332, 57334, 57335, 57337, 57340, 57347, 57349, 57354, 57356, 57357, 57361, 57363, 57366, 57367, 57374, 57375, 57376, 57380, 57949, 68002, 68004, 68008, 68009, 68015, 68019, 68020, 68025, 68026, 68029, 68030, 68031, 68034, 68036, 68038, 68039, 68044, 68045, 68047, 68055, 68057, 68061, 68062, 68063, 68067, 68071, 68072, 68601, 68602, 68620, 68621, 68629, 68631, 68633, 68636, 68641, 68642, 68643, 68644, 68647, 68648, 68649, 68652, 68653, 68659, 68661, 68664, 68701, 68702, 68710, 68715, 68716, 68717, 68718, 68719, 68720, 68723, 68724, 68726, 68727, 68728, 68729, 68730, 68731, 68732, 68733, 68735, 68736, 68737, 68738, 68739, 68740, 68741, 68742, 68743, 68745, 68746, 68747, 68748, 68749, 68751, 68752, 68756, 68757, 68758, 68760, 68761, 68763, 68764, 68765, 68766, 68767, 68768, 68769, 68770, 68771, 68773, 68774, 68776, 68777, 68779, 68781, 68782, 68783, 68784, 68785, 68786, 68787, 68788, 68789, 68790, 68791, 68792)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
