| |
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 / 1227031801 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1100 and user_zip in (29001, 29002, 29003, 29006, 29016, 29018, 29020, 29030, 29033, 29036, 29037, 29038, 29039, 29040, 29041, 29042, 29044, 29045, 29047, 29048, 29051, 29052, 29053, 29054, 29056, 29059, 29061, 29062, 29063, 29065, 29066, 29070, 29071, 29072, 29073, 29075, 29078, 29080, 29081, 29082, 29102, 29103, 29104, 29105, 29106, 29107, 29108, 29111, 29112, 29113, 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, 29162, 29163, 29164, 29166, 29168, 29169, 29170, 29171, 29172, 29176, 29177, 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, 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, 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, 29510, 29518, 29535, 29556, 29564, 29590, 29666, 29801, 29802, 29803, 29804, 29805, 29808, 29809, 29810, 29812, 29813, 29816, 29817, 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, 29899, 29901, 29902, 29903, 29904, 29905, 29906, 29907, 29909, 29910, 29911, 29912, 29913, 29914, 29915, 29916, 29918, 29920, 29921, 29922, 29923, 29924, 29925, 29926, 29927, 29928, 29929, 29931, 29932, 29933, 29934, 29935, 29936, 29938, 29939, 29940, 29941, 29942, 29943, 29944, 29945, 29982, 30401, 30410, 30412, 30413, 30414, 30415, 30417, 30420, 30421, 30423, 30424, 30425, 30426, 30427, 30429, 30434, 30436, 30438, 30439, 30441, 30442, 30445, 30446, 30447, 30448, 30449, 30450, 30451, 30452, 30453, 30454, 30455, 30456, 30457, 30458, 30459, 30460, 30461, 30464, 30466, 30467, 30470, 30471, 30473, 30474, 30475, 30477, 30499, 30802, 30803, 30805, 30806, 30807, 30808, 30809, 30810, 30811, 30812, 30813, 30814, 30815, 30816, 30817, 30818, 30819, 30820, 30821, 30822, 30823, 30824, 30828, 30830, 30833, 30901, 30903, 30904, 30905, 30906, 30907, 30909, 30910, 30911, 30912, 30913, 30914, 30916, 30917, 30919, 30999, 31002, 31018, 31027, 31035, 31045, 31049, 31082, 31089, 31094, 31096, 31301, 31302, 31303, 31304, 31307, 31308, 31309, 31310, 31312, 31313, 31314, 31315, 31316, 31318, 31320, 31321, 31322, 31323, 31324, 31326, 31328, 31329, 31331, 31332, 31333, 31401, 31402, 31403, 31404, 31405, 31406, 31407, 31408, 31409, 31410, 31411, 31412, 31414, 31415, 31416, 31418, 31419, 31420, 31421, 31422, 31424, 31441, 31498, 31499, 31545)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
