| |
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 / 4 * 10) + user_session_time / 1227039953 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1140 and user_zip in (73011, 73012, 73019, 73026, 73030, 73031, 73032, 73051, 73052, 73057, 73068, 73070, 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, 73529, 73533, 73536, 73561, 73565, 73569, 73573, 73575, 74425, 74426, 74430, 74431, 74432, 74437, 74440, 74442, 74460, 74461, 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, 74852, 74853, 74854, 74856, 74857, 74859, 74860, 74864, 74865, 74866, 74867, 74868, 74871, 74872, 74873, 74878, 74880, 74883, 74884, 74894, 74935, 74942, 74943, 74949, 74957, 74963, 75001, 75002, 75006, 75007, 75008, 75009, 75010, 75011, 75013, 75014, 75015, 75016, 75017, 75019, 75020, 75021, 75022, 75023, 75024, 75025, 75026, 75027, 75028, 75029, 75030, 75032, 75034, 75035, 75037, 75038, 75039, 75040, 75041, 75042, 75043, 75044, 75045, 75046, 75047, 75048, 75049, 75053, 75054, 75056, 75057, 75058, 75059, 75061, 75062, 75063, 75065, 75066, 75067, 75068, 75069, 75070, 75071, 75074, 75075, 75076, 75077, 75078, 75080, 75081, 75082, 75083, 75085, 75086, 75087, 75088, 75089, 75090, 75091, 75092, 75093, 75094, 75097, 75098, 75099, 75106, 75121, 75123, 75126, 75132, 75135, 75138, 75149, 75150, 75160, 75161, 75164, 75166, 75169, 75173, 75180, 75181, 75182, 75185, 75187, 75189, 75201, 75202, 75204, 75205, 75206, 75207, 75209, 75210, 75212, 75214, 75215, 75218, 75219, 75220, 75221, 75222, 75223, 75225, 75226, 75227, 75228, 75229, 75230, 75231, 75234, 75235, 75238, 75239, 75240, 75242, 75243, 75244, 75245, 75246, 75247, 75248, 75250, 75251, 75252, 75254, 75258, 75260, 75261, 75262, 75263, 75264, 75265, 75266, 75267, 75270, 75275, 75277, 75283, 75284, 75285, 75286, 75287, 75294, 75295, 75301, 75303, 75310, 75312, 75313, 75315, 75320, 75323, 75326, 75336, 75339, 75342, 75346, 75350, 75353, 75354, 75355, 75356, 75357, 75359, 75360, 75363, 75364, 75367, 75368, 75370, 75371, 75372, 75373, 75374, 75376, 75378, 75379, 75380, 75381, 75382, 75386, 75387, 75388, 75389, 75390, 75391, 75392, 75393, 75394, 75395, 75396, 75397, 75398, 75401, 75402, 75403, 75404, 75407, 75408, 75409, 75410, 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, 75455, 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, 76039, 76051, 76092, 76201, 76202, 76203, 76204, 76205, 76206, 76207, 76208, 76209, 76210, 76225, 76226, 76227, 76233, 76234, 76238, 76239, 76240, 76241, 76245, 76246, 76247, 76249, 76250, 76251, 76252, 76253, 76255, 76258, 76259, 76261, 76262, 76263, 76264, 76265, 76266, 76267, 76268, 76270, 76271, 76272, 76273, 76299, 76356)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
