| |
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 / 1227051739 * 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 (35581, 35582, 35585, 35601, 35602, 35603, 35609, 35610, 35611, 35612, 35613, 35614, 35615, 35616, 35617, 35618, 35619, 35620, 35630, 35631, 35632, 35633, 35634, 35640, 35643, 35645, 35646, 35647, 35648, 35649, 35650, 35651, 35652, 35653, 35654, 35659, 35660, 35661, 35662, 35670, 35671, 35672, 35673, 35674, 35677, 35699, 35739, 35741, 35742, 35745, 35748, 35749, 35750, 35751, 35754, 35756, 35757, 35758, 35759, 35761, 35762, 35763, 35764, 35766, 35767, 35773, 35774, 35775, 35801, 35802, 35803, 35804, 35805, 35806, 35807, 35808, 35809, 35810, 35811, 35812, 35813, 35814, 35815, 35816, 35824, 35893, 35894, 35895, 35896, 35897, 35898, 35899, 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, 37096, 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, 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, 37306, 37318, 37324, 37328, 37330, 37334, 37335, 37342, 37345, 37348, 37349, 37352, 37355, 37357, 37359, 37360, 37366, 37372, 37375, 37378, 37382, 37383, 37388, 37389, 37394, 37398, 37838, 38001, 38006, 38008, 38012, 38021, 38034, 38044, 38050, 38052, 38061, 38067, 38070, 38074, 38075, 38201, 38220, 38221, 38222, 38223, 38224, 38225, 38226, 38229, 38230, 38231, 38233, 38235, 38236, 38237, 38238, 38241, 38242, 38251, 38253, 38255, 38256, 38257, 38258, 38259, 38261, 38301, 38302, 38303, 38305, 38308, 38310, 38311, 38313, 38314, 38315, 38316, 38317, 38318, 38320, 38321, 38324, 38326, 38327, 38328, 38329, 38330, 38331, 38332, 38333, 38334, 38336, 38337, 38338, 38339, 38340, 38341, 38342, 38343, 38344, 38345, 38346, 38347, 38348, 38350, 38351, 38352, 38355, 38356, 38357, 38358, 38359, 38361, 38362, 38363, 38365, 38366, 38367, 38368, 38369, 38370, 38371, 38372, 38374, 38375, 38376, 38377, 38378, 38379, 38380, 38381, 38382, 38384, 38387, 38388, 38389, 38390, 38391, 38392, 38393, 38401, 38402, 38425, 38449, 38450, 38451, 38452, 38453, 38454, 38455, 38456, 38457, 38459, 38460, 38461, 38462, 38463, 38464, 38468, 38469, 38471, 38472, 38473, 38474, 38475, 38476, 38477, 38478, 38481, 38482, 38483, 38485, 38486, 38487, 38488, 38528, 38547, 38548, 38552, 38560, 38563, 38567, 38569, 38674, 38683, 38827, 38829, 38833, 38834, 38835, 38838, 38846, 38852, 38859, 38865, 38873, 42020, 42025, 42029, 42036, 42038, 42040, 42041, 42044, 42045, 42046, 42048, 42049, 42051, 42054, 42055, 42063, 42066, 42071, 42076, 42079, 42082, 42085, 42088, 42104, 42120, 42122, 42134, 42135, 42170, 42202, 42203, 42204, 42206, 42211, 42215, 42216, 42217, 42220, 42221, 42223, 42232, 42234, 42236, 42240, 42241, 42254, 42256, 42262, 42265, 42266, 42274, 42276, 42280, 42283, 42286, 42324, 42339, 42345, 42365, 42408, 42442, 42445, 42453, 42464)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
