| |
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 / 1227072884 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1120 and user_zip in (30006, 30007, 30008, 30060, 30061, 30062, 30063, 30064, 30065, 30066, 30067, 30069, 30080, 30081, 30082, 30090, 30101, 30102, 30103, 30104, 30105, 30106, 30108, 30109, 30110, 30111, 30113, 30114, 30115, 30116, 30117, 30118, 30119, 30120, 30121, 30122, 30123, 30124, 30125, 30126, 30127, 30129, 30132, 30133, 30134, 30135, 30137, 30138, 30139, 30140, 30141, 30142, 30144, 30145, 30146, 30147, 30149, 30150, 30151, 30152, 30153, 30154, 30157, 30161, 30162, 30163, 30164, 30165, 30166, 30168, 30170, 30171, 30172, 30173, 30175, 30176, 30178, 30179, 30180, 30182, 30183, 30184, 30185, 30187, 30188, 30189, 30217, 30219, 30263, 30264, 30268, 30275, 30331, 30336, 30701, 30703, 30705, 30707, 30708, 30710, 30711, 30716, 30719, 30720, 30721, 30722, 30724, 30725, 30726, 30728, 30730, 30731, 30732, 30733, 30734, 30735, 30736, 30738, 30739, 30740, 30741, 30742, 30746, 30747, 30750, 30751, 30752, 30753, 30754, 30755, 30756, 30757, 30881, 35004, 35005, 35006, 35007, 35010, 35011, 35013, 35014, 35015, 35016, 35019, 35020, 35021, 35022, 35023, 35026, 35031, 35032, 35033, 35035, 35036, 35038, 35039, 35040, 35041, 35043, 35044, 35045, 35046, 35048, 35049, 35050, 35051, 35052, 35053, 35054, 35055, 35056, 35057, 35058, 35060, 35061, 35062, 35063, 35064, 35068, 35070, 35071, 35072, 35073, 35074, 35077, 35078, 35079, 35080, 35082, 35083, 35085, 35087, 35089, 35091, 35094, 35096, 35097, 35098, 35111, 35112, 35114, 35115, 35116, 35117, 35118, 35119, 35120, 35121, 35123, 35124, 35125, 35126, 35127, 35128, 35130, 35131, 35133, 35135, 35136, 35137, 35139, 35142, 35143, 35144, 35146, 35147, 35148, 35149, 35150, 35151, 35160, 35161, 35171, 35172, 35173, 35175, 35176, 35178, 35179, 35180, 35181, 35182, 35183, 35184, 35185, 35186, 35187, 35188, 35201, 35202, 35203, 35204, 35205, 35206, 35207, 35208, 35209, 35210, 35211, 35212, 35213, 35214, 35215, 35216, 35217, 35218, 35219, 35220, 35221, 35222, 35223, 35224, 35225, 35226, 35228, 35229, 35230, 35231, 35232, 35233, 35234, 35235, 35236, 35237, 35238, 35240, 35242, 35243, 35244, 35245, 35246, 35249, 35253, 35254, 35255, 35259, 35260, 35261, 35263, 35266, 35277, 35278, 35279, 35280, 35281, 35282, 35283, 35285, 35286, 35287, 35288, 35289, 35290, 35291, 35292, 35293, 35294, 35295, 35296, 35297, 35298, 35299, 35308, 35402, 35406, 35407, 35440, 35444, 35449, 35468, 35475, 35478, 35482, 35485, 35490, 35501, 35502, 35503, 35504, 35540, 35541, 35542, 35543, 35546, 35548, 35549, 35550, 35551, 35553, 35554, 35559, 35560, 35564, 35565, 35572, 35573, 35575, 35577, 35578, 35579, 35580, 35581, 35584, 35585, 35587, 35594, 35601, 35602, 35603, 35609, 35610, 35611, 35612, 35613, 35614, 35615, 35617, 35618, 35619, 35620, 35621, 35622, 35630, 35631, 35632, 35634, 35640, 35643, 35645, 35646, 35647, 35648, 35649, 35650, 35651, 35652, 35653, 35654, 35659, 35660, 35661, 35670, 35671, 35672, 35673, 35674, 35699, 35703, 35715, 35739, 35740, 35741, 35742, 35744, 35745, 35746, 35747, 35748, 35749, 35750, 35751, 35752, 35754, 35755, 35756, 35757, 35758, 35759, 35760, 35761, 35762, 35763, 35764, 35765, 35766, 35767, 35768, 35769, 35771, 35772, 35773, 35774, 35775, 35776, 35801, 35802, 35803, 35804, 35805, 35806, 35807, 35808, 35809, 35810, 35811, 35812, 35813, 35814, 35815, 35816, 35824, 35893, 35894, 35895, 35896, 35897, 35898, 35899, 35901, 35902, 35903, 35904, 35905, 35906, 35907, 35950, 35951, 35952, 35953, 35954, 35956, 35957, 35958, 35959, 35960, 35961, 35962, 35963, 35964, 35966, 35967, 35968, 35969, 35971, 35972, 35973, 35974, 35975, 35976, 35978, 35979, 35980, 35981, 35983, 35984, 35986, 35987, 35988, 35989, 35990, 36023, 36026, 36201, 36202, 36203, 36204, 36205, 36206, 36207, 36250, 36251, 36253, 36254, 36255, 36256, 36257, 36258, 36260, 36261, 36262, 36263, 36264, 36265, 36266, 36267, 36268, 36269, 36270, 36271, 36272, 36273, 36274, 36275, 36276, 36277, 36278, 36279, 36280, 36792, 36855, 36861, 36862, 37018, 37019, 37020, 37047, 37091, 37144, 37160, 37161, 37162, 37183, 37301, 37302, 37304, 37305, 37306, 37311, 37313, 37315, 37316, 37318, 37323, 37324, 37327, 37328, 37330, 37334, 37335, 37339, 37340, 37341, 37342, 37343, 37345, 37347, 37348, 37349, 37350, 37351, 37352, 37353, 37355, 37356, 37357, 37359, 37360, 37363, 37365, 37366, 37372, 37374, 37375, 37376, 37377, 37379, 37380, 37382, 37383, 37384, 37387, 37388, 37389, 37394, 37396, 37397, 37398, 37401, 37402, 37403, 37404, 37405, 37406, 37407, 37408, 37409, 37410, 37411, 37412, 37414, 37415, 37416, 37419, 37421, 37422, 37424, 37450, 37499, 37838, 37937, 38449, 38451, 38453, 38455, 38457, 38459, 38460, 38468, 38469, 38472, 38473, 38477, 38478, 38481, 38488)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
