| |
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 / 8 * 10) + user_session_time / 1227091508 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (14048, 14063, 14166, 14701, 14702, 14703, 14704, 14710, 14712, 14716, 14718, 14720, 14722, 14724, 14728, 14733, 14736, 14738, 14740, 14742, 14750, 14752, 14756, 14757, 14758, 14767, 14769, 14775, 14781, 14782, 14784, 14785, 14787, 15001, 15003, 15005, 15006, 15007, 15009, 15010, 15014, 15015, 15019, 15021, 15024, 15026, 15027, 15030, 15042, 15043, 15044, 15046, 15050, 15051, 15052, 15053, 15054, 15056, 15059, 15061, 15065, 15066, 15071, 15074, 15075, 15076, 15077, 15078, 15081, 15084, 15086, 15090, 15101, 15108, 15116, 15126, 15136, 15143, 15202, 15204, 15209, 15214, 15223, 15225, 15229, 15237, 15275, 15630, 15682, 15828, 15829, 16001, 16002, 16003, 16006, 16016, 16017, 16018, 16020, 16021, 16022, 16023, 16024, 16025, 16027, 16028, 16029, 16030, 16033, 16034, 16035, 16036, 16037, 16038, 16039, 16040, 16041, 16045, 16046, 16048, 16049, 16050, 16051, 16052, 16053, 16054, 16055, 16056, 16057, 16058, 16059, 16061, 16063, 16066, 16101, 16102, 16103, 16105, 16107, 16108, 16110, 16111, 16112, 16113, 16114, 16115, 16116, 16117, 16120, 16121, 16123, 16124, 16125, 16127, 16130, 16131, 16132, 16133, 16134, 16136, 16137, 16140, 16141, 16142, 16143, 16145, 16146, 16148, 16150, 16151, 16153, 16154, 16155, 16156, 16157, 16159, 16160, 16161, 16172, 16201, 16210, 16212, 16213, 16214, 16215, 16216, 16217, 16218, 16220, 16221, 16223, 16224, 16225, 16228, 16229, 16230, 16232, 16233, 16234, 16235, 16236, 16238, 16239, 16242, 16245, 16248, 16253, 16254, 16255, 16257, 16258, 16259, 16260, 16261, 16262, 16299, 16301, 16302, 16311, 16312, 16313, 16314, 16316, 16317, 16319, 16321, 16322, 16323, 16326, 16327, 16328, 16329, 16331, 16332, 16334, 16335, 16340, 16341, 16342, 16343, 16344, 16345, 16346, 16347, 16350, 16351, 16352, 16353, 16354, 16355, 16360, 16361, 16362, 16364, 16365, 16366, 16367, 16368, 16369, 16370, 16371, 16372, 16373, 16374, 16375, 16388, 16401, 16402, 16403, 16404, 16405, 16406, 16407, 16410, 16411, 16412, 16413, 16414, 16415, 16416, 16417, 16420, 16421, 16422, 16423, 16424, 16426, 16427, 16428, 16430, 16432, 16433, 16434, 16435, 16436, 16438, 16440, 16441, 16442, 16443, 16444, 16475, 16501, 16502, 16503, 16504, 16505, 16506, 16507, 16508, 16509, 16510, 16511, 16512, 16514, 16515, 16522, 16530, 16531, 16532, 16533, 16534, 16538, 16541, 16544, 16546, 16550, 16553, 16554, 16558, 16563, 16565, 26034, 26035, 26037, 26047, 26050, 26056, 26062, 43400, 43436, 43438, 43440, 43446, 43456, 43804, 43840, 43903, 43908, 43910, 43920, 43925, 43926, 43930, 43932, 43938, 43944, 43945, 43952, 43953, 43961, 43962, 43964, 43966, 43968, 43970, 43976, 43984, 43986, 43988, 43989, 44001, 44003, 44004, 44005, 44010, 44011, 44012, 44017, 44021, 44022, 44023, 44024, 44026, 44028, 44030, 44032, 44033, 44035, 44036, 44039, 44040, 44041, 44044, 44045, 44046, 44047, 44048, 44049, 44050, 44052, 44053, 44054, 44055, 44056, 44057, 44060, 44061, 44062, 44064, 44065, 44067, 44068, 44070, 44072, 44073, 44074, 44076, 44077, 44080, 44081, 44082, 44084, 44085, 44086, 44087, 44088, 44089, 44090, 44092, 44093, 44094, 44095, 44096, 44097, 44099, 44101, 44102, 44103, 44104, 44105, 44106, 44107, 44108, 44109, 44110, 44111, 44112, 44113, 44114, 44115, 44116, 44117, 44118, 44119, 44120, 44121, 44122, 44123, 44124, 44125, 44126, 44127, 44128, 44129, 44130, 44131, 44132, 44133, 44134, 44135, 44136, 44137, 44138, 44139, 44140, 44141, 44142, 44143, 44144, 44145, 44146, 44147, 44149, 44168, 44177, 44178, 44179, 44181, 44184, 44185, 44186, 44188, 44189, 44190, 44191, 44192, 44193, 44194, 44195, 44197, 44198, 44199, 44201, 44202, 44203, 44210, 44211, 44212, 44214, 44215, 44216, 44217, 44221, 44222, 44223, 44224, 44230, 44231, 44232, 44233, 44234, 44235, 44236, 44237, 44238, 44240, 44241, 44242, 44243, 44250, 44251, 44253, 44254, 44255, 44256, 44258, 44260, 44262, 44264, 44265, 44266, 44270, 44272, 44273, 44274, 44275, 44276, 44278, 44280, 44281, 44282, 44285, 44286, 44287, 44288, 44301, 44302, 44303, 44304, 44305, 44306, 44307, 44308, 44309, 44310, 44311, 44312, 44313, 44314, 44315, 44316, 44317, 44319, 44320, 44321, 44322, 44325, 44326, 44328, 44331, 44333, 44334, 44372, 44393, 44396, 44397, 44398, 44399, 44401, 44402, 44403, 44404, 44405, 44406, 44408, 44410, 44411, 44412, 44413, 44415, 44416, 44417, 44418, 44420, 44422, 44423, 44424, 44425, 44427, 44428, 44429, 44430, 44431, 44432, 44436, 44437, 44438, 44439, 44440, 44441, 44442, 44443, 44444, 44445, 44446, 44449, 44450, 44451, 44452, 44453, 44454, 44455, 44460, 44470, 44471, 44473, 44481, 44482, 44483, 44484, 44485, 44486, 44487, 44488, 44490, 44491, 44492, 44493, 44501, 44502, 44503, 44504, 44505, 44506, 44507, 44509, 44510, 44511, 44512, 44513, 44514, 44515, 44555, 44598, 44599, 44601, 44606, 44607, 44608, 44609, 44610, 44611, 44612, 44613, 44614, 44615, 44617, 44618, 44619, 44620, 44621, 44622, 44624, 44625, 44626, 44627, 44629, 44630, 44631, 44632, 44633, 44634, 44636, 44638, 44639, 44640, 44641, 44643, 44644, 44645, 44646, 44647, 44648, 44650, 44651, 44652, 44653, 44654, 44656, 44657, 44659, 44660, 44661, 44662, 44663, 44665, 44666, 44667, 44669, 44670, 44671, 44672, 44675, 44676, 44677, 44678, 44679, 44680, 44681, 44682, 44683, 44684, 44685, 44687, 44688, 44689, 44690, 44691, 44692, 44693, 44695, 44697, 44701, 44702, 44703, 44704, 44705, 44706, 44707, 44708, 44709, 44710, 44711, 44712, 44714, 44718, 44720, 44721, 44730, 44735, 44750, 44760, 44767, 44798, 44799, 44805, 44814, 44816, 44824, 44826, 44837, 44838, 44839, 44840, 44842, 44846, 44847, 44848, 44851, 44855, 44857, 44858, 44859, 44866, 44870, 44871, 44874, 44878, 44880, 44888, 44889)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
