| |
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 / 15 * 10) + user_session_time / 1227079892 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (12032, 12108, 12139, 12164, 12190, 12697, 12755, 12808, 12810, 12811, 12812, 12817, 12842, 12843, 12847, 12851, 12852, 12853, 12855, 12856, 12857, 12858, 12860, 12862, 12864, 12870, 12872, 12878, 12879, 12886, 12912, 12913, 12914, 12915, 12916, 12917, 12920, 12922, 12923, 12924, 12926, 12927, 12930, 12932, 12933, 12934, 12935, 12937, 12939, 12941, 12942, 12943, 12945, 12946, 12949, 12952, 12953, 12955, 12957, 12964, 12965, 12966, 12967, 12969, 12970, 12973, 12976, 12977, 12978, 12980, 12981, 12983, 12985, 12986, 12987, 12989, 12995, 12997, 13022, 13024, 13027, 13028, 13029, 13030, 13031, 13032, 13033, 13035, 13036, 13037, 13039, 13041, 13042, 13043, 13044, 13051, 13054, 13057, 13060, 13061, 13063, 13064, 13066, 13069, 13074, 13076, 13078, 13080, 13082, 13083, 13084, 13088, 13089, 13090, 13093, 13103, 13104, 13107, 13108, 13110, 13111, 13112, 13113, 13114, 13115, 13116, 13119, 13120, 13121, 13122, 13123, 13126, 13131, 13132, 13134, 13135, 13137, 13138, 13140, 13142, 13143, 13144, 13145, 13146, 13153, 13154, 13156, 13157, 13162, 13163, 13164, 13166, 13167, 13201, 13202, 13203, 13204, 13205, 13206, 13207, 13208, 13209, 13210, 13211, 13212, 13214, 13215, 13217, 13218, 13219, 13220, 13221, 13224, 13225, 13244, 13250, 13251, 13252, 13260, 13261, 13290, 13301, 13302, 13303, 13304, 13305, 13308, 13309, 13310, 13312, 13313, 13314, 13316, 13318, 13319, 13321, 13322, 13323, 13324, 13325, 13327, 13328, 13329, 13331, 13334, 13338, 13340, 13341, 13343, 13345, 13346, 13350, 13352, 13353, 13354, 13355, 13357, 13360, 13361, 13362, 13363, 13364, 13365, 13367, 13368, 13388, 13396, 13401, 13402, 13403, 13404, 13406, 13407, 13408, 13409, 13413, 13416, 13417, 13418, 13420, 13421, 13424, 13425, 13426, 13431, 13433, 13435, 13436, 13437, 13438, 13440, 13441, 13442, 13449, 13452, 13453, 13454, 13455, 13456, 13461, 13465, 13469, 13470, 13471, 13472, 13473, 13476, 13477, 13478, 13479, 13480, 13483, 13484, 13486, 13489, 13490, 13491, 13492, 13493, 13494, 13495, 13501, 13502, 13503, 13504, 13505, 13550, 13562, 13599, 13601, 13602, 13603, 13605, 13606, 13607, 13608, 13610, 13611, 13612, 13613, 13614, 13615, 13616, 13617, 13618, 13619, 13620, 13621, 13622, 13623, 13624, 13625, 13626, 13627, 13628, 13630, 13631, 13632, 13633, 13634, 13635, 13636, 13637, 13638, 13639, 13640, 13641, 13642, 13643, 13645, 13646, 13647, 13648, 13649, 13650, 13651, 13652, 13654, 13655, 13656, 13657, 13658, 13659, 13660, 13661, 13662, 13664, 13665, 13666, 13667, 13668, 13669, 13670, 13671, 13672, 13673, 13674, 13675, 13676, 13677, 13678, 13679, 13680, 13681, 13682, 13683, 13684, 13685, 13687, 13688, 13690, 13691, 13692, 13693, 13694, 13695, 13696, 13697, 13698, 13699, 13942, 14413, 14516, 14520, 14542, 14551, 14555, 14563, 14590)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
