| |
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 / 1227040004 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (73011, 73012, 73019, 73026, 73030, 73031, 73032, 73051, 73052, 73057, 73068, 73070, 73071, 73074, 73075, 73080, 73086, 73093, 73095, 73098, 73401, 73402, 73403, 73425, 73430, 73432, 73433, 73434, 73435, 73436, 73437, 73438, 73439, 73440, 73441, 73442, 73443, 73444, 73445, 73446, 73447, 73448, 73449, 73450, 73453, 73455, 73456, 73458, 73459, 73460, 73461, 73463, 73476, 73481, 73487, 73488, 73491, 73520, 73536, 73561, 73569, 73575, 74425, 74426, 74428, 74430, 74431, 74432, 74437, 74438, 74440, 74442, 74445, 74447, 74455, 74459, 74460, 74461, 74462, 74472, 74501, 74502, 74520, 74521, 74522, 74523, 74525, 74528, 74529, 74530, 74531, 74533, 74534, 74535, 74536, 74538, 74540, 74542, 74543, 74545, 74546, 74547, 74549, 74552, 74553, 74554, 74555, 74556, 74557, 74558, 74559, 74560, 74561, 74562, 74563, 74565, 74567, 74569, 74570, 74571, 74572, 74574, 74576, 74577, 74578, 74701, 74702, 74720, 74721, 74722, 74723, 74724, 74726, 74727, 74728, 74729, 74730, 74731, 74733, 74734, 74735, 74736, 74737, 74738, 74740, 74741, 74743, 74745, 74747, 74748, 74750, 74752, 74753, 74754, 74755, 74756, 74759, 74760, 74761, 74764, 74766, 74801, 74802, 74804, 74807, 74818, 74820, 74821, 74825, 74826, 74827, 74829, 74830, 74831, 74833, 74836, 74837, 74839, 74840, 74842, 74843, 74844, 74845, 74848, 74849, 74850, 74851, 74852, 74853, 74854, 74855, 74856, 74857, 74859, 74860, 74864, 74865, 74866, 74867, 74868, 74871, 74872, 74873, 74878, 74880, 74883, 74884, 74894, 74935, 74939, 74942, 74943, 74944, 74949, 74957, 74963, 74966, 75001, 75002, 75006, 75007, 75008, 75009, 75010, 75013, 75019, 75020, 75021, 75022, 75023, 75024, 75025, 75026, 75027, 75028, 75029, 75030, 75032, 75034, 75035, 75040, 75041, 75042, 75043, 75044, 75045, 75048, 75056, 75057, 75058, 75065, 75066, 75067, 75068, 75069, 75070, 75071, 75074, 75075, 75076, 75077, 75078, 75080, 75081, 75082, 75086, 75087, 75088, 75089, 75090, 75091, 75092, 75093, 75094, 75097, 75098, 75121, 75132, 75135, 75150, 75164, 75166, 75173, 75189, 75218, 75225, 75229, 75230, 75231, 75234, 75238, 75240, 75243, 75244, 75245, 75248, 75251, 75252, 75254, 75287, 75401, 75402, 75403, 75404, 75407, 75408, 75409, 75411, 75412, 75413, 75414, 75415, 75416, 75417, 75418, 75420, 75421, 75422, 75423, 75424, 75425, 75426, 75428, 75429, 75431, 75432, 75433, 75434, 75435, 75436, 75437, 75438, 75439, 75440, 75441, 75442, 75443, 75446, 75447, 75448, 75449, 75450, 75452, 75453, 75454, 75456, 75457, 75458, 75459, 75460, 75461, 75462, 75468, 75469, 75470, 75471, 75472, 75473, 75474, 75475, 75476, 75477, 75478, 75479, 75480, 75481, 75482, 75483, 75485, 75486, 75487, 75488, 75489, 75490, 75491, 75492, 75493, 75495, 75496, 75497, 75499, 75550, 75554, 75806, 76025, 76201, 76202, 76203, 76204, 76205, 76206, 76207, 76208, 76209, 76210, 76226, 76227, 76233, 76238, 76239, 76240, 76241, 76245, 76246, 76249, 76250, 76251, 76252, 76253, 76255, 76258, 76259, 76263, 76264, 76265, 76266, 76267, 76268, 76271, 76272, 76273, 76299)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
