Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT r.requestid, r.fn, r.ln, r.adr, r.city, r.state, r.email, r.zip, r.country, r.send_info, r.processed FROM retrouvaille.request r, retrouvaille.program_dates pd, retrouvaille.admin_users au, retrouvaille.communities c WHERE r.pdid = pd.pdid AND pd.commid = au.commid AND pd.commid=c.commid AND c.region='Central' AND r.processed = 'N' AND pd_status='1' ORDER BY r.processed, r.requestid limit 50;
- +-----------+--------------------+------------+------------------------------+----------------+-------+------------------------------+-------+---------+-------------+-----------+
- | requestid | fn | ln | adr | city | state | email | zip | country | send_info | processed |
- +-----------+--------------------+------------+------------------------------+----------------+-------+------------------------------+-------+---------+-------------+-----------+
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 38 | carey | roussel | 1 muirfield dr | laplace | LA | cjr109@aol.com | 70068 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 161 | Melissa | Knaps | 25943 Richmond S. Ridge Ave. | Denham Springs | LA | knapsm@bellsouth.net | 70726 | USA | Email | N |
- | 199 | Jackie and Francis | Reed | 872 Le Bois Darc | VillePlatte | LA | | 70586 | USA | Postal Mail | N |
- | 199 | Jackie and Francis | Reed | 872 Le Bois Darc | VillePlatte | LA | | 70586 | USA | Postal Mail | N |
- | 199 | Jackie and Francis | Reed | 872 Le Bois Darc | VillePlatte | LA | | 70586 | USA | Postal Mail | N |
- | 199 | Jackie and Francis | Reed | 872 Le Bois Darc | VillePlatte | LA | | 70586 | USA | Postal Mail | N |
- | 199 | Jackie and Francis | Reed | 872 Le Bois Darc | VillePlatte | LA | | 70586 | USA | Postal Mail | N |
- | 199 | Jackie and Francis | Reed | 872 Le Bois Darc | VillePlatte | LA | | 70586 | USA | Postal Mail | N |
- | 199 | Jackie and Francis | Reed | 872 Le Bois Darc | VillePlatte | LA | | 70586 | USA | Postal Mail | N |
- | 199 | Jackie and Francis | Reed | 872 Le Bois Darc | VillePlatte | LA | | 70586 | USA | Postal Mail | N |
Add Comment
Please, Sign In to add comment