Live DB: pacemission
Dev DB: pacemissiondev
| Data table (pkey) | CGI | column: distinct values |
|---|---|---|
| acronyms (acrId) | acronyms.cgi | |
| assets (assetId) | ||
| authorDocs (authorId) | people.cgi | |
| authorPubs (authorId) | people.cgi | |
| blog (blogId) | blog.cgi | |
| blogAuthors (authorId) | blog.cgi | |
| brochures (brochureId) | gallery.cgi | |
| clips (clipId) | learn-more.cgi | |
| cmsEntry (cmsId) | [original cms code?] | |
| contentLocs ( | ||
| coPIs (copId) | people.cgi, science_applications_team.cgi, st02a.cgi, st02.cgi | |
| documents (docId) | home.cgi, campaigns.cgi, people.cgi, documents.cgi, documents_more.cgi, learn_documents.cgi, science.cgi, sci_meeting_documents.cgi |
type: document, e-brochure gallery: {none}, Y, N category: meeting, report, outreach, memo, presentation, atdb, ... |
| eaCoPIs (copId) | people_ea.cgi | |
| eaDopter (propId) | app_adopters.cgi, people.cgi, people_ea.cgi | |
| eaMedia (mediaId) | people.cgi, people_ea.cgi | |
| eaQuestions (questionId) | app_matrix.cgi | |
| eaTable (tableId) | app_matrix.cgi | |
| events (id) | app_involved.cgi, events.cgi, events_more.cgi | |
| faq_categories (categoryId) | faqs.cgi | |
| faqs (faqsId) | faqs.cgi, faqs_more.cgi, learn_color.cgi, learn_aerosols_clouds.cgi, learn_ecology.cgi, learn_instruments.cgi | |
| faqs_learn (learnId) | learn_color.cgi, learn_aerosols_clouds.cgi, learn_ecology.cg, learn_instruments.cgii | |
| foo | ||
| journals (journalId) | ||
| learn (learnId) | learn_aerosols_clouds.cgi, learn_ecology.cgi, learn_instruments.cgi, learn_list.cgi, learn_color.cgi, learn_more.cgi, learn_thematic.cgi | |
| media (mediaId) | home.cgi, campaigns.cgi, e-brochures.cgi, gallery.cgi, gallery_more.cgi, imageDescription.cgi, media_more.cgi, meet_more.cgi, science.cgi, slideshow_gallery.cgi, slideshow_more.cgi, storymaps.cgi | |
| media_first_light (id) | gallery_first_light.cgi, storymaps.cgi | |
| media_ocean_color< (mediaId)/td> | ocean_color_gallery.cgi, ocean_color_more.cgi | |
| media_ocean_color_categories (catId) | ||
| meetings (meetId) | documents.cgi, sci_meeting_documents.cgi, science_applications_team.cgi, science_meeting.cgi, st02.cgi | |
| news (newsId) | home.cgi, news.cgi, news_more.cgi | |
| people (peopleId) | app_adopters.cgi, app_team.cgi, app_matrix.cgi, mission_devteam.cgi, people.cgi, people_ea.cgi, science_applications_team.cgi, science_team.cgi, st01.cgi, st02a.cgi, st02.cgi | |
| phytoQuiz (quizId) | phyto_quiz_badge.cgi | |
| product_categories (categoryId) | data.cgi, data_table.cgi | |
| products (productId) | data.cgi, data_table.cgi | |
| proposals (propId) | people.cgi, science_applications_team.cgi, science_team.cgi, st01.cgi. st02a.cgi, st02.cgi | |
| publications (pubId) | publications.cgi, publication_more.cgi, publications_st.cgi, people.cgi |
fund: {none}, F, T gallery: {none}, F, T category, combinations of: aerosols, color, clouds, mission, polarimetry, st01 |
| requirements (reqId) | ||
| requirements_categories (categoryId) | ||
| rotators (id) | home.cgi | |
| shows (showId) | slideshow_gallery.cgi, slideshow_more.cgi | |
| slides (slideId) | campaigns.cgi, gallery.cgi, slideshow_gallery.cgi, science.cgi, slideshow_more.cgi | |
| tags (tagId) | publications.cgi |
page: publications, app_adopters
tag: color, mission, aerosols, clouds, polarimetry, st01, water, climate, disasters, air, ecological |
| updates (newsId) | ||
| users (adminId) | [original PHP cms] | |
| whatsNew (whatsNewId) | home.cgi |
The "static pages" still need to connect to the DB in order to fetch the "Last Updated" date for the footer on all pages.
| CGI | SQL |
|---|---|
| about.cgi | -- |
| acronyms.cgi | SELECT * FROM acronyms WHERE ORDER BY acronym |
| aerosol_quiz.cgi | -- |
| air_down_there.cgi | -- |
| app_adopters.cgi |
SELECT * FROM eaDopter WHERE propId != '16' ORDER BY sortOrder
SELECT * FROM people WHERE peopleId = '$peopleId' SELECT * FROM tags WHERE page = 'app_adopters' ORDER BY name SELECT * FROM eaDopter WHERE category LIKE '%$tag%' ORDER BY sortOrder SELECT * FROM eaDopter WHERE category LIKE '%$tag%' ORDER BY $orderBy |
| app_brochure.cgi | -- |
| app_community.cgi | -- |
| app_community_focus.cgi | -- |
| app_contact.cgi | -- |
| app_CoP.cgi | -- |
| app_involved.cgi | SELECT * FROM events WHERE category LIKE '%app%' ORDER BY endDate DESC |
| applications.cgi | -- |
| app_matrix.cgi |
SELECT * FROM eaQuestions SELECT * FROM eaTable WHERE panel = 'panel01' SELECT * FROM eaTable WHERE panel = 'panel02' SELECT * FROM eaTable WHERE panel = 'panel03' SELECT * FROM eaTable WHERE panel = 'panel04' SELECT * FROM eaTable WHERE panel = 'panel05' SELECT * FROM eaTable WHERE panel = 'panel06' SELECT * FROM eaTable WHERE panel = 'panel07' SELECT * FROM eaTable WHERE panel = 'panel08' SELECT * FROM eaTable WHERE panel = 'panel09' SELECT * FROM eaTable WHERE panel = 'panel10' SELECT * FROM eaTable WHERE panel = 'panel11' SELECT * FROM eaTable WHERE panel = 'panel12' SELECT * FROM eaQuestions WHERE questionId=$questionId SELECT * FROM people WHERE peopleId=$peopleId |
| app_team.cgi | SELECT * FROM people WHERE category LIKE '%applications%' ORDER BY sortApp |
| app_workshops_02.cgi | -- |
| app_workshops.cgi | -- |
| atmospheric_sci_focus_session.cgi | -- |
| blog.cgi |
SELECT `b`.`blogId`, `b`.`title`, `b`.`intro`, `b`.`longDesc`, `b`.`sideBar`, UNIX_TIMESTAMP(`b`.`date`) AS date_ts, YEAR(date) AS year,
DATE_FORMAT(date, '%W, %M %e, %Y') AS formatted_date, `b`.`time`, `a`.`name`, `a`.`email`, `a`.`url`
FROM blog AS b, blogAuthors AS a WHERE a.authorId = b.authorId ORDER BY date DESC LIMIT 1;
SELECT `b`.`blogId`, `b`.`title`, `b`.`intro`, `b`.`longDesc`, `b`.`sideBar`, UNIX_TIMESTAMP(`b`.`date`) AS date_ts, YEAR(date) AS year, DATE_FORMAT(date, '%W, %M %e, %Y') AS formatted_date, `b`.`time`, `a`.`name`, `a`.`email`, `a`.`url` FROM blog AS b, blogAuthors AS a WHERE a.authorId = b.authorId AND blogId = $id; SELECT blogId, UNIX_TIMESTAMP(date) AS date_ts FROM blog ORDER BY date; |
| campaigns.cgi |
SELECT * FROM slides WHERE showId='11' and orderCampaign != '0' ORDER BY orderCampaign
SELECT * FROM slides WHERE showId='17' ORDER BY orderCampaign DESC; SELECT * FROM media WHERE mediaId=$mediaId; SELECT * FROM documents WHERE docId=$docId; SELECT * FROM slides WHERE showId='12' and orderCampaign != '0' ORDER BY orderCampaign SELECT * FROM media WHERE mediaId=$mediaId; SELECT * FROM documents WHERE docId=$docId; SELECT * FROM slides WHERE showId='13' and orderCampaign != '0' ORDER BY orderCampaign SELECT * FROM media WHERE mediaId=$mediaId; SELECT * FROM documents WHERE docId=$docId; SELECT * FROM slides WHERE showId='9' and orderCampaign != '0' ORDER BY orderCampaign SELECT * FROM media WHERE mediaId=$mediaId; SELECT * FROM documents WHERE docId=$docId; SELECT * FROM slides WHERE showId='1' and orderCampaign != '0' ORDER BY orderCampaign SELECT * FROM media WHERE mediaId=$mediaId; SELECT * FROM documents WHERE docId=$docId; SELECT * FROM slides WHERE showId='2' and orderCampaign != '0' ORDER BY orderCampaign SELECT * FROM media WHERE mediaId=$mediaId; SELECT * FROM documents WHERE docId=$docId; SELECT * FROM slides WHERE showId='3' and orderCampaign != '0' ORDER BY orderCampaign SELECT * FROM media WHERE mediaId=$mediaId; SELECT * FROM documents WHERE docId=$docId; |
| carbon_cycle.cgi | -- |
| color_determination.cgi | -- |
| colorful_world.cgi | -- |
| contact_applications.cgi | -- |
| data.cgi |
SELECT * FROM product_categories ORDER BY galleryOrder
SELECT * FROM products WHERE category = '$categoryId' SELECT * FROM products WHERE category = '1' SELECT * FROM products WHERE category = '4' SELECT * FROM products WHERE category = '8' SELECT * FROM products WHERE category = '2' SELECT * FROM products WHERE category = '5' SELECT * FROM products WHERE category = '6' SELECT * FROM products WHERE category = '3' SELECT * FROM products WHERE category = '7' |
| data_table.cgi |
SELECT * FROM product_categories ORDER BY tableOrder;
SELECT * FROM product_categories ORDER BY tableOrder; SELECT * FROM products WHERE category = '$categoryId'; |
| documents.cgi |
SELECT * FROM documents WHERE type = 'document' AND gallery = 'Y' AND category !='outreach';
SELECT * FROM documents WHERE (type = 'document' AND gallery = 'Y' AND category !='outreach') ORDER BY dateAdded DESC; SELECT * FROM meetings ORDER BY dateAdded DESC; SELECT * FROM documents WHERE category LIKE '%$category%'; SELECT * FROM documents WHERE (type = 'document' AND gallery = 'Y' AND category != 'outreach') ORDER BY $orderBy; SELECT * FROM meetings ORDER BY dateAdded DESC; SELECT * FROM documents WHERE category LIKE '%$category%'; SELECT * FROM documents WHERE category LIKE '%memo%' AND gallery = 'Y'; SELECT * FROM documents WHERE type = 'document' AND category LIKE '%presentation%' AND gallery = 'Y'; SELECT * FROM documents WHERE type = 'document' AND category LIKE '%report%' AND gallery = 'Y'; SELECT * FROM documents WHERE type = 'document' AND category LIKE '%atbd%' AND gallery = 'Y'; SELECT * FROM documents WHERE type = 'document' AND category LIKE '%$id%' AND gallery = 'Y' ORDER BY dateAdded DESC; SELECT * FROM meetings ORDER BY dateAdded DESC; SELECT * FROM documents WHERE category LIKE '%$category%'; SELECT * FROM documents WHERE type = 'document' AND category LIKE '%$id%' AND gallery = 'Y' ORDER BY $orderBy; SELECT * FROM meetings ORDER BY dateAdded DESC; SELECT * FROM documents WHERE category LIKE '%$category%'; |
| documents_more.cgi | SELECT * FROM documents WHERE docId = '$id'; |
| e-brochures.cgi | SELECT * FROM media WHERE mediaId = '$id'; |
| events.cgi |
SELECT count(eventId) AS futureEvent FROM events WHERE gallery = 'T' AND date > NOW();
SELECT count(eventId) AS pastEvent FROM events WHERE gallery = 'T' AND date <= NOW(); SELECT * FROM events WHERE gallery = 'T' AND date > NOW() ORDER BY date; SELECT * FROM events WHERE gallery = 'T' AND date <= NOW() ORDER BY date DESC; |
| events_appw.cgi | -- |
| events_more.cgi | SELECT * FROM events WHERE eventId='$id'; |
| events_oci_webinar.cgi | -- |
| faqs.cgi |
SELECT * FROM faq_categories ORDER BY sortOrder;
SELECT * FROM faqs WHERE category = '$abbTitle' ORDER BY listOrder; |
| faqs_more.cgi | SELECT * FROM faqs WHERE faqsId='$id' |
| features.cgi | -- |
| gallery.cgi |
SELECT count(`mediaId`) FROM media WHERE gallery = 'Y' AND `type` IN ('image', 'video', 'podcast', 'e-brochure', 'brochure', 'coloring', 'storymap', 'show');
SELECT * FROM media WHERE gallery = 'Y' AND `type` IN ('image', 'video', 'podcast', 'e-brochure', 'brochure', 'coloring', 'storymap', 'show') ORDER BY dateAdded DESC,sort"; SELECT * FROM media WHERE gallery = 'Y' AND `type` IN ('image', 'video', 'podcast', 'e-brochure', 'brochure', 'coloring', 'storymap', 'show') ORDER BY $orderBy; SELECT * FROM media WHERE type = 'image' AND gallery = 'Y'; SELECT * FROM media WHERE type = 'video' AND gallery = 'Y'; SELECT * FROM media WHERE type = 'podcast' AND gallery = 'Y'; SELECT * FROM media WHERE type in ('storymap', 'e-brochure') AND gallery = 'Y'; SELECT * FROM media WHERE type = 'coloring' AND gallery = 'Y'; SELECT * FROM media WHERE type = 'show' AND gallery = 'Y'; SELECT * FROM media WHERE ((type = 'brochure' AND gallery = 'Y') OR (category = 'outreach, brochure' AND gallery = 'Y')); SELECT * FROM brochures ORDER BY dateAdded DESC,sortOrder; SELECT * FROM media WHERE mediaId = '$mediaId'; SELECT * FROM media WHERE type = '$id' AND gallery = 'Y' ORDER BY dateAdded DESC,sort; SELECT * FROM media WHERE $filter AND gallery = 'Y' ORDER BY dateAdded DESC,sort SELECT * FROM brochures ORDER BY $orderBy; SELECT * FROM media WHERE mediaId=$mediaId; SELECT * FROM media WHERE type = '$id' AND gallery = 'Y' ORDER BY $orderBy; SELECT * FROM media WHERE $filter AND gallery = 'Y' ORDER BY $orderBy; |
| gallery_more.cgi | SELECT * FROM media WHERE mediaId='$id'; |
| harp2.cgi | -- |
| home.cgi |
SELECT COUNT(*) FROM rotators WHERE showName='home';
SELECT longTitle,caption,imageLarge,altTag,url FROM rotators WHERE showName='home' ORDER BY slideOrder; SELECT * FROM whatsNew WHERE visible = 'Y' ORDER BY sortOrder DESC LIMIT 6 SELECT * FROM news ORDER BY dateAdded DESC LIMIT 4 SELECT * FROM media WHERE homeSort > 0 AND gallery = 'Y' ORDER BY dateAdded DESC LIMIT 8; SELECT * FROM media WHERE gallery = 'Y' AND type IN ('image','video') ORDER BY dateAdded DESC,sort limit 8; |
| imageDescription.cgi | SELECT * FROM media WHERE mediaId = '$id' |
| interactive.cgi | -- |
| learn_aerosols_clouds.cgi |
SELECT * FROM learn WHERE category LIKE '%aerosol%' OR category LIKE '%cloud%' ORDER BY dateAdded DESC;
SELECT * FROM faqs_learn WHERE category LIKE '%aerosol%' OR category LIKE '%cloud%' ORDER BY listOrder; SELECT * FROM faqs WHERE faqsId = '$faqsId'; |
| learn_color.cgi |
SELECT * FROM learn WHERE category LIKE '%color%' ORDER BY dateAdded DESC
SELECT * FROM faqs_learn WHERE category = 'color' ORDER BY listOrder SELECT * FROM faqs WHERE faqsId = '$faqsId' |
| learn_documents.cgi |
SELECT * FROM documents WHERE category LIKE '%outreach%';
SELECT * FROM documents WHERE category LIKE '%outreach%'; SELECT * FROM documents WHERE category LIKE '%outreach%' ORDER BY $orderBy; |
| learn_ecology.cgi |
SELECT * FROM learn WHERE category LIKE '%ecology%' ORDER BY dateAdded DESC;
SELECT * FROM faqs_learn WHERE category = 'ecology' ORDER BY listOrder; SELECT * FROM faqs WHERE faqsId = '$faqsId'; |
| learn_instruments.cgi |
SELECT * FROM learn WHERE category LIKE '%instruments%' ORDER BY dateAdded DESC;
SELECT * FROM faqs_learn WHERE category = 'instruments' ORDER BY listOrder; SELECT * FROM faqs WHERE faqsId = '$faqsId'; |
| learn_list.cgi | SELECT * FROM learn WHERE (type != 'clips' AND category != 'technical') ORDER BY title |
| learn_more.cgi |
SELECT * FROM learn WHERE learnId = '$id'
SELECT * FROM clips WHERE learnId = '$id' ORDER BY sortOrder |
| learn-more.cgi |
SELECT * FROM learn WHERE learnId = '$id'
SELECT * FROM clips WHERE learnId = '$id' ORDER BY sortOrder |
| learn_technical.cgi | SELECT * FROM learn WHERE category LIKE '%technical%' ORDER BY dateAdded DESC |
| learn_thematic.cgi |
SELECT * FROM learn WHERE ((category LIKE '%aeresol%') || (category LIKE '%cloud%') || (category LIKE '%ecology%') || (category LIKE '%color%') || (category LIKE '%instrument%')) ORDER BY dateAdded DESC LIMIT 1;
SELECT * FROM learn WHERE ((category LIKE '%aeresol%') || (category LIKE '%cloud%') || (category LIKE '%ecology%') || (category LIKE '%color%') || (category LIKE '%instrument%')) ORDER BY dateAdded DESC LIMIT 4 OFFSET 1; |
| media_more.cgi | SELECT * FROM media WHERE mediaId='$id' |
| meet_more.cgi | SELECT * FROM media WHERE mediaId='$id' |
| mission.cgi | -- |
| mission_devteam.cgi | SELECT * FROM people WHERE category LIKE '%mission%' ORDER by sortOrder; |
| mission_science.cgi | -- |
| nasa_satellite_history.cgi | -- |
| news.cgi |
SELECT * FROM news ORDER BY dateAdded DESC LIMIT 3
SELECT * FROM news ORDER BY dateAdded DESC LIMIT 200 OFFSET 3 |
| news_more.cgi | SELECT * FROM news WHERE newsId = '$id' |
| ocean_color_gallery.cgi | SELECT * FROM media_ocean_color ORDER BY dateAdded DESC |
| ocean_color_more.cgi | SELECT * FROM media_ocean_color WHERE mediaId = '$id'; |
| oci.cgi | -- |
| pace_climate_story.cgi | -- |
| pace_synergy.cgi | -- |
| paper_model.cgi | -- |
| people.cgi |
SELECT * FROM people WHERE peopleId = '$id'
SELECT * FROM proposals WHERE peopleId = '$id' ORDER BY year DESC SELECT * FROM coPIs WHERE propId = '$propId' ORDER BY sortCoPi SELECT * FROM eaDopter WHERE propId = '16' SELECT * FROM eaMedia WHERE propId = '16' SELECT * FROM authorDocs, documents WHERE (authorDocs.docId = documents.docId AND authorDocs.peopleId = '$id' AND documents.category LIKE '%meeting%') ORDER BY authorDocs.orderDate DESC SELECT * FROM documents WHERE docId = $docId SELECT * FROM authorPubs, publications WHERE (authorPubs.pubId = publications.pubId AND authorPubs.peopleId = '$id' AND publications.category LIKE '%st01%') ORDER BY authorPubs.orderDate DESC SELECT * FROM publications WHERE pubId = '$pubId' |
| people_ea.cgi |
SELECT * FROM people WHERE peopleId = '$id';
SELECT * FROM eaDopter WHERE ((peopleId = '$id') AND (propId != '16')); SELECT * FROM eaCoPIs WHERE propId = '$propId' ORDER BY sortCoPi; SELECT * FROM eaMedia WHERE propId = '$propId'; |
| phytopia.cgi | -- |
| phyto_quiz_badge.cgi | SELECT * FROM phytoQuiz WHERE idAccess='$id' |
| phyto_quiz.cgi | -- |
| process_contact_applications.cgi | -- |
| process_CoP_applications.cgi | -- |
| project_science_team.cgi | -- |
| proposals.cgi | -- |
| proposals_more.cgi | -- |
| publications.cgi |
SELECT * FROM tags WHERE (page = 'publications' AND tag NOT LIKE '%st0%') ORDER BY name;
SELECT * FROM publications WHERE (gallery = 'T' AND category LIKE '%$tag%') ORDER BY author; SELECT * FROM publications WHERE (gallery = 'T' AND category LIKE '%$tag%') ORDER BY author; SELECT * FROM publications WHERE (gallery = 'T' AND category LIKE '%$tag%') ORDER BY title; SELECT * FROM publications WHERE (gallery = 'T' AND category LIKE '%$tag%') ORDER BY YEAR(date) DESC, author ASC; |
| publication_more.cgi | SELECT * FROM publications WHERE pubId='$id' |
| publications_st.cgi |
SELECT * FROM publications WHERE category LIKE '%$cat%' ORDER BY author SELECT * FROM publications WHERE category LIKE '%$cat%' ORDER BY title SELECT * FROM publications WHERE category LIKE '%$cat%' ORDER BY date DESC |
| quarantine_quiz.cgi | -- |
| science_applications_team.cgi |
SELECT * FROM people WHERE (peopleId = '12' and teamCategory LIKE '%st02%')
SELECT * FROM proposals WHERE (year = '2020' AND peopleId = '$peopleId'); SELECT * FROM coPIs WHERE propId = '$propId' ORDER BY sortCoPi; SELECT * FROM people WHERE ((peopleId != '12' and teamCategory LIKE '%st02%') AND (peopleId != '16' and teamCategory LIKE '%st02%')) ORDER BY nameLast; SELECT * FROM proposals WHERE (year = '2020' AND peopleId = '$peopleId'); SELECT * FROM coPIs WHERE propId = '$propId' ORDER BY sortCoPi; SELECT * FROM meetings WHERE type='pace' ORDER BY dateAdded DESC; SELECT * FROM meetings WHERE type='other' ORDER BY dateAdded DESC; |
| science.cgi |
SELECT * FROM slides WHERE showId='10' ORDER BY orderDate DESC
SELECT * FROM media WHERE mediaId=$mediaId SELECT * FROM documents WHERE docId=$docId |
| science_meeting.cgi |
SELECT * FROM meetings WHERE category = '$id' ORDER BY 'dateAdded'
SELECT * FROM documents WHERE category LIKE '%$id%' SELECT * FROM documents WHERE category LIKE '%$id%' ORDER BY $orderBy SELECT * FROM meetings WHERE category = '$filter' ORDER BY 'dateAdded' SELECT * FROM documents WHERE category LIKE '%$filter%' SELECT * FROM documents WHERE category LIKE '%$filter%' ORDER BY $orderBy |
| science_storymap.cgi | -- |
| science_team.cgi |
SELECT * FROM people WHERE ((peopleId = '11' and teamCategory LIKE '%st01%') OR (peopleId = '12' and teamCategory LIKE '%st01%')) ORDER BY nameLast;
SELECT * FROM proposals WHERE (year = '2013' AND peopleId = '$peopleId'); |
| sci_meeting_documents.cgi |
SELECT * FROM meetings ORDER BY 'dateAdded';
SELECT * FROM documents WHERE category LIKE '%$category%' ORDER BY title; SELECT * FROM meetings ORDER BY 'dateAdded'; SELECT * FROM documents WHERE category LIKE '%meeting%' ORDER BY title; |
| search.cgi | ToDo |
| sea_space_phytopia.cgi | -- |
| sea_the_light.cgi | -- |
| shapes.cgi | -- |
| slideshow_gallery.cgi |
SELECT * FROM shows WHERE showId = $id;
SELECT * FROM slides WHERE showId='$id' AND orderSort != '0' ORDER BY orderSort DESC; SELECT * FROM media WHERE mediaId=$slideMediaId; |
| slideshow_more.cgi |
SELECT * FROM shows WHERE showId = $id;
SELECT * FROM media WHERE type='show' AND category = $id; SELECT * FROM slides WHERE showId='$id' AND orderSort != '0' ORDER BY orderSort DESC; SELECT * FROM media WHERE mediaId=$slideMediaId; |
| spexone.cgi | -- |
| st01.cgi |
SELECT * FROM people WHERE ((peopleId = '11' and teamCategory LIKE '%st01%') OR (peopleId = '12' and teamCategory LIKE '%st01%')) ORDER BY nameLast;
SELECT * FROM proposals WHERE (year = '2013' AND peopleId = '$peopleId'); |
| st02a.cgi |
SELECT * FROM proposals WHERE ((year=2020 AND peopleId=12));
SELECT * FROM people WHERE peopleId = $peopleId; SELECT * FROM coPIs WHERE propId = '$propId' ORDER BY coPI; |
| st02.cgi |
SELECT * FROM people WHERE (peopleId = '12' and teamCategory LIKE '%st02%');
SELECT * FROM proposals WHERE (year = '2020' AND peopleId = '$peopleId'); SELECT * FROM coPIs WHERE propId = '$propId' ORDER BY coPI; SELECT * FROM people WHERE ((peopleId != '12' and teamCategory LIKE '%st02%') AND (peopleId != '16' and teamCategory LIKE '%st02%')) ORDER BY nameLast; SELECT * FROM meetings WHERE type='pace' ORDER BY dateAdded DESC; SELECT * FROM meetings WHERE type='other' ORDER BY 'dateAdded'; |
| storymaps.cgi | SELECT * FROM media WHERE mediaId='$id' |
| support.cgi | -- |
| timeline.cgi | -- |
| vimeo_more.cgi | -- |
| web_beyond_blue.cgi |
SELECT * FROM slides WHERE showId='14' ORDER BY orderDate DESC;
SELECT * FROM media WHERE mediaId=$mediaId; SELECT * FROM documents WHERE docId=$docId; SELECT * FROM slides WHERE showId='15' ORDER BY orderDate DESC; |