| |
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 / 22 * 10) + user_session_time / 1227051219 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1100 and user_zip in (37010, 37011, 37013, 37014, 37015, 37022, 37023, 37024, 37025, 37027, 37028, 37029, 37031, 37032, 37033, 37034, 37035, 37036, 37040, 37041, 37042, 37043, 37044, 37046, 37048, 37049, 37050, 37051, 37052, 37055, 37056, 37058, 37060, 37061, 37062, 37063, 37064, 37065, 37066, 37067, 37068, 37069, 37070, 37071, 37072, 37073, 37074, 37075, 37076, 37077, 37078, 37079, 37080, 37082, 37085, 37086, 37087, 37088, 37089, 37090, 37096, 37097, 37098, 37101, 37115, 37116, 37119, 37121, 37122, 37128, 37129, 37130, 37131, 37132, 37133, 37134, 37135, 37136, 37137, 37138, 37140, 37141, 37142, 37143, 37146, 37147, 37148, 37152, 37153, 37155, 37165, 37167, 37171, 37172, 37174, 37175, 37178, 37179, 37181, 37185, 37186, 37187, 37188, 37189, 37191, 37201, 37202, 37203, 37204, 37205, 37206, 37207, 37208, 37209, 37210, 37211, 37212, 37213, 37214, 37215, 37216, 37217, 37218, 37219, 37220, 37221, 37222, 37224, 37227, 37228, 37229, 37230, 37232, 37234, 37235, 37236, 37237, 37238, 37239, 37240, 37241, 37242, 37243, 37244, 37245, 37246, 37247, 37248, 37249, 37250, 38001, 38006, 38007, 38021, 38024, 38025, 38034, 38050, 38056, 38059, 38070, 38077, 38079, 38080, 38201, 38220, 38221, 38222, 38223, 38224, 38225, 38226, 38229, 38230, 38231, 38232, 38233, 38235, 38236, 38237, 38238, 38240, 38241, 38242, 38251, 38253, 38254, 38255, 38256, 38257, 38258, 38259, 38260, 38261, 38271, 38281, 38301, 38302, 38303, 38305, 38308, 38311, 38313, 38314, 38316, 38317, 38318, 38320, 38321, 38324, 38328, 38329, 38330, 38331, 38332, 38333, 38334, 38336, 38337, 38338, 38340, 38341, 38342, 38343, 38344, 38345, 38346, 38347, 38348, 38351, 38352, 38355, 38358, 38359, 38361, 38362, 38363, 38366, 38368, 38369, 38370, 38371, 38374, 38378, 38380, 38382, 38384, 38387, 38388, 38389, 38390, 38391, 38401, 38402, 38425, 38451, 38454, 38456, 38461, 38462, 38464, 38472, 38474, 38475, 38476, 38482, 38483, 38485, 38487, 38528, 40119, 42001, 42002, 42003, 42011, 42020, 42021, 42022, 42023, 42024, 42025, 42027, 42028, 42029, 42031, 42032, 42033, 42035, 42036, 42037, 42038, 42039, 42040, 42041, 42044, 42045, 42046, 42047, 42048, 42049, 42050, 42051, 42053, 42054, 42055, 42056, 42058, 42060, 42061, 42063, 42064, 42066, 42069, 42070, 42071, 42076, 42078, 42079, 42081, 42082, 42083, 42084, 42085, 42086, 42087, 42088, 42101, 42102, 42103, 42104, 42109, 42120, 42122, 42128, 42134, 42135, 42150, 42159, 42164, 42170, 42171, 42201, 42202, 42203, 42204, 42206, 42207, 42209, 42210, 42211, 42215, 42216, 42217, 42219, 42220, 42221, 42223, 42232, 42234, 42235, 42236, 42240, 42241, 42251, 42252, 42254, 42256, 42257, 42261, 42262, 42265, 42266, 42267, 42270, 42273, 42274, 42275, 42276, 42280, 42283, 42285, 42286, 42287, 42288, 42301, 42302, 42303, 42304, 42320, 42321, 42322, 42323, 42324, 42325, 42326, 42327, 42328, 42330, 42332, 42333, 42334, 42337, 42338, 42339, 42343, 42344, 42345, 42347, 42349, 42350, 42352, 42354, 42355, 42356, 42361, 42365, 42366, 42367, 42368, 42369, 42370, 42371, 42372, 42374, 42375, 42376, 42377, 42378, 42400, 42402, 42403, 42404, 42406, 42408, 42409, 42410, 42411, 42413, 42419, 42420, 42431, 42436, 42437, 42440, 42441, 42442, 42444, 42445, 42450, 42451, 42452, 42453, 42455, 42456, 42457, 42458, 42459, 42460, 42461, 42462, 42463, 42464, 42721, 42762, 47412, 47617, 47618, 47620, 47630, 47634, 47635, 47701, 47702, 47703, 47704, 47705, 47706, 47708, 47710, 47711, 47712, 47713, 47714, 47715, 47716, 47719, 47720, 47721, 47722, 47724, 47727, 47728, 47730, 47731, 47732, 47733, 47734, 47735, 47736, 47737, 47739, 47740, 47741, 47744, 47747, 47750, 62394, 62792, 62817, 62834, 62861, 62867, 62869, 62871, 62906, 62908, 62909, 62910, 62912, 62913, 62914, 62917, 62919, 62920, 62922, 62923, 62926, 62928, 62930, 62931, 62934, 62935, 62938, 62939, 62941, 62943, 62944, 62946, 62947, 62952, 62953, 62954, 62955, 62956, 62957, 62958, 62959, 62960, 62961, 62962, 62963, 62964, 62965, 62967, 62969, 62970, 62972, 62973, 62974, 62976, 62977, 62979, 62982, 62984, 62985, 62987, 62988, 62990, 62991, 62992, 62993, 62995, 62996, 63736, 63742, 63801, 63804, 63820, 63823, 63824, 63832, 63834, 63838, 63845, 63860, 63862, 63866, 63867, 63869, 63881, 63882)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
