| |
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 / 1227008239 * 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 (80000, 80001, 80002, 80003, 80004, 80005, 80006, 80007, 80010, 80011, 80012, 80013, 80014, 80015, 80016, 80017, 80018, 80019, 80020, 80021, 80022, 80024, 80025, 80026, 80027, 80028, 80030, 80031, 80033, 80034, 80035, 80036, 80037, 80038, 80040, 80041, 80042, 80044, 80045, 80046, 80047, 80061, 80101, 80102, 80103, 80104, 80105, 80106, 80107, 80108, 80109, 80110, 80111, 80112, 80115, 80116, 80117, 80118, 80120, 80121, 80122, 80123, 80124, 80125, 80126, 80127, 80128, 80129, 80130, 80131, 80132, 80133, 80134, 80135, 80136, 80137, 80138, 80139, 80150, 80151, 80154, 80155, 80160, 80161, 80162, 80163, 80165, 80166, 80201, 80202, 80203, 80204, 80205, 80206, 80207, 80208, 80209, 80210, 80211, 80212, 80214, 80215, 80216, 80217, 80218, 80219, 80220, 80221, 80222, 80223, 80224, 80225, 80226, 80227, 80228, 80229, 80230, 80231, 80232, 80233, 80234, 80235, 80236, 80237, 80238, 80239, 80241, 80243, 80244, 80246, 80247, 80248, 80249, 80250, 80251, 80252, 80254, 80255, 80256, 80257, 80259, 80260, 80261, 80262, 80263, 80264, 80265, 80266, 80270, 80271, 80273, 80274, 80275, 80279, 80280, 80281, 80290, 80291, 80292, 80293, 80294, 80295, 80296, 80299, 80301, 80302, 80303, 80304, 80305, 80306, 80307, 80308, 80309, 80310, 80314, 80321, 80322, 80323, 80328, 80329, 80401, 80402, 80403, 80419, 80420, 80421, 80422, 80424, 80425, 80427, 80432, 80433, 80435, 80436, 80437, 80438, 80439, 80440, 80442, 80443, 80444, 80446, 80447, 80448, 80449, 80451, 80452, 80453, 80454, 80455, 80456, 80457, 80465, 80466, 80468, 80470, 80471, 80474, 80475, 80476, 80478, 80481, 80482, 80497, 80498, 80501, 80502, 80503, 80504, 80509, 80510, 80511, 80512, 80513, 80514, 80515, 80516, 80517, 80520, 80521, 80522, 80523, 80524, 80525, 80526, 80527, 80528, 80530, 80532, 80533, 80534, 80535, 80536, 80537, 80538, 80539, 80540, 80541, 80542, 80543, 80544, 80545, 80546, 80547, 80549, 80550, 80551, 80553, 80601, 80602, 80603, 80610, 80611, 80612, 80614, 80615, 80620, 80621, 80622, 80623, 80624, 80630, 80631, 80632, 80633, 80634, 80638, 80639, 80640, 80642, 80643, 80644, 80645, 80646, 80648, 80649, 80650, 80651, 80652, 80653, 80654, 80701, 80705, 80720, 80722, 80723, 80729, 80732, 80733, 80740, 80741, 80742, 80743, 80745, 80750, 80751, 80754, 80757, 80759, 80801, 80804, 80808, 80809, 80812, 80813, 80814, 80815, 80816, 80817, 80818, 80819, 80820, 80821, 80822, 80823, 80826, 80827, 80828, 80829, 80830, 80831, 80832, 80833, 80834, 80835, 80840, 80841, 80860, 80861, 80862, 80863, 80864, 80866, 80901, 80902, 80903, 80904, 80905, 80906, 80907, 80908, 80909, 80910, 80911, 80912, 80913, 80914, 80915, 80916, 80917, 80918, 80919, 80920, 80921, 80922, 80924, 80925, 80926, 80928, 80929, 80930, 80931, 80932, 80933, 80934, 80935, 80936, 80937, 80940, 80941, 80942, 80943, 80944, 80945, 80946, 80947, 80949, 80950, 80960, 80962, 80970, 80977, 80995, 80997, 81007, 81008, 81212, 81240, 82001, 82005, 82007, 82054, 82059)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
