| |
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 / 1227051024 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (37010, 37011, 37012, 37013, 37014, 37015, 37016, 37018, 37019, 37020, 37022, 37023, 37024, 37025, 37026, 37027, 37028, 37029, 37030, 37031, 37032, 37033, 37034, 37035, 37036, 37037, 37040, 37041, 37042, 37043, 37044, 37046, 37047, 37048, 37049, 37050, 37051, 37052, 37055, 37056, 37057, 37058, 37059, 37060, 37061, 37062, 37063, 37064, 37065, 37066, 37067, 37068, 37069, 37070, 37071, 37072, 37073, 37074, 37075, 37076, 37077, 37078, 37079, 37080, 37082, 37083, 37085, 37086, 37087, 37088, 37089, 37090, 37091, 37095, 37097, 37098, 37101, 37110, 37111, 37115, 37116, 37118, 37119, 37121, 37122, 37127, 37128, 37129, 37130, 37131, 37132, 37133, 37134, 37135, 37136, 37137, 37138, 37140, 37141, 37142, 37143, 37144, 37145, 37146, 37147, 37148, 37149, 37150, 37151, 37152, 37153, 37155, 37160, 37161, 37162, 37165, 37166, 37167, 37171, 37172, 37174, 37175, 37178, 37179, 37180, 37181, 37183, 37184, 37185, 37186, 37187, 37188, 37189, 37190, 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, 37301, 37305, 37306, 37313, 37318, 37321, 37324, 37327, 37330, 37332, 37334, 37335, 37337, 37338, 37339, 37342, 37348, 37349, 37352, 37355, 37356, 37357, 37359, 37360, 37365, 37366, 37367, 37372, 37374, 37375, 37378, 37381, 37382, 37383, 37387, 37388, 37389, 37394, 37395, 37398, 37723, 37726, 37732, 37733, 37755, 37770, 37838, 37841, 37842, 37852, 37854, 37872, 37893, 38221, 38333, 38401, 38402, 38451, 38453, 38454, 38456, 38459, 38461, 38462, 38472, 38474, 38476, 38478, 38482, 38483, 38487, 38501, 38502, 38503, 38504, 38505, 38506, 38541, 38542, 38543, 38544, 38545, 38547, 38548, 38549, 38550, 38551, 38552, 38553, 38554, 38555, 38556, 38557, 38558, 38559, 38560, 38562, 38563, 38564, 38565, 38567, 38568, 38569, 38570, 38571, 38572, 38573, 38574, 38575, 38577, 38578, 38579, 38580, 38581, 38582, 38583, 38585, 38587, 38588, 38589, 40009, 40033, 40037, 40048, 40049, 40051, 40052, 40053, 40060, 40062, 40063, 40106, 40107, 40111, 40115, 40117, 40119, 40121, 40140, 40142, 40143, 40144, 40145, 40146, 40150, 40152, 40153, 40159, 40160, 40162, 40164, 40175, 40176, 40178, 42046, 42076, 42101, 42102, 42103, 42104, 42109, 42120, 42122, 42123, 42124, 42127, 42128, 42129, 42130, 42131, 42133, 42134, 42135, 42140, 42141, 42142, 42150, 42151, 42152, 42153, 42154, 42156, 42157, 42159, 42160, 42163, 42164, 42166, 42167, 42170, 42171, 42201, 42202, 42203, 42204, 42206, 42207, 42209, 42210, 42211, 42214, 42215, 42216, 42217, 42219, 42220, 42221, 42223, 42232, 42234, 42235, 42236, 42240, 42241, 42251, 42252, 42254, 42256, 42257, 42259, 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, 42348, 42349, 42350, 42352, 42354, 42361, 42364, 42365, 42366, 42367, 42368, 42369, 42370, 42371, 42372, 42374, 42375, 42376, 42377, 42378, 42408, 42410, 42413, 42431, 42436, 42440, 42441, 42442, 42445, 42453, 42456, 42464, 42516, 42518, 42528, 42539, 42544, 42565, 42602, 42603, 42629, 42632, 42633, 42637, 42642, 42647, 42701, 42702, 42711, 42712, 42713, 42715, 42716, 42717, 42718, 42719, 42720, 42721, 42722, 42724, 42726, 42728, 42729, 42731, 42732, 42733, 42735, 42740, 42741, 42742, 42743, 42746, 42748, 42749, 42753, 42754, 42755, 42757, 42758, 42759, 42761, 42762, 42764, 42765, 42776, 42782, 42783, 42784, 42786, 42788)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
