| |
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 / 2 * 10) + user_session_time / 1227046595 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (27306, 28002, 28003, 28007, 28012, 28026, 28032, 28051, 28052, 28053, 28054, 28055, 28056, 28073, 28075, 28079, 28082, 28086, 28091, 28097, 28098, 28101, 28102, 28103, 28104, 28105, 28106, 28107, 28108, 28110, 28111, 28112, 28119, 28120, 28126, 28128, 28129, 28130, 28133, 28134, 28135, 28163, 28170, 28173, 28174, 28201, 28202, 28203, 28204, 28205, 28206, 28207, 28208, 28209, 28210, 28211, 28212, 28213, 28214, 28215, 28216, 28217, 28218, 28219, 28220, 28221, 28222, 28223, 28224, 28225, 28226, 28227, 28228, 28229, 28230, 28231, 28232, 28234, 28235, 28236, 28237, 28240, 28241, 28242, 28243, 28244, 28246, 28247, 28250, 28253, 28254, 28255, 28256, 28258, 28260, 28261, 28262, 28265, 28266, 28269, 28270, 28272, 28273, 28274, 28275, 28277, 28278, 28280, 28281, 28282, 28283, 28284, 28285, 28286, 28287, 28288, 28289, 28290, 28296, 28297, 28299, 28319, 28330, 28338, 28340, 28343, 28345, 28351, 28352, 28353, 28362, 28363, 28364, 28379, 28380, 28383, 29001, 29002, 29003, 29006, 29009, 29010, 29014, 29015, 29016, 29018, 29020, 29030, 29031, 29032, 29033, 29036, 29037, 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, 29235, 29240, 29250, 29260, 29290, 29292, 29302, 29304, 29306, 29307, 29318, 29319, 29321, 29324, 29325, 29329, 29331, 29332, 29335, 29336, 29340, 29342, 29348, 29351, 29353, 29355, 29360, 29363, 29364, 29370, 29372, 29373, 29374, 29376, 29378, 29379, 29384, 29386, 29388, 29390, 29391, 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, 29530, 29532, 29535, 29536, 29540, 29541, 29542, 29543, 29544, 29546, 29547, 29550, 29551, 29554, 29555, 29556, 29560, 29561, 29563, 29564, 29565, 29567, 29570, 29571, 29573, 29574, 29576, 29578, 29579, 29580, 29581, 29583, 29584, 29585, 29588, 29589, 29590, 29591, 29592, 29593, 29594, 29596, 29597, 29599, 29620, 29638, 29645, 29646, 29647, 29648, 29649, 29653, 29666, 29692, 29695, 29698, 29702, 29703, 29704, 29706, 29708, 29709, 29710, 29712, 29714, 29715, 29716, 29717, 29718, 29720, 29721, 29722, 29724, 29726, 29727, 29728, 29729, 29730, 29731, 29732, 29733, 29734, 29741, 29742, 29743, 29744, 29745, 29756, 29801, 29802, 29803, 29804, 29805, 29808, 29809, 29810, 29812, 29813, 29816, 29817, 29819, 29821, 29822, 29824, 29826, 29827, 29828, 29829, 29831, 29832, 29834, 29835, 29836, 29838, 29839, 29841, 29842, 29843, 29844, 29845, 29846, 29847, 29848, 29849, 29850, 29851, 29853, 29856, 29860, 29861, 29875, 29899, 29911, 29912, 29913, 29914, 29916, 29918, 29921, 29922, 29923, 29924, 29929, 29931, 29932, 29933, 29934, 29936, 29939, 29940, 29941, 29942, 29944, 29945, 30424, 30426, 30456, 30467, 30802, 30805, 30809, 30811, 30812, 30813, 30814, 30815, 30816, 30822, 30830, 30901, 30903, 30904, 30905, 30906, 30907, 30909, 30910, 30911, 30912, 30913, 30914, 30916, 30917, 30919, 30999)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
