| |
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 / 1227079254 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1>1500 and user_zip in (12010, 12016, 12025, 12031, 12032, 12035, 12036, 12043, 12064, 12066, 12068, 12069, 12070, 12072, 12073, 12078, 12086, 12092, 12093, 12095, 12108, 12116, 12117, 12134, 12139, 12149, 12155, 12160, 12164, 12166, 12175, 12177, 12187, 12190, 12197, 12811, 12812, 12825, 12842, 12847, 12852, 12856, 12864, 12922, 12927, 12973, 12986, 13020, 13021, 13022, 13024, 13026, 13027, 13028, 13029, 13030, 13031, 13032, 13033, 13034, 13035, 13036, 13037, 13039, 13040, 13041, 13042, 13043, 13044, 13045, 13051, 13052, 13053, 13054, 13056, 13057, 13060, 13061, 13062, 13063, 13064, 13065, 13066, 13068, 13069, 13071, 13072, 13073, 13074, 13076, 13077, 13078, 13080, 13081, 13082, 13083, 13084, 13087, 13088, 13089, 13090, 13092, 13093, 13101, 13102, 13103, 13104, 13107, 13108, 13110, 13111, 13112, 13113, 13114, 13115, 13116, 13117, 13118, 13119, 13120, 13121, 13122, 13123, 13124, 13126, 13129, 13131, 13132, 13133, 13134, 13135, 13136, 13137, 13138, 13139, 13140, 13141, 13142, 13143, 13144, 13145, 13146, 13147, 13148, 13149, 13152, 13153, 13154, 13155, 13156, 13157, 13158, 13159, 13160, 13162, 13163, 13164, 13165, 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, 13315, 13316, 13317, 13318, 13319, 13320, 13321, 13322, 13323, 13324, 13325, 13326, 13327, 13328, 13329, 13331, 13332, 13333, 13334, 13335, 13337, 13338, 13339, 13340, 13341, 13342, 13343, 13345, 13346, 13348, 13350, 13352, 13353, 13354, 13355, 13357, 13360, 13361, 13362, 13363, 13364, 13365, 13367, 13368, 13388, 13396, 13401, 13402, 13403, 13404, 13406, 13407, 13408, 13409, 13410, 13411, 13413, 13415, 13416, 13417, 13418, 13420, 13421, 13424, 13425, 13426, 13428, 13431, 13433, 13435, 13436, 13437, 13438, 13439, 13440, 13441, 13442, 13444, 13449, 13450, 13452, 13453, 13454, 13455, 13456, 13457, 13459, 13460, 13461, 13464, 13465, 13468, 13469, 13470, 13471, 13472, 13473, 13475, 13476, 13477, 13478, 13479, 13480, 13482, 13483, 13484, 13485, 13486, 13488, 13489, 13490, 13491, 13492, 13493, 13494, 13495, 13501, 13502, 13503, 13504, 13505, 13550, 13562, 13578, 13599, 13601, 13602, 13603, 13605, 13606, 13607, 13608, 13610, 13611, 13612, 13614, 13615, 13616, 13617, 13618, 13619, 13620, 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, 13650, 13651, 13652, 13654, 13656, 13657, 13658, 13659, 13660, 13661, 13664, 13665, 13666, 13668, 13669, 13670, 13671, 13672, 13673, 13674, 13675, 13676, 13677, 13679, 13680, 13681, 13682, 13683, 13684, 13685, 13687, 13688, 13690, 13691, 13692, 13693, 13695, 13696, 13698, 13699, 13730, 13732, 13733, 13736, 13737, 13738, 13739, 13743, 13744, 13745, 13746, 13747, 13749, 13750, 13751, 13753, 13757, 13758, 13760, 13761, 13762, 13763, 13766, 13775, 13776, 13777, 13778, 13780, 13784, 13786, 13787, 13790, 13792, 13794, 13796, 13797, 13801, 13802, 13803, 13804, 13807, 13808, 13809, 13810, 13811, 13813, 13814, 13815, 13820, 13825, 13826, 13827, 13830, 13832, 13833, 13834, 13835, 13838, 13839, 13841, 13842, 13843, 13844, 13846, 13848, 13849, 13850, 13851, 13859, 13861, 13862, 13863, 13864, 13901, 13902, 13903, 13904, 13905, 13942, 14064, 14410, 14413, 14414, 14415, 14417, 14418, 14424, 14425, 14428, 14430, 14432, 14433, 14441, 14443, 14445, 14449, 14450, 14453, 14456, 14458, 14461, 14463, 14464, 14466, 14467, 14468, 14469, 14471, 14472, 14475, 14478, 14480, 14485, 14487, 14489, 14502, 14504, 14505, 14506, 14507, 14512, 14513, 14514, 14515, 14516, 14518, 14519, 14520, 14521, 14522, 14526, 14527, 14532, 14534, 14537, 14538, 14541, 14542, 14543, 14544, 14546, 14547, 14548, 14551, 14555, 14558, 14559, 14560, 14561, 14563, 14564, 14568, 14580, 14585, 14586, 14588, 14589, 14590, 14601, 14602, 14603, 14604, 14605, 14606, 14607, 14608, 14609, 14610, 14611, 14612, 14613, 14614, 14615, 14616, 14617, 14618, 14619, 14620, 14621, 14622, 14623, 14624, 14625, 14626, 14627, 14638, 14639, 14642, 14643, 14644, 14645, 14646, 14647, 14649, 14650, 14651, 14652, 14653, 14660, 14664, 14673, 14683, 14692, 14694, 14771, 14805, 14808, 14812, 14815, 14816, 14817, 14818, 14824, 14837, 14838, 14840, 14841, 14842, 14847, 14850, 14851, 14852, 14853, 14854, 14857, 14859, 14860, 14863, 14864, 14865, 14867, 14869, 14872, 14873, 14874, 14876, 14878, 14881, 14882, 14883, 14886, 14887, 14889, 14891, 14893)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
