| |
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 + user_session_time / 1227048498 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1>1500 and user_zip in (51001, 51003, 51008, 51011, 51017, 51023, 51027, 51036, 51041, 51057, 51062, 51201, 51230, 51232, 51234, 51235, 51237, 51238, 51239, 51240, 51241, 51242, 51243, 51244, 51246, 51247, 51249, 51250, 51330, 56110, 56113, 56114, 56115, 56116, 56117, 56122, 56123, 56125, 56128, 56129, 56130, 56131, 56132, 56134, 56136, 56138, 56139, 56140, 56141, 56142, 56144, 56146, 56147, 56149, 56151, 56153, 56155, 56156, 56157, 56158, 56164, 56165, 56168, 56169, 56170, 56172, 56173, 56175, 56177, 56178, 56185, 56186, 56187, 56220, 56239, 56257, 56258, 56264, 56280, 56286, 56291, 57001, 57002, 57003, 57004, 57005, 57006, 57007, 57010, 57012, 57013, 57014, 57015, 57016, 57017, 57018, 57020, 57021, 57022, 57024, 57025, 57026, 57027, 57028, 57029, 57030, 57031, 57032, 57033, 57034, 57035, 57036, 57037, 57039, 57040, 57041, 57042, 57043, 57044, 57045, 57046, 57047, 57048, 57050, 57051, 57052, 57053, 57054, 57055, 57056, 57057, 57058, 57059, 57061, 57062, 57063, 57064, 57065, 57066, 57067, 57068, 57069, 57070, 57071, 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, 57201, 57202, 57211, 57212, 57213, 57214, 57217, 57218, 57219, 57220, 57221, 57223, 57225, 57226, 57230, 57231, 57233, 57234, 57235, 57236, 57237, 57238, 57241, 57242, 57243, 57244, 57245, 57246, 57248, 57249, 57253, 57256, 57258, 57259, 57263, 57264, 57265, 57266, 57268, 57271, 57272, 57274, 57276, 57278, 57301, 57309, 57311, 57312, 57313, 57314, 57315, 57317, 57319, 57321, 57322, 57323, 57324, 57325, 57326, 57328, 57329, 57330, 57331, 57332, 57334, 57335, 57337, 57339, 57340, 57341, 57342, 57344, 57346, 57347, 57348, 57349, 57350, 57353, 57354, 57355, 57356, 57357, 57358, 57359, 57361, 57362, 57363, 57364, 57365, 57366, 57367, 57368, 57369, 57370, 57371, 57373, 57374, 57375, 57376, 57379, 57380, 57381, 57382, 57383, 57384, 57385, 57386, 57399, 57424, 57429, 57434, 57436, 57440, 57461, 57469, 57470, 57476, 57477, 57523, 57538, 57542, 57571, 57673, 57840, 68718, 68719, 68722, 68724, 68727, 68729, 68730, 68736, 68739, 68746, 68749, 68757, 68760, 68770, 68774, 68777, 68782, 68783, 68786, 68789, 68792)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
