| |
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 / 1 * 10) + user_session_time / 1227046546 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (28003, 28007, 28091, 28102, 28103, 28104, 28108, 28110, 28111, 28112, 28119, 28133, 28135, 28170, 28173, 28174, 28319, 28330, 28340, 28343, 28345, 28351, 28352, 28353, 28358, 28359, 28360, 28362, 28363, 28364, 28369, 28372, 28375, 28377, 28379, 28380, 28383, 28396, 28424, 28430, 28431, 28432, 28438, 28439, 28452, 28455, 28463, 28467, 28468, 28472, 29001, 29002, 29003, 29006, 29009, 29010, 29014, 29015, 29016, 29018, 29020, 29030, 29031, 29032, 29033, 29036, 29038, 29039, 29040, 29041, 29042, 29044, 29045, 29046, 29047, 29048, 29051, 29052, 29053, 29054, 29055, 29056, 29058, 29059, 29061, 29062, 29063, 29065, 29066, 29067, 29069, 29070, 29071, 29072, 29073, 29074, 29075, 29078, 29079, 29080, 29081, 29082, 29101, 29102, 29103, 29104, 29105, 29106, 29107, 29108, 29111, 29112, 29113, 29114, 29115, 29116, 29117, 29118, 29122, 29123, 29124, 29125, 29126, 29127, 29128, 29129, 29130, 29132, 29133, 29135, 29137, 29138, 29142, 29143, 29145, 29146, 29147, 29148, 29150, 29151, 29152, 29153, 29154, 29160, 29161, 29162, 29163, 29164, 29166, 29168, 29169, 29170, 29171, 29172, 29175, 29176, 29177, 29178, 29180, 29201, 29202, 29203, 29204, 29205, 29206, 29207, 29208, 29209, 29210, 29211, 29212, 29214, 29215, 29216, 29217, 29218, 29219, 29220, 29221, 29222, 29223, 29224, 29225, 29226, 29227, 29228, 29229, 29230, 29233, 29240, 29250, 29260, 29290, 29292, 29363, 29401, 29402, 29403, 29404, 29405, 29406, 29407, 29409, 29410, 29412, 29413, 29414, 29415, 29416, 29417, 29418, 29419, 29420, 29422, 29423, 29424, 29425, 29426, 29429, 29430, 29431, 29432, 29433, 29434, 29435, 29436, 29437, 29438, 29439, 29440, 29442, 29445, 29446, 29447, 29448, 29449, 29450, 29451, 29452, 29453, 29455, 29456, 29457, 29458, 29461, 29464, 29465, 29466, 29468, 29469, 29470, 29471, 29472, 29474, 29475, 29476, 29477, 29479, 29481, 29482, 29483, 29484, 29485, 29487, 29488, 29492, 29493, 29494, 29501, 29502, 29503, 29504, 29505, 29506, 29510, 29511, 29512, 29516, 29518, 29519, 29520, 29525, 29526, 29527, 29528, 29530, 29532, 29536, 29540, 29541, 29542, 29543, 29544, 29545, 29546, 29547, 29549, 29550, 29551, 29554, 29555, 29556, 29560, 29561, 29563, 29564, 29565, 29566, 29567, 29568, 29569, 29570, 29571, 29572, 29573, 29574, 29575, 29576, 29577, 29578, 29579, 29580, 29581, 29582, 29583, 29584, 29585, 29587, 29588, 29589, 29590, 29591, 29592, 29593, 29594, 29596, 29597, 29598, 29599, 29704, 29706, 29709, 29712, 29714, 29715, 29718, 29720, 29721, 29722, 29724, 29727, 29728, 29729, 29730, 29741, 29744, 29756, 29801, 29802, 29803, 29804, 29805, 29808, 29809, 29810, 29812, 29813, 29816, 29817, 29822, 29826, 29827, 29828, 29829, 29831, 29832, 29834, 29836, 29839, 29842, 29843, 29846, 29847, 29849, 29850, 29851, 29853, 29856, 29861, 29875, 29901, 29902, 29903, 29904, 29905, 29906, 29907, 29911, 29912, 29913, 29914, 29916, 29918, 29920, 29921, 29922, 29923, 29924, 29929, 29931, 29932, 29933, 29934, 29935, 29936, 29938, 29939, 29940, 29941, 29942, 29943, 29944, 29945, 30426)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
