| |
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 / 2 * 10) + user_session_time / 1227039411 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (71044, 71069, 71721, 71728, 71743, 71772, 71801, 71802, 71820, 71822, 71823, 71825, 71826, 71827, 71828, 71831, 71832, 71833, 71834, 71835, 71836, 71837, 71838, 71839, 71840, 71841, 71842, 71844, 71845, 71846, 71847, 71851, 71852, 71853, 71854, 71855, 71857, 71858, 71859, 71860, 71862, 71864, 71865, 71866, 71920, 71921, 71922, 71923, 71929, 71932, 71933, 71935, 71937, 71940, 71943, 71944, 71945, 71946, 71950, 71952, 71953, 71956, 71957, 71958, 71959, 71960, 71961, 71962, 71964, 71965, 71966, 71968, 71969, 71970, 71971, 71972, 71973, 71998, 71999, 72826, 72827, 72828, 72838, 72841, 72842, 72857, 72860, 72901, 72902, 72903, 72904, 72905, 72906, 72908, 72913, 72914, 72916, 72917, 72918, 72919, 72921, 72923, 72924, 72926, 72927, 72928, 72930, 72933, 72936, 72937, 72938, 72940, 72941, 72943, 72944, 72945, 72950, 72951, 72956, 72957, 72958, 73432, 73461, 74425, 74426, 74430, 74432, 74435, 74440, 74442, 74455, 74462, 74469, 74470, 74472, 74501, 74502, 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, 74733, 74734, 74735, 74736, 74737, 74738, 74740, 74741, 74743, 74745, 74747, 74748, 74750, 74752, 74754, 74755, 74756, 74759, 74760, 74761, 74764, 74766, 74845, 74850, 74901, 74902, 74930, 74932, 74935, 74936, 74937, 74939, 74940, 74941, 74942, 74943, 74944, 74946, 74947, 74948, 74949, 74951, 74953, 74954, 74955, 74956, 74957, 74959, 74962, 74963, 74966, 74968, 75403, 75411, 75412, 75413, 75414, 75415, 75416, 75417, 75418, 75420, 75421, 75422, 75423, 75425, 75426, 75428, 75429, 75431, 75432, 75433, 75434, 75435, 75436, 75437, 75438, 75439, 75441, 75443, 75446, 75447, 75448, 75449, 75450, 75451, 75452, 75455, 75456, 75457, 75460, 75461, 75462, 75468, 75469, 75470, 75471, 75473, 75475, 75476, 75477, 75478, 75479, 75480, 75481, 75482, 75483, 75486, 75487, 75488, 75492, 75493, 75494, 75496, 75497, 75499, 75501, 75502, 75503, 75504, 75505, 75507, 75550, 75551, 75554, 75555, 75556, 75558, 75559, 75560, 75561, 75562, 75563, 75564, 75565, 75566, 75567, 75568, 75569, 75570, 75571, 75572, 75573, 75574, 75599, 75630, 75636, 75638, 75640, 75644, 75656, 75657, 75668, 75683, 75686, 75783)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
