fas2=# select p.username, p.human_name, r.creation, r.approval from people as p, person_roles as r where group_id in (101440, 101777, 101441, 101443, 1112) and role_status = 'approved' and r.person_id = p.id and person_id not in (select r.person_id from person_roles as r where group_id = 100002 and role_status = 'approved'); username | human_name | creation | approval ---------------+------------------------------------+--------------------------- ----+------------------------------- marius | Marius Andreiana | 2008-03-12 02:01:33.288266 +00 | fedorasy | System User | 2008-03-12 02:03:11.63574+ 00 | brilong | Brian D. Long | 2008-03-12 02:03:19.123804 +00 | indpunj | Inder Punj | 2008-03-12 02:03:48.585801 +00 | tazz | Marcel Berlau | 2008-03-12 02:03:49.272831 +00 | gimre | Imre Gergely | 2008-03-12 02:03:50.212936 +00 | dls | Donald Lawrence Sizemore II | 2008-03-12 02:03:50.249391 +00 | rzm | Rafał Maszkowski | 2008-03-12 02:03:50.427211 +00 | chemaja | Billy Coutsis | 2008-03-12 02:03:50.633128 +00 | pontusf | Pontus Freyhult | 2008-03-12 02:03:51.796203 +00 | jcvw | Jan Christiaan van Winkel | 2008-03-12 02:03:51.8307+0 0 | aliu | Antoine Liu | 2008-03-12 02:03:51.862929 +00 | bcornec | Bruno Cornec | 2008-03-12 02:03:52.007437 +00 | darkmoon | Dave Martin | 2008-03-12 02:03:52.053268 +00 | srojas | Sergio Jorge Rojas Hernandez | 2008-03-12 02:03:52.456004 +00 | suroot | Joshua Backfield | 2008-03-12 02:03:53.100944 +00 | chico | Francisco Lima Viana | 2008-03-12 02:03:53.345435 +00 | tiantian | Tianshixiong | 2008-03-12 02:03:56.239066 +00 | bhanu | Bhanu Pratap Singh Patial | 2008-03-12 02:03:57.998356 +00 | genetics | Anis Farhana | 2008-03-12 02:03:58.048066 +00 | ezigler | Erich Zigler | 2008-03-12 02:03:59.061742 +00 | pierre | Hourdebaigt | 2008-03-12 02:04:00.482606 +00 | yggdrasi | Mathieu Schopfer | 2008-03-12 02:04:00.512982 +00 | manu928 | emmanuel | 2008-03-12 02:04:01.473094 +00 | neodns | David Santerre Bissonnette | 2008-03-12 02:04:02.273679 +00 | woaibobo | Zhang Bo | 2008-03-12 02:04:02.764426 +00 | karneval | Karneval | 2008-03-12 02:04:02.798643 +00 | niceguy | Animesh Saxena | 2008-03-12 02:04:03.055313 +00 | pat | Patryk Malina | 2008-03-12 02:04:03.520644 +00 | msk61 | Mohammed Safwat Kamel El-Afifi | 2008-03-12 02:04:03.618191 +00 | german | Germán Aliprandi | 2008-03-12 02:04:04.528685 +00 | tvenkatt | Venkatesan Thangaraj | 2008-03-12 02:04:05.238102 +00 | clfrnacw | Andrew Joseph Bosch | 2008-03-12 02:04:05.849627 +00 | weberg | Greg Weber | 2008-03-12 02:04:05.880115 +00 | mwilby | Matt Wilby | 2008-03-12 02:04:05.910594 +00 | jlebouef | Jason LeBouef | 2008-03-12 02:04:06.645609 +00 | kahlilp | kahlil s. pena | 2008-03-12 02:04:07.617527 +00 | minto | Minto | 2008-03-12 02:04:08.634112 +00 | balajig8 | Balaji G | 2008-03-12 02:04:08.707947 +00 | dantas72 | fernando medeiros dantas | 2008-03-12 02:04:08.742913 +00 | zgansert | Z. Gansert | 2008-03-12 02:04:08.84487+ 00 | besnik | Besnik Bleta | 2008-03-12 02:04:09.282759 +00 | heanet | Rob Gallagher | 2008-03-12 02:04:09.970651 +00 | alfonsdg | Alfonso de la Guarda Reyes | 2008-03-12 02:04:11.002808 +00 | edgar | Edgar Alberto Molina Rojas | 2008-03-12 02:04:11.044176 +00 | gsm1011 | gsmsteve | 2008-03-12 02:04:11.208987 +00 | zrevai | Zane B Revai | 2008-03-12 02:04:11.78297+ 00 | keiran | Keiran Smith | 2008-03-12 02:04:11.938889 +00 | pyrox | Keiran Smith | 2008-03-12 02:04:12.365041 +00 | bryguy30 | Bryan Jones | 2008-03-12 02:04:12.39513+ 00 | bert | Bert Freudenberg | 2008-03-12 02:04:12.545078 +00 | phani | VEMI REDDY PHANI BHUSHAN REDDY | 2008-03-12 02:04:13.163863 +00 | whomp | Priyank Pratap Raghuvanshi | 2008-03-12 02:04:14.418295 +00 | rduenasp | Ricardo Dueñas Parada | 2008-03-12 02:04:14.579144 +00 | sals | Salil | 2008-03-12 02:04:15.515643 +00 | jbouma | John Bouma | 2008-03-12 02:04:15.544728 +00 | niranjan | Mallapadi Raghavendra Rao Niranjan | 2008-03-12 02:04:16.240566 +00 | freewill | Mallapadi Raghavendra Rao Niranjan | 2008-03-12 02:04:16.433431 +00 | ashok | Niranjan | 2008-03-12 02:04:16.792907 +00 | kylezk | 张奎 | 2008-03-12 02:04:18.443765 +00 | david | 张奎 | 2008-03-12 02:04:18.47817+ 00 | zhangkui | zhangkui | 2008-03-12 02:04:18.509588 +00 | kernell | kernell | 2008-03-12 02:04:18.545734 +00 | kekegg | Zhengwei Xie | 2008-03-12 02:04:20.916584 +00 | wygtya | Christopher Jay Wells | 2008-03-12 02:04:21.360108 +00 | ypan | ypan | 2008-03-12 02:04:21.689941 +00 | daavery | david avery | 2008-03-12 02:04:22.057333 +00 | naveen | Naveen Chandran V | 2008-03-12 02:04:22.674038 +00 | stavlor | Paul Andrel | 2008-03-12 02:04:22.703414 +00 | bluebat | Wei-Lun Chao | 2008-03-12 02:04:23.323824 +00 | rafaelma | Rafael Antonio Márquez Castro | 2008-03-12 02:04:23.358287 +00 | geek | Larry Letelier | 2008-03-12 02:04:24.342205 +00 | mkhan01 | mohammed khan | 2008-03-12 02:04:25.330515 +00 | betobech | Roberto M Bechtlufft | 2008-03-12 02:04:27.530078 +00 | feravolo | Mike Feravolo | 2008-03-12 02:04:27.95765+ 00 | nbaster | ahmed moro | 2008-03-12 02:04:29.415596 +00 | dmb | Gandemberel Gantumur | 2008-03-12 02:04:30.388802 +00 | ichtus | Lewi Supranata Kristianto | 2008-03-12 02:04:31.248361 +00 | ajoseph | Antony P Joseph | 2008-03-12 02:04:31.380011 +00 | joeljose | Joel Jose | 2008-03-12 02:04:31.48054+ 00 | jsodini | James Sodini | 2008-03-12 02:04:32.091121 +00 | sodini | James Sodini | 2008-03-12 02:04:32.126769 +00 | macky | Michal Mackanic | 2008-03-12 02:04:32.485365 +00 | kjaer | Kresten Kjaer | 2008-03-12 02:04:32.624558 +00 | skorp | sandeep kumar | 2008-03-12 02:04:34.45482+ 00 | rohit | Rohit Baisakhiya | 2008-03-12 02:04:34.604623 +00 | laf163 | Aifu Liu | 2008-03-12 02:04:35.067964 +00 | mikkey | Mihcael Rybakov | 2008-03-12 02:04:35.10287+ 00 | tuxgeek | Roopesh | 2008-03-12 02:04:35.781113 +00 | adarsh | Adarsh Bhardwaj | 2008-03-12 02:04:36.964765 +00 | fredl | Frederic Lepied | 2008-03-12 02:04:37.220089 +00 | ianzepp | Ian Zepp | 2008-03-12 02:04:38.108291 +00 | spike910 | Daniel Elphinstone | 2008-03-12 02:04:39.201268 +00 | aberoham | Abraham Ingersoll | 2008-03-12 02:04:39.649931 +00 | mkoci | Koci Martin | 2008-03-12 02:04:41.778854 +00 | hackers1 | KHAIRUL ADI JOHARI | 2008-03-12 02:04:42.989604 +00 | theyaga | Theyagarajan S | 2008-03-12 02:04:43.213538 +00 | kruvali1 | ValeriyKruchko | 2008-03-12 02:04:43.417184 +00 | akubra | Ben Caldwell | 2008-03-12 02:04:44.168581 +00 | myang | Bill Yang | 2008-03-12 02:04:45.232765 +00 | peher | Patrick Richard | 2008-03-12 02:04:45.970622 +00 | mccun934 | Mike McCune | 2008-03-12 02:04:46.088655 +00 | wxf514 | Feng W | 2008-03-12 02:04:46.537471 +00 | jcrim | Joseph Crim | 2008-03-12 02:04:47.236898 +00 | mantas | Mantas Kriaučiūnas | 2008-03-12 02:04:47.644409 +00 | slot | Weston Blake Miller | 2008-03-12 02:04:48.317934 +00 | chararas | Nikos Chararas | 2008-03-12 02:04:48.64199+ 00 | ramkrsna | Ramakrishna Reddy | 2008-03-12 02:04:49.99781+ 00 | mudassir | mudassir shabbir | 2008-03-12 02:04:50.113174 +00 | rdioactv | Nick Piacentine | 2008-03-12 02:04:51.151858 +00 | darkshee | YOURAN | 2008-03-12 02:04:51.454146 +00 | antick | Mike Uharriet | 2008-03-12 02:04:51.592004 +00 | rmizuuti | Roberto Mizuuti Junior | 2008-03-12 02:04:51.701245 +00 | claudemi | Claudemir Pessoa da Luz Júnior | 2008-03-12 02:04:51.736792 +00 | ljgwt | Liang Jianguo | 2008-03-12 02:04:52.832676 +00 | adrianr | Adrian Raduti | 2008-03-12 02:04:52.869338 +00 | psytux | Juan Alejandro Rodriguez Parra | 2008-03-12 02:04:54.680719 +00 | thameur | Thameur BELGHITH | 2008-03-12 02:04:57.553975 +00 | jaclin | Jacquelin Charbonnel | 2008-03-12 02:04:58.177756 +00 | joshihim | Himanshu Joshi | 2008-03-12 02:04:59.808213 +00 | xhuang | Xi HUANG | 2008-03-12 02:04:59.84336+ 00 | shams | shamsurrahman | 2008-03-12 02:05:01.152715 +00 | eidast | Alexander Moreno Delgado | 2008-03-12 02:05:02.242241 +00 | centauri | Joshua Coleman | 2008-03-12 02:05:02.338553 +00 | mohdomar | Omar Mohammed | 2008-03-12 02:05:02.523959 +00 | groupsky | Geno Roupsky | 2008-03-12 02:05:04.121433 +00 | natacha | Shengyi Chan | 2008-03-12 02:05:04.157166 +00 | ericf | Eric Michael Faccer | 2008-03-12 02:05:04.769239 +00 | litie | Andrea Modesto Rossi | 2008-03-12 02:05:05.404895 +00 | zelut | Christer Edwards | 2008-03-12 02:05:09.656535 +00 | chet | Chet Nichols III | 2008-03-12 02:05:10.685458 +00 | ravindra | malla ravindra aditya | 2008-03-12 02:05:11.768657 +00 | adam | Adam G.F. Cooper | 2008-03-12 02:05:11.894308 +00 | tcicon | Christopher A. Parker | 2008-03-12 02:05:11.930364 +00 | aditya | malla ravindra aditya | 2008-03-12 02:05:11.965717 +00 | jyothi | M.R.ADITYA | 2008-03-12 02:05:12.030492 +00 | malla | Malla Ravindra Aditya | 2008-03-12 02:05:12.173906 +00 | danfuhry | Dan Fuhry | 2008-03-12 02:05:12.460606 +00 | sgarrity | Steven Garrity | 2008-03-12 02:05:12.60397+ 00 | bymyself | Ballout Merouen | 2008-03-12 02:05:12.785332 +00 | xelno | Sicheng PAN | 2008-03-12 02:05:12.822431 +00 | ujjwol | Ujjwol Lamichhane | 2008-03-12 02:05:12.934236 +00 | gpellini | Guillermo Pellini | 2008-03-12 02:05:13.062593 +00 | mhalaba | Mateusz Łukasz Halaba | 2008-03-12 02:05:13.105644 +00 | kiran | Kiran.V | 2008-03-12 02:05:13.379793 +00 | tieugene | Eugene A. Pivnev | 2008-03-12 02:05:13.417167 +00 | jwakely | Jonathan Wakely | 2008-03-12 02:05:13.452638 +00 | titi201 | Quentin DESCOURS | 2008-03-12 02:05:14.16976+ 00 | geekhite | hitesh kumar | 2008-03-12 02:05:15.040279 +00 | vinie | Jin Yixin | 2008-03-12 02:05:15.23862+ 00 | rileym3 | Riley F. Marquis III | 2008-03-12 02:05:15.393141 +00 | alaporte | Alberto Laporte | 2008-03-12 02:05:16.780932 +00 | chas | Charles McColm | 2008-03-12 02:05:16.919031 +00 | jmccann | William Jon McCann | 2008-03-12 02:05:17.169922 +00 | chenrano2002 | Ray Chen | 2008-03-12 02:05:17.766069 +00 | utnet | UTnet | 2008-03-12 02:05:18.178738 +00 | kingsley | kingsley onokalah | 2008-03-12 02:05:19.547663 +00 | al7qs | Doug McBournie | 2008-03-12 02:05:20.639944 +00 | jwildeboer | Jan Wildeboer | 2008-03-12 02:05:20.816127 +00 | weifeng | Weifeng Jiang | 2008-03-12 02:05:21.72147+ 00 | vmnrajesh | Rajesh Verma | 2008-03-12 02:05:22.114934 +00 | mtomic | Miroslav Tomic | 2008-03-12 02:05:22.148916 +00 | rvbabilonia | Rey Vincent Babilonia | 2008-03-12 02:05:22.252815 +00 | jaymeayres | Jayme Ayres | 2008-03-12 02:05:22.499995 +00 | rsuehle | Ruth Suehle | 2008-03-12 02:05:22.63504+ 00 | sshaw | Steve Shaw | 2008-03-12 02:05:23.432751 +00 | ram | RAVINDRA ADITYA MALLA | 2008-03-12 02:05:23.568065 +00 | amateur | Floyd Arguello | 2008-03-12 02:05:23.667453 +00 | shahsaifi | Shahnawaz Saifi | 2008-03-12 02:05:24.511125 +00 | gildo | Ermenegildo Fiorito | 2008-03-12 02:05:25.540338 +00 | fedocmtl | Octavio Omero Hernandez Sibaja | 2008-03-12 02:05:25.713271 +00 | dansguardian | Dansguardian | 2008-03-12 02:05:26.321922 +00 | ronny | Ronny Buchmann | 2008-03-12 02:05:27.419984 +00 | vidurmittal | Vidur Mittal | 2008-03-12 02:05:27.793446 +00 | dichi | Dichi Al Faridi | 2008-03-12 02:05:28.245634 +00 | lifo | Sebastien COUREAU | 2008-03-12 02:05:28.451477 +00 | leozh | Leo Zhadanovsky | 2008-03-12 02:05:28.531343 +00 | vjalali | vahid jalali | 2008-03-12 02:05:29.303466 +00 | pmcnutt | Percy Fernando Mc Nutt Marin | 2008-03-12 02:05:29.77458+ 00 | tiagozacarias | Tiago Eduardo Zacarias | 2008-03-12 02:05:29.80904+ 00 | insane | Alok Mandavgane | 2008-03-12 02:05:29.912809 +00 | interrupt | Valentyn Chub | 2008-03-12 02:05:29.949117 +00 | aaryo | Antonius Aryo | 2008-03-12 02:05:30.594092 +00 | sunilghai | Sunil Kumar Ghai | 2008-03-12 02:05:30.626081 +00 | sunilkghai | Sunil Kumar Ghai | 2008-03-12 02:05:30.660614 +00 | sunilkmrghai | Sunil Kumar Ghai | 2008-03-12 02:05:30.692369 +00 | vikilive | Vignesh | 2008-03-12 02:05:30.98655+ 00 | nivashkumar | Nivash Kumar | 2008-03-12 02:05:31.017812 +00 | consoleart | JaiGanesh Srinivasan | 2008-03-12 02:05:31.55732+ 00 | shehzaad | Shehzaad Nakhoda | 2008-03-12 02:05:31.856936 +00 | stronghill | stronghill | 2008-03-12 02:05:32.577126 +00 | x0wl | x0wl Klingon | 2008-03-12 02:05:32.62117+ 00 | randy | Rondeau Matthieu | 2008-03-12 02:05:32.658476 +00 | admin | Admin User | 2008-03-12 02:01:04.054921 +00 | 2005-04-13 02:03:09.927697+00 mikewaters | Mike Waters | 2008-03-13 16:14:44.382617 +00 | 2008-03-13 16:14:15.726056+00 edsall | David Edsall | 2008-03-13 17:29:52.555475 +00 | 2008-03-13 17:29:22.691962+00