user warning: Unknown column 'field_affiliation_value' in 'field list' query: SELECT DISTINCT node.nid AS nid, field_affiliation_value AS unknown FROM node node INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'irperms_additional_submitter') OR (na.gid = 0 AND na.realm = 'irperms_additional_author') OR (na.gid = 1 AND na.realm = 'irperms_view') OR (na.gid = 17 AND na.realm = 'irperms_view') OR (na.gid = 18 AND na.realm = 'irperms_view') OR (na.gid = 19 AND na.realm = 'irperms_view') OR (na.gid = 20 AND na.realm = 'irperms_view') OR (na.gid = 21 AND na.realm = 'irperms_view') OR (na.gid = 46 AND na.realm = 'irperms_view') OR (na.gid = 218 AND na.realm = 'irperms_view') OR (na.gid = 225 AND na.realm = 'irperms_view') OR (na.gid = 226 AND na.realm = 'irperms_view') OR (na.gid = 227 AND na.realm = 'irperms_view') OR (na.gid = 228 AND na.realm = 'irperms_view') OR (na.gid = 229 AND na.realm = 'irperms_view') OR (na.gid = 230 AND na.realm = 'irperms_view') OR (na.gid = 231 AND na.realm = 'irperms_view') OR (na.gid = 176 AND na.realm = 'irperms_view') OR (na.gid = 2 AND na.realm = 'irperms_view') OR (na.gid = 22 AND na.realm = 'irperms_view') OR (na.gid = 98 AND na.realm = 'irperms_view') OR (na.gid = 124 AND na.realm = 'irperms_view') OR (na.gid = 150 AND na.realm = 'irperms_view') OR (na.gid = 151 AND na.realm = 'irperms_view') OR (na.gid = 195 AND na.realm = 'irperms_view') OR (na.gid = 196 AND na.realm = 'irperms_view') OR (na.gid = 15 AND na.realm = 'irperms_view') OR (na.gid = 205 AND na.realm = 'irperms_view') OR (na.gid = 4 AND na.realm = 'irperms_view') OR (na.gid = 125 AND na.realm = 'irperms_view') OR (na.gid = 126 AND na.realm = 'irperms_view') OR (na.gid = 94 AND na.realm = 'irperms_view') OR (na.gid = 41 AND na.realm = 'irperms_view') OR (na.gid = 43 AND na.realm = 'irperms_view') OR (na.gid = 127 AND na.realm = 'irperms_view') OR (na.gid = 219 AND na.realm = 'irperms_view') OR (na.gid = 123 AND na.realm = 'irperms_view') OR (na.gid = 128 AND na.realm = 'irperms_view') OR (na.gid = 100 AND na.realm = 'irperms_view') OR (na.gid = 101 AND na.realm = 'irperms_view') OR (na.gid = 107 AND na.realm = 'irperms_view') OR (na.gid = 108 AND na.realm = 'irperms_view') OR (na.gid = 105 AND na.realm = 'irperms_view') OR (na.gid = 104 AND na.realm = 'irperms_view') OR (na.gid = 106 AND na.realm = 'irperms_view') OR (na.gid = 102 AND na.realm = 'irperms_view') OR (na.gid = 103 AND na.realm = 'irperms_view') OR (na.gid = 138 AND na.realm = 'irperms_view') OR (na.gid = 114 AND na.realm = 'irperms_view') OR (na.gid = 188 AND na.realm = 'irperms_view') OR (na.gid = 117 AND na.realm = 'irperms_view') OR (na.gid = 115 AND na.realm = 'irperms_view') OR (na.gid = 116 AND na.realm = 'irperms_view') OR (na.gid = 119 AND na.realm = 'irperms_view') OR (na.gid = 118 AND na.realm = 'irperms_view') OR (na.gid = 121 AND na.realm = 'irperms_view') OR (na.gid = 120 AND na.realm = 'irperms_view') OR (na.gid = 129 AND na.realm = 'irperms_view') OR (na.gid = 130 AND na.realm = 'irperms_view') OR (na.gid = 5 AND na.realm = 'irperms_view') OR (na.gid = 131 AND na.realm = 'irperms_view') OR (na.gid = 132 AND na.realm = 'irperms_view') OR (na.gid = 243 AND na.realm = 'irperms_view') OR (na.gid = 122 AND na.realm = 'irperms_view') OR (na.gid = 133 AND na.realm = 'irperms_view') OR (na.gid = 6 AND na.realm = 'irperms_view') OR (na.gid = 134 AND na.realm = 'irperms_view') OR (na.gid = 203 AND na.realm = 'irperms_view') OR (na.gid = 204 AND na.realm = 'irperms_view') OR (na.gid = 99 AND na.realm = 'irperms_view') OR (na.gid = 137 AND na.realm = 'irperms_view') OR (na.gid = 206 AND na.realm = 'irperms_view') OR (na.gid = 135 AND na.realm = 'irperms_view') OR (na.gid = 136 AND na.realm = 'irperms_view') OR (na.gid = 245 AND na.realm = 'irperms_view') OR (na.gid = 198 AND na.realm = 'irperms_view') OR (na.gid = 197 AND na.realm = 'irperms_view') OR (na.gid = 199 AND na.realm = 'irperms_view') OR (na.gid = 189 AND na.realm = 'irperms_view') OR (na.gid = 190 AND na.realm = 'irperms_view') OR (na.gid = 244 AND na.realm = 'irperms_view') OR (na.gid = 241 AND na.realm = 'irperms_view') OR (na.gid = 139 AND na.realm = 'irperms_view') OR (na.gid = 140 AND na.realm = 'irperms_view') OR (na.gid = 49 AND na.realm = 'irperms_view') OR (na.gid = 175 AND na.realm = 'irperms_view') OR (na.gid = 50 AND na.realm = 'irperms_view') OR (na.gid = 79 AND na.realm = 'irperms_view') OR (na.gid = 78 AND na.realm = 'irperms_view') OR (na.gid = 77 AND na.realm = 'irperms_view') OR (na.gid = 76 AND na.realm = 'irperms_view') OR (na.gid = 75 AND na.realm = 'irperms_view') OR (na.gid = 74 AND na.realm = 'irperms_view') OR (na.gid = 73 AND na.realm = 'irperms_view') OR (na.gid = 72 AND na.realm = 'irperms_view') OR (na.gid = 71 AND na.realm = 'irperms_view') OR (na.gid = 70 AND na.realm = 'irperms_view') OR (na.gid = 68 AND na.realm = 'irperms_view') OR (na.gid = 69 AND na.realm = 'irperms_view') OR (na.gid = 66 AND na.realm = 'irperms_view') OR (na.gid = 67 AND na.realm = 'irperms_view') OR (na.gid = 88 AND na.realm = 'irperms_view') OR (na.gid = 89 AND na.realm = 'irperms_view') OR (na.gid = 93 AND na.realm = 'irperms_view') OR (na.gid = 90 AND na.realm = 'irperms_view') OR (na.gid = 87 AND na.realm = 'irperms_view') OR (na.gid = 86 AND na.realm = 'irperms_view') OR (na.gid = 82 AND na.realm = 'irperms_view') OR (na.gid = 91 AND na.realm = 'irperms_view') OR (na.gid = 84 AND na.realm = 'irperms_view') OR (na.gid = 83 AND na.realm = 'irperms_view') OR (na.gid = 92 AND na.realm = 'irperms_view') OR (na.gid = 141 AND na.realm = 'irperms_view') OR (na.gid = 142 AND na.realm = 'irperms_view') OR (na.gid = 223 AND na.realm = 'irperms_view') OR (na.gid = 239 AND na.realm = 'irperms_view') OR (na.gid = 143 AND na.realm = 'irperms_view') OR (na.gid = 144 AND na.realm = 'irperms_view') OR (na.gid = 95 AND na.realm = 'irperms_view') OR (na.gid = 180 AND na.realm = 'irperms_view') OR (na.gid = 181 AND na.realm = 'irperms_view') OR (na.gid = 182 AND na.realm = 'irperms_view') OR (na.gid = 183 AND na.realm = 'irperms_view') OR (na.gid = 184 AND na.realm = 'irperms_view') OR (na.gid = 185 AND na.realm = 'irperms_view') OR (na.gid = 186 AND na.realm = 'irperms_view') OR (na.gid = 187 AND na.realm = 'irperms_view') OR (na.gid = 96 AND na.realm = 'irperms_view') OR (na.gid = 97 AND na.realm = 'irperms_view') OR (na.gid = 145 AND na.realm = 'irperms_view') OR (na.gid = 146 AND na.realm = 'irperms_view') OR (na.gid = 191 AND na.realm = 'irperms_view') OR (na.gid = 192 AND na.realm = 'irperms_view') OR (na.gid = 7 AND na.realm = 'irperms_view') OR (na.gid = 211 AND na.realm = 'irperms_view') OR (na.gid = 212 AND na.realm = 'irperms_view') OR (na.gid = 213 AND na.realm = 'irperms_view') OR (na.gid = 214 AND na.realm = 'irperms_view') OR (na.gid = 215 AND na.realm = 'irperms_view') OR (na.gid = 10 AND na.realm = 'irperms_view') OR (na.gid = 30 AND na.realm = 'irperms_view') OR (na.gid = 31 AND na.realm = 'irperms_view') OR (na.gid = 147 AND na.realm = 'irperms_view') OR (na.gid = 148 AND na.realm = 'irperms_view') OR (na.gid = 216 AND na.realm = 'irperms_view') OR (na.gid = 149 AND na.realm = 'irperms_view') OR (na.gid = 152 AND na.realm = 'irperms_view') OR (na.gid = 47 AND na.realm = 'irperms_view') OR (na.gid = 153 AND na.realm = 'irperms_view') OR (na.gid = 156 AND na.realm = 'irperms_view') OR (na.gid = 154 AND na.realm = 'irperms_view') OR (na.gid = 155 AND na.realm = 'irperms_view') OR (na.gid = 113 AND na.realm = 'irperms_view') OR (na.gid = 157 AND na.realm = 'irperms_view') OR (na.gid = 233 AND na.realm = 'irperms_view') OR (na.gid = 201 AND na.realm = 'irperms_view') OR (na.gid = 202 AND na.realm = 'irperms_view') OR (na.gid = 207 AND na.realm = 'irperms_view') OR (na.gid = 158 AND na.realm = 'irperms_view') OR (na.gid = 159 AND na.realm = 'irperms_view') OR (na.gid = 8 AND na.realm = 'irperms_view') OR (na.gid = 28 AND na.realm = 'irperms_view') OR (na.gid = 235 AND na.realm = 'irperms_view') OR (na.gid = 9 AND na.realm = 'irperms_view') OR (na.gid = 163 AND na.realm = 'irperms_view') OR (na.gid = 177 AND na.realm = 'irperms_view') OR (na.gid = 164 AND na.realm = 'irperms_view') OR (na.gid = 80 AND na.realm = 'irperms_view') OR (na.gid = 165 AND na.realm = 'irperms_view') OR (na.gid = 112 AND na.realm = 'irperms_view') OR (na.gid = 166 AND na.realm = 'irperms_view') OR (na.gid = 161 AND na.realm = 'irperms_view') OR (na.gid = 162 AND na.realm = 'irperms_view') OR (na.gid = 3 AND na.realm = 'irperms_view') OR (na.gid = 23 AND na.realm = 'irperms_view') OR (na.gid = 167 AND na.realm = 'irperms_view') OR (na.gid = 168 AND na.realm = 'irperms_view') OR (na.gid = 169 AND na.realm = 'irperms_view') OR (na.gid = 232 AND na.realm = 'irperms_view') OR (na.gid = 45 AND na.realm = 'irperms_view') OR (na.gid = 12 AND na.realm = 'irperms_view') OR (na.gid = 33 AND na.realm = 'irperms_view') OR (na.gid = 34 AND na.realm = 'irperms_view') OR (na.gid = 234 AND na.realm = 'irperms_view') OR (na.gid = 246 AND na.realm = 'irperms_view') OR (na.gid = 209 AND na.realm = 'irperms_view') OR (na.gid = 208 AND na.realm = 'irperms_view') OR (na.gid = 13 AND na.realm = 'irperms_view') OR (na.gid = 35 AND na.realm = 'irperms_view') OR (na.gid = 81 AND na.realm = 'irperms_view') OR (na.gid = 179 AND na.realm = 'irperms_view') OR (na.gid = 14 AND na.realm = 'irperms_view') OR (na.gid = 221 AND na.realm = 'irperms_view') OR (na.gid = 15 AND na.realm = 'irperms_view') OR (na.gid = 37 AND na.realm = 'irperms_view') OR (na.gid = 194 AND na.realm = 'irperms_view') OR (na.gid = 170 AND na.realm = 'irperms_view') OR (na.gid = 171 AND na.realm = 'irperms_view') OR (na.gid = 220 AND na.realm = 'irperms_view') OR (na.gid = 224 AND na.realm = 'irperms_view') OR (na.gid = 178 AND na.realm = 'irperms_view') OR (na.gid = 172 AND na.realm = 'irperms_view') OR (na.gid = 173 AND na.realm = 'irperms_view') OR (na.gid = 237 AND na.realm = 'irperms_view') OR (na.gid = 200 AND na.realm = 'irperms_view') OR (na.gid = 238 AND na.realm = 'irperms_view') OR (na.gid = 174 AND na.realm = 'irperms_view') OR (na.gid = 193 AND na.realm = 'irperms_view'))) AND (((SELECT COUNT(1) FROM node_access nasq WHERE node.nid=nasq.nid AND gid=0 AND realm='all') > 0) OR ((SELECT COUNT(1) FROM node_access nasq WHERE node.nid=nasq.nid AND realm IN ('irperms_additional_submitter','irperms_additional_author','irperms_view')) = 0 OR (SELECT COUNT(1) FROM node_access nasq WHERE node.nid=nasq.nid AND ((gid=0 AND realm='irperms_additional_submitter') OR (gid=0 AND realm='irperms_additional_author') OR (gid=1 AND realm='irperms_view') OR (gid=17 AND realm='irperms_view') OR (gid=18 AND realm='irperms_view') OR (gid=19 AND realm='irperms_view') OR (gid=20 AND realm='irperms_view') OR (gid=21 AND realm='irperms_view') OR (gid=46 AND realm='irperms_view') OR (gid=218 AND realm='irperms_view') OR (gid=225 AND realm='irperms_view') OR (gid=226 AND realm='irperms_view') OR (gid=227 AND realm='irperms_view') OR (gid=228 AND realm='irperms_view') OR (gid=229 AND realm='irperms_view') OR (gid=230 AND realm='irperms_view') OR (gid=231 AND realm='irperms_view') OR (gid=176 AND realm='irperms_view') OR (gid=2 AND realm='irperms_view') OR (gid=22 AND realm='irperms_view') OR (gid=98 AND realm='irperms_view') OR (gid=124 AND realm='irperms_view') OR (gid=150 AND realm='irperms_view') OR (gid=151 AND realm='irperms_view') OR (gid=195 AND realm='irperms_view') OR (gid=196 AND realm='irperms_view') OR (gid=15 AND realm='irperms_view') OR (gid=205 AND realm='irperms_view') OR (gid=4 AND realm='irperms_view') OR (gid=125 AND realm='irperms_view') OR (gid=126 AND realm='irperms_view') OR (gid=94 AND realm='irperms_view') OR (gid=41 AND realm='irperms_view') OR (gid=43 AND realm='irperms_view') OR (gid=127 AND realm='irperms_view') OR (gid=219 AND realm='irperms_view') OR (gid=123 AND realm='irperms_view') OR (gid=128 AND realm='irperms_view') OR (gid=100 AND realm='irperms_view') OR (gid=101 AND realm='irperms_view') OR (gid=107 AND realm='irperms_view') OR (gid=108 AND realm='irperms_view') OR (gid=105 AND realm='irperms_view') OR (gid=104 AND realm='irperms_view') OR (gid=106 AND realm='irperms_view') OR (gid=102 AND realm='irperms_view') OR (gid=103 AND realm='irperms_view') OR (gid=138 AND realm='irperms_view') OR (gid=114 AND realm='irperms_view') OR (gid=188 AND realm='irperms_view') OR (gid=117 AND realm='irperms_view') OR (gid=115 AND realm='irperms_view') OR (gid=116 AND realm='irperms_view') OR (gid=119 AND realm='irperms_view') OR (gid=118 AND realm='irperms_view') OR (gid=121 AND realm='irperms_view') OR (gid=120 AND realm='irperms_view') OR (gid=129 AND realm='irperms_view') OR (gid=130 AND realm='irperms_view') OR (gid=5 AND realm='irperms_view') OR (gid=131 AND realm='irperms_view') OR (gid=132 AND realm='irperms_view') OR (gid=243 AND realm='irperms_view') OR (gid=122 AND realm='irperms_view') OR (gid=133 AND realm='irperms_view') OR (gid=6 AND realm='irperms_view') OR (gid=134 AND realm='irperms_view') OR (gid=203 AND realm='irperms_view') OR (gid=204 AND realm='irperms_view') OR (gid=99 AND realm='irperms_view') OR (gid=137 AND realm='irperms_view') OR (gid=206 AND realm='irperms_view') OR (gid=135 AND realm='irperms_view') OR (gid=136 AND realm='irperms_view') OR (gid=245 AND realm='irperms_view') OR (gid=198 AND realm='irperms_view') OR (gid=197 AND realm='irperms_view') OR (gid=199 AND realm='irperms_view') OR (gid=189 AND realm='irperms_view') OR (gid=190 AND realm='irperms_view') OR (gid=244 AND realm='irperms_view') OR (gid=241 AND realm='irperms_view') OR (gid=139 AND realm='irperms_view') OR (gid=140 AND realm='irperms_view') OR (gid=49 AND realm='irperms_view') OR (gid=175 AND realm='irperms_view') OR (gid=50 AND realm='irperms_view') OR (gid=79 AND realm='irperms_view') OR (gid=78 AND realm='irperms_view') OR (gid=77 AND realm='irperms_view') OR (gid=76 AND realm='irperms_view') OR (gid=75 AND realm='irperms_view') OR (gid=74 AND realm='irperms_view') OR (gid=73 AND realm='irperms_view') OR (gid=72 AND realm='irperms_view') OR (gid=71 AND realm='irperms_view') OR (gid=70 AND realm='irperms_view') OR (gid=68 AND realm='irperms_view') OR (gid=69 AND realm='irperms_view') OR (gid=66 AND realm='irperms_view') OR (gid=67 AND realm='irperms_view') OR (gid=88 AND realm='irperms_view') OR (gid=89 AND realm='irperms_view') OR (gid=93 AND realm='irperms_view') OR (gid=90 AND realm='irperms_view') OR (gid=87 AND realm='irperms_view') OR (gid=86 AND realm='irperms_view') OR (gid=82 AND realm='irperms_view') OR (gid=91 AND realm='irperms_view') OR (gid=84 AND realm='irperms_view') OR (gid=83 AND realm='irperms_view') OR (gid=92 AND realm='irperms_view') OR (gid=141 AND realm='irperms_view') OR (gid=142 AND realm='irperms_view') OR (gid=223 AND realm='irperms_view') OR (gid=239 AND realm='irperms_view') OR (gid=143 AND realm='irperms_view') OR (gid=144 AND realm='irperms_view') OR (gid=95 AND realm='irperms_view') OR (gid=180 AND realm='irperms_view') OR (gid=181 AND realm='irperms_view') OR (gid=182 AND realm='irperms_view') OR (gid=183 AND realm='irperms_view') OR (gid=184 AND realm='irperms_view') OR (gid=185 AND realm='irperms_view') OR (gid=186 AND realm='irperms_view') OR (gid=187 AND realm='irperms_view') OR (gid=96 AND realm='irperms_view') OR (gid=97 AND realm='irperms_view') OR (gid=145 AND realm='irperms_view') OR (gid=146 AND realm='irperms_view') OR (gid=191 AND realm='irperms_view') OR (gid=192 AND realm='irperms_view') OR (gid=7 AND realm='irperms_view') OR (gid=211 AND realm='irperms_view') OR (gid=212 AND realm='irperms_view') OR (gid=213 AND realm='irperms_view') OR (gid=214 AND realm='irperms_view') OR (gid=215 AND realm='irperms_view') OR (gid=10 AND realm='irperms_view') OR (gid=30 AND realm='irperms_view') OR (gid=31 AND realm='irperms_view') OR (gid=147 AND realm='irperms_view') OR (gid=148 AND realm='irperms_view') OR (gid=216 AND realm='irperms_view') OR (gid=149 AND realm='irperms_view') OR (gid=152 AND realm='irperms_view') OR (gid=47 AND realm='irperms_view') OR (gid=153 AND realm='irperms_view') OR (gid=156 AND realm='irperms_view') OR (gid=154 AND realm='irperms_view') OR (gid=155 AND realm='irperms_view') OR (gid=113 AND realm='irperms_view') OR (gid=157 AND realm='irperms_view') OR (gid=233 AND realm='irperms_view') OR (gid=201 AND realm='irperms_view') OR (gid=202 AND realm='irperms_view') OR (gid=207 AND realm='irperms_view') OR (gid=158 AND realm='irperms_view') OR (gid=159 AND realm='irperms_view') OR (gid=8 AND realm='irperms_view') OR (gid=28 AND realm='irperms_view') OR (gid=235 AND realm='irperms_view') OR (gid=9 AND realm='irperms_view') OR (gid=163 AND realm='irperms_view') OR (gid=177 AND realm='irperms_view') OR (gid=164 AND realm='irperms_view') OR (gid=80 AND realm='irperms_view') OR (gid=165 AND realm='irperms_view') OR (gid=112 AND realm='irperms_view') OR (gid=166 AND realm='irperms_view') OR (gid=161 AND realm='irperms_view') OR (gid=162 AND realm='irperms_view') OR (gid=3 AND realm='irperms_view') OR (gid=23 AND realm='irperms_view') OR (gid=167 AND realm='irperms_view') OR (gid=168 AND realm='irperms_view') OR (gid=169 AND realm='irperms_view') OR (gid=232 AND realm='irperms_view') OR (gid=45 AND realm='irperms_view') OR (gid=12 AND realm='irperms_view') OR (gid=33 AND realm='irperms_view') OR (gid=34 AND realm='irperms_view') OR (gid=234 AND realm='irperms_view') OR (gid=246 AND realm='irperms_view') OR (gid=209 AND realm='irperms_view') OR (gid=208 AND realm='irperms_view') OR (gid=13 AND realm='irperms_view') OR (gid=35 AND realm='irperms_view') OR (gid=81 AND realm='irperms_view') OR (gid=179 AND realm='irperms_view') OR (gid=14 AND realm='irperms_view') OR (gid=221 AND realm='irperms_view') OR (gid=15 AND realm='irperms_view') OR (gid=37 AND realm='irperms_view') OR (gid=194 AND realm='irperms_view') OR (gid=170 AND realm='irperms_view') OR (gid=171 AND realm='irperms_view') OR (gid=220 AND realm='irperms_view') OR (gid=224 AND realm='irperms_view') OR (gid=178 AND realm='irperms_view') OR (gid=172 AND realm='irperms_view') OR (gid=173 AND realm='irperms_view') OR (gid=237 AND realm='irperms_view') OR (gid=200 AND realm='irperms_view') OR (gid=238 AND realm='irperms_view') OR (gid=174 AND realm='irperms_view') OR (gid=193 AND realm='irperms_view'))) > 0)) AND ( node.type in ('author_page') )ORDER BY unknown ASC LIMIT 0, 20 in /mnt/u1/var/www/html/sites/default/modules/views/includes/view.inc on line 807.