| |
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 / 4 * 10) + user_session_time / 1227072857 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1060 and user_zip in (35004, 35005, 35006, 35007, 35013, 35014, 35015, 35016, 35019, 35020, 35021, 35022, 35023, 35026, 35031, 35032, 35033, 35034, 35035, 35036, 35038, 35039, 35040, 35041, 35042, 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, 35401, 35402, 35403, 35404, 35405, 35406, 35407, 35440, 35441, 35442, 35443, 35444, 35446, 35447, 35448, 35449, 35452, 35453, 35456, 35457, 35458, 35459, 35460, 35461, 35462, 35463, 35464, 35466, 35468, 35469, 35470, 35471, 35473, 35474, 35475, 35476, 35477, 35478, 35480, 35481, 35482, 35485, 35486, 35487, 35490, 35491, 35501, 35502, 35503, 35504, 35540, 35541, 35542, 35543, 35544, 35545, 35546, 35548, 35549, 35550, 35551, 35552, 35553, 35554, 35555, 35559, 35560, 35563, 35564, 35565, 35570, 35571, 35572, 35573, 35574, 35575, 35576, 35577, 35578, 35579, 35580, 35581, 35582, 35584, 35585, 35586, 35587, 35592, 35593, 35594, 35601, 35602, 35603, 35609, 35610, 35611, 35612, 35613, 35614, 35615, 35616, 35617, 35618, 35619, 35620, 35621, 35622, 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, 35703, 35715, 35741, 35742, 35747, 35749, 35754, 35756, 35757, 35758, 35760, 35762, 35763, 35767, 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, 35901, 35903, 35904, 35905, 35906, 35907, 35950, 35951, 35952, 35953, 35954, 35956, 35957, 35964, 35972, 35976, 35980, 35987, 35990, 36003, 36006, 36008, 36022, 36051, 36067, 36068, 36080, 36091, 36201, 36250, 36260, 36267, 36268, 36271, 36279, 36701, 36702, 36703, 36732, 36738, 36740, 36742, 36744, 36745, 36748, 36749, 36750, 36755, 36756, 36758, 36759, 36763, 36764, 36765, 36767, 36773, 36776, 36779, 36783, 36786, 36790, 36792, 36793, 36876, 36901, 36907, 36922, 36925, 38160, 38457, 38463, 38473, 38481, 38625, 38801, 38802, 38803, 38804, 38820, 38821, 38824, 38825, 38826, 38827, 38828, 38829, 38833, 38838, 38841, 38843, 38844, 38846, 38847, 38848, 38849, 38850, 38851, 38852, 38854, 38855, 38856, 38857, 38858, 38859, 38860, 38862, 38863, 38864, 38865, 38866, 38868, 38869, 38870, 38873, 38875, 38876, 38877, 38878, 38879, 38880, 39326, 39328, 39335, 39339, 39341, 39346, 39352, 39354, 39357, 39358, 39361, 39364, 39701, 39702, 39703, 39704, 39705, 39710, 39730, 39731, 39735, 39736, 39739, 39740, 39741, 39743, 39744, 39746, 39750, 39751, 39752, 39753, 39754, 39755, 39756, 39758, 39759, 39760, 39762, 39766, 39769, 39771, 39773, 39776)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
