Salinity DB to CGI Map

Salinity DB Table to CGI Map

Live DB: salinity

Dev DB: salinitydev

Data table	CGI	column: distinct values
acronyms	acronyms.cgi
assets
authors
cards	learn.cgi
cardsSASSIE	sassie-tools.cgi
clips
comparision
contacts
contentLocs	search.cgi
documents	documents.cgi, documents-more.cgi, gallery-movies-more.cgi, gallery-podcasts-more.cgi, meetings.cgi, meetings-documents.cgi, highlights01.cgi, highlights02.cgi, highlights03.cgi, highlights04.cgi, highlights05.cgi, highlights-research.cgi, research.cgi
eBrochures	e-brochures.cgi, gallery-ebrochures-more.cgi, gallery.cgi
education
events	events.cgi, events_more.cgi, imageDescription.cgi
faqs	learn-circulation.cgi
faqs_learn	learn-circulation.cgi
faq_categories
files
highlights	highlights.cgi
images	gallery.cgi, gallery-images-more.cgi, imageDescription.cgi, highlights01.cgi, highlights02.cgi, highlights03.cgi, highlights04.cgi, highlights05.cgi, sassie.cgi, sassie-field.cgi
learn	learn.cgi, learn-circulation.cgi, learn-cycle.cgi, learn-list.cgi, learn-more.cgi, learn-salinity.cgi, learn-salt.cgi	category: cycle, circulation, salt, climate, data, {empty} multiple, comma-separated categories are allowed; "data" => learn-salinity.cgi
learn_archive	"deleted" resources
maps	aquarius-maps.cgi, data-maps.cgi, gallery-maps-more.cgi, imageDescription.cgi, smap-jpl-cap-menu-js.cgi, smap-jpl-cap.cgi, smap-maps.cgi, smap-radiometer.cgi
map_categories
meetings	meetings.cgi, meetings-documents.cgi
mintues	process-login.cgi	minutes.categories <==> minutes_categories.category
mintues_categories	process-login.cgi	Columns: catId, category, title, description, date Empty columns: title, description
movies	home.cgi, gallery.cgi, gallery-movies-more.cgi, highlights01.cgi, highlights02.cgi, highlights03.cgi, highlights04.cgi, highlights05.cgi	category: 'science', 'technology', 'technolgy,science', 'science,technology', 'climate,technology', {empty} gallery: T, F
news	imageDescription.cgi, news.cgi, news-more.cgi
ontMapping
ontOntology
ontTerm
pages
people	people.cgi, sassie-data.cgi
podcasts	gallery.cgi, gallery-podcasts-more.cgi
presentations	ocean-salinity-conference-2022.cgi
publications	home.cgi, highlights01.cgi, highlights02.cgi, highlights03.cgi, highlights04.cgi, highlights05.cgi, highlights06.cgi, highlights07.cgi, highlights08.cgi, highlights09.cgi, highlights10.cgi, highlights11.cgi, link-check-publictions.cgi, publications.cgi, science-spurs.cgi, search.cgi
shows	gallery.cgi, gallery-slides-more.cgi, sassie.cgi, sassie-field.cgi
slides_home	not used, previously used on home.cgi?
slides_rotators	home.cgi, highlights01.cgi, highlights02.cgi, highlights03.cgi, highlights04.cgi, highlights05.cgi, highlights06.cgi, highlights07.cgi, highlights08.cgi, highlights09.cgi, highlights10.cgi, highlights11.cgi
slides_sliders	highlights01.cgi, highlights02.cgi, highlights03.cgi, highlights04.cgi, highlights05.cgi, sassie.cgi, sassie-data.cgi, sassie-field.cgi
slides_slideshows	gallery.cgi, gallery-slides-more.cgi, highlights04.cgi, highlights05.cgi, smap-salinity-nh.cgi, smap-salinity-sh.cgi
standards
storymaps	gallery.cgi, storymap-collection.cgi	7 rows, all with 'collectionId' = 1 ad 'gallery' = T
storymap_collections	storymap-collection.cgi	has single row with 'collectionId' = 1
themes
users	process-login.cgi
whatsNew

Mapping CGI to SQL

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
acronyms.cgi		SELECT * FROM acronyms ORDER BY acronym;
aq-*.cgi
aquarius-maps.cgi		SELECT * FROM maps WHERE (category = 'data' OR category = 'seasonalSSS' OR category = 'annualSSS' OR category = 'data_nh' OR category = 'data_sh'); SELECT * FROM maps WHERE (category = 'climateMonthlySSS' OR category = 'climateSeasonalSSS'); SELECT * FROM maps WHERE (category = 'sss_high_2015_nh' OR category = 'sss_high_2015_sh' OR category = 'sss_high_2014_nh' OR category = 'sss_high_2014_sh' OR category = 'sss_high_2013_nh' OR category = 'sss_high_2013_sh' OR category = 'sss_high_2012_nh' OR category = 'sss_high_2012_sh' OR category = 'sss_high_2011_nh' OR category = 'sss_high_2011_sh'); SELECT * FROM maps WHERE (category = 'oi_sss_2015' OR category = 'oi_sss_2014' OR category = 'oi_sss_2013' OR category = 'oi_sss_2012' OR category = 'oi_sss_2011'); SELECT * FROM maps WHERE category = 'radiometer'; SELECT * FROM maps WHERE category = 'scatterometer'; SELECT * FROM maps WHERE category = 'density'; SELECT * FROM maps WHERE (category = 'tbv_high_2015_nh' OR category = 'tbv_high_2015_sh' OR category = 'tbv_high_2014_nh' OR category = 'tbv_high_2014_sh' OR category = 'tbv_high_2013_nh' OR category = 'tbv_high_2013_sh' OR category = 'tbv_high_2012_nh' OR category = 'tbv_high_2012_sh' OR category = 'tbv_high_2011_nh' OR category = 'tbv_high_2011_sh'); SELECT * FROM maps WHERE category = 'moisture';
contact.cgi		static page
data.cgi		static page
data-aq-processing.cgi		static page
data-aq-retrieval.cgi		static page
data-links.cgi		static page
data-maps.cgi		SELECT * FROM maps WHERE (category = 'smap' OR category = 'smap_nh' OR category = 'smap_sh'); SELECT * FROM maps WHERE (category = 'data' OR category = 'seasonalSSS' OR category = 'annualSSS' OR category = 'data_nh' OR category = 'data_sh'); SELECT * FROM maps WHERE (category = 'climateMonthlySSS' OR category = 'climateSeasonalSSS'); SELECT * FROM maps WHERE (category = 'sss_high_2015_nh' OR category = 'sss_high_2015_sh' OR category = 'sss_high_2014_nh' OR category = 'sss_high_2014_sh' OR category = 'sss_high_2013_nh' OR category = 'sss_high_2013_sh' OR category = 'sss_high_2012_nh' OR category = 'sss_high_2012_sh' OR category = 'sss_high_2011_nh' OR category = 'sss_high_2011_sh'); SELECT * FROM maps WHERE (category = 'oi_sss_2015' OR category = 'oi_sss_2014' OR category = 'oi_sss_2013' OR category = 'oi_sss_2012' OR category = 'oi_sss_2011'); SELECT * FROM maps WHERE category = 'oiSSS'; SELECT * FROM maps WHERE category = 'oiClimatology'; SELECT * FROM maps WHERE category = 'oiAnomaly'; SELECT * FROM maps WHERE category = 'smap-rfi'; SELECT * FROM maps WHERE category = 'radiometer'; SELECT * FROM maps WHERE category = 'scatterometer'; SELECT * FROM maps WHERE category = 'density'; SELECT * FROM maps WHERE (category = 'tbv_high_2015_nh' OR category = 'tbv_high_2015_sh' OR category = 'tbv_high_2014_nh' OR category = 'tbv_high_2014_sh' OR category = 'tbv_high_2013_nh' OR category = 'tbv_high_2013_sh' OR category = 'tbv_high_2012_nh' OR category = 'tbv_high_2012_sh' OR category = 'tbv_high_2011_nh' OR category = 'tbv_high_2011_sh'); SELECT * FROM maps WHERE category = 'moisture';
data-salinity-*.cgi		static page
data-sensing-salinity.cgi		static page
data-smap-v*.cgi		static page
data-tutorials.cgi		static page
documents.cgi		SELECT * FROM documents WHERE !(category LIKE '%meetings%' OR type LIKE 'transcript') ORDER BY dateAdded DESC;
documents-more.cgi		SELECT * FROM documents WHERE documentId='$id';
ebrochures.cgi		SELECT * FROM eBrochures WHERE ebId='$id';
events.cgi		SELECT * FROM events; SELECT * FROM events ORDER BY dateAdded DESC; SELECT * FROM events ORDER BY dateAdded DESC;
events-more.cgi		SELECT * FROM events WHERE eventsId='$id';
gallery.cgi	count & display eBrochures	SELECT * FROM eBrochures WHERE gallery = 'T' ORDER BY dateAdded DESC;
	count & display movies	SELECT * FROM movies WHERE gallery = 'T' ORDER BY dateAdded DESC;
	count & display images	SELECT * FROM images WHERE gallery = 'T' ORDER BY dateAdded DESC;
	count & display storymaps	SELECT * FROM storymaps WHERE gallery = 'T' ORDER BY dateAdded DESC;
	count & display podcasts	SELECT * FROM podcasts WHERE gallery = 'T' ORDER BY dateAdded DESC;
	count & display slideshows	SELECT * FROM shows WHERE ((type = 'slideshow') AND (gallery = 'Y')) ORDER BY showId;
	count & display slides for each $showId	SELECT * FROM slides_slideshows WHERE showId='$showId' ORDER BY slideOrder;
gallery-ebrochures-more.cgi		SELECT * FROM eBrochures WHERE ebId='$id';
gallery-images-more.cgi		SELECT * FROM images WHERE imageId='$id';
gallery-maps-more.cgi		SELECT * FROM maps WHERE mapId='$id';
gallery-movies-more.cgi		SELECT * FROM movies WHERE movieId='$id'; SELECT * FROM documents WHERE documentName='$documentName';
gallery-podcasts-more.cgi		SELECT * FROM podcasts WHERE podId='$id'; SELECT * FROM documents WHERE documentName='$documentName';
gallery-slides-more.cgi		SELECT * FROM shows WHERE showId='$id'; SELECT * FROM slides_slideshows WHERE showId='$showId' ORDER BY slideOrder;
highlights-research.cgi		SELECT * FROM documents WHERE category = 'research'; SELECT * FROM documents WHERE category = 'research' ORDER BY dateAdded DESC; SELECT * FROM documents WHERE category = 'research' ORDER BY $orderBy;
highlights.cgi		SELECT * FROM highlights ORDER BY sortOrder DESC;
highlights01.cgi		SELECT * FROM slides_rotators WHERE showId='14' ORDER BY slideOrder; SELECT * FROM slides_sliders WHERE showId='13' ORDER BY orderSort; SELECT * FROM images WHERE imageId='$assignId'; SELECT * FROM movies WHERE movieId='$assignId'; SELECT * FROM documents WHERE documentId='$assignId'; SELECT * FROM publications WHERE category LIKE '%highlight01%' ORDER BY date DESC LIMIT 5; SELECT * FROM publications WHERE category LIKE '%highlight01%' ORDER BY date DESC LIMIT 200 OFFSET 5;
highlights02.cgi		SELECT * FROM slides_rotators WHERE showId='15' ORDER BY slideOrder; SELECT * FROM slides_sliders WHERE showId='16' ORDER BY orderSort; SELECT * FROM images WHERE imageId='$assignId'; SELECT * FROM movies WHERE movieId='$assignId'; SELECT * FROM documents WHERE documentId='$assignId'; SELECT * FROM publications WHERE category LIKE '%highlight02%' ORDER BY date DESC LIMIT 5; SELECT * FROM publications WHERE category LIKE '%highlight02%' ORDER BY date DESC LIMIT 200 OFFSET 5;
highlights03.cgi		SELECT * FROM slides_rotators WHERE showId='17' ORDER BY slideOrder; SELECT * FROM slides_sliders WHERE showId='18' ORDER BY orderSort; SELECT * FROM images WHERE imageId='$assignId'; SELECT * FROM movies WHERE movieId='$assignId'; SELECT * FROM documents WHERE documentId='$assignId'; SELECT * FROM publications WHERE category LIKE '%highlight03%' ORDER BY date DESC LIMIT 5; SELECT * FROM publications WHERE category LIKE '%highlight03%' ORDER BY date DESC LIMIT 200 OFFSET 5;
highlights04.cgi		SELECT * FROM slides_rotators WHERE showId='19' ORDER BY slideOrder; SELECT * FROM slides_slideshows WHERE showId='31' ORDER BY slideOrder; SELECT * FROM slides_sliders WHERE showId='20' ORDER BY orderSort; SELECT * FROM images WHERE imageId='$assignId'; SELECT * FROM movies WHERE movieId='$assignId'; SELECT * FROM documents WHERE documentId='$assignId'; SELECT * FROM publications WHERE category LIKE '%highlight04%' ORDER BY date DESC LIMIT 5; SELECT * FROM publications WHERE category LIKE '%highlight04%' ORDER BY date DESC LIMIT 200 OFFSET 5;
highlights05.cgi		SELECT * FROM slides_rotators WHERE showId='21' ORDER BY slideOrder; SELECT * FROM slides_sliders WHERE showId='22' ORDER BY orderSort; SELECT * FROM images WHERE imageId='$assignId'; SELECT * FROM movies WHERE movieId='$assignId'; SELECT * FROM documents WHERE documentId='$assignId'; SELECT * FROM publications WHERE category LIKE '%highlight05%' ORDER BY date DESC LIMIT 5; SELECT * FROM publications WHERE category LIKE '%highlight05%' ORDER BY date DESC LIMIT 200 OFFSET 5; SELECT * FROM slides_slideshows WHERE showId='32' ORDER BY slideOrder; SELECT * FROM slides_slideshows WHERE showId='33' ORDER BY slideOrder; SELECT * FROM slides_slideshows WHERE showId='34' ORDER BY slideOrder; SELECT * FROM slides_slideshows WHERE showId='35' ORDER BY slideOrder;
highlights06.cgi		SELECT * FROM slides_rotators WHERE showId='23' ORDER BY slideOrder; SELECT * FROM slides_sliders WHERE showId='24' ORDER BY orderSort; SELECT * FROM images WHERE imageId='$assignId'; SELECT * FROM movies WHERE movieId='$assignId'; SELECT * FROM documents WHERE documentId='$assignId'; SELECT * FROM publications WHERE category LIKE '%highlight06%' ORDER BY date DESC LIMIT 5; SELECT * FROM publications WHERE category LIKE '%highlight06%' ORDER BY date DESC LIMIT 200 OFFSET 5;
highlights07.cgi		SELECT * FROM slides_rotators WHERE showId='25' ORDER BY slideOrder; SELECT * FROM comparison WHERE category = 'highlight07' ORDER BY sortOrder; SELECT * FROM publications WHERE category LIKE '%highlight07%' ORDER BY date DESC LIMIT 5; SELECT * FROM publications WHERE category LIKE '%highlight07%' ORDER BY date DESC LIMIT 200 OFFSET 5;
highlights08.cgi		SELECT * FROM slides_rotators WHERE showId='27' ORDER BY slideOrder; SELECT * FROM publications WHERE category LIKE '%highlight08%' ORDER BY date DESC LIMIT 8; SELECT * FROM publications WHERE category LIKE '%highlight08%' ORDER BY date DESC LIMIT 200 OFFSET 8;
highlights09.cgi		SELECT * FROM slides_rotators WHERE showId='53' ORDER BY slideOrder; SELECT * FROM publications WHERE category LIKE '%highlight09%' ORDER BY date DESC LIMIT 6; SELECT * FROM publications WHERE category LIKE '%highlight09%' ORDER BY date DESC LIMIT 200 OFFSET 6;
highlights10.cgi		SELECT * FROM slides_rotators WHERE showId='59' ORDER BY slideOrder; SELECT * FROM publications WHERE category LIKE '%highlight10%' ORDER BY date DESC LIMIT 8; SELECT * FROM publications WHERE category LIKE '%highlight10%' ORDER BY date DESC LIMIT 200 OFFSET 8;
highlights11.cgi		SELECT * FROM slides_rotators WHERE showId='60' ORDER BY slideOrder; SELECT * FROM publications WHERE category LIKE '%highlight11%' ORDER BY date DESC LIMIT 8; SELECT * FROM publications WHERE category LIKE '%highlight11%' ORDER BY date DESC LIMIT 200 OFFSET 8;
highlights12.cgi		??? check sql SELECT * FROM slides_rotators WHERE showId='60' ORDER BY slideOrder; SELECT * FROM publications WHERE category LIKE '%highlight12%' ORDER BY date DESC LIMIT 8; SELECT * FROM publications WHERE category LIKE '%highlight12%' ORDER BY date DESC LIMIT 200 OFFSET 8;
home.cgi		SELECT * FROM slides_rotators WHERE showId='30' ORDER BY slideOrder; SELECT * FROM `whatsNew` WHERE visible = 'Y' ORDER BY sortOrder DESC; SELECT * FROM publications WHERE year != '9999' AND category NOT LIKE '%related_topics%' ORDER BY year DESC, date DESC LIMIT 5; storymaps links hard-coded maps are hard-coded SELECT * FROM movies WHERE gallery = 'T' ORDER BY dateAdded DESC limit 6;
imageDescription.cgi	not for public use?	SELECT * FROM images WHERE imageId = '$id'; SELECT * FROM movies WHERE movieId = '$id'; SELECT * FROM maps WHERE mapId = '$id'; SELECT * FROM activities WHERE actId = '$id'; * there is NO table `activities` * SELECT * FROM news WHERE newsId = '$id'; SELECT * FROM events WHERE eventsId = '$id';
learn.cgi	Spinning "cards"	SELECT * FROM cards WHERE cardShow='learn' ORDER BY sortOrder;
learn-circulation.cgi	What's New	SELECT * FROM learn WHERE category LIKE '%circulation%' ORDER BY dateAdded DESC LIMIT 2;
	All resources	SELECT * FROM learn WHERE category = 'circulation' ORDER BY title;
	FAQs	SELECT * FROM faqs_learn WHERE category = 'circulation' ORDER BY listOrder; SELECT * FROM faqs WHERE faqsId = '$faqsId';
learn-climate.cgi	What's New	SELECT * FROM learn WHERE category LIKE '%climate%' ORDER BY dateAdded DESC LIMIT 2;
	All resources	SELECT * FROM learn WHERE category = 'climate' ORDER BY title;
	FAQs	SELECT * FROM faqs_learn WHERE category = 'climate' ORDER BY listOrder; SELECT * FROM faqs WHERE faqsId = '$faqsId';
learn-cycle.cgi	What's New	SELECT * FROM learn WHERE category LIKE '%cycle%' ORDER BY dateAdded DESC LIMIT 2;
	All resources	SELECT * FROM learn WHERE category = 'cycle' ORDER BY title;
	FAQs	SELECT * FROM faqs_learn WHERE category = 'cycle' ORDER BY listOrder; SELECT * FROM faqs WHERE faqsId = '$faqsId';
learn-list.cgi	List all resources	SELECT * FROM learn ORDER BY title;
learn-more.cgi		SELECT * FROM learn WHERE actId='$id';
learn-salinity.cgi	What's New	page is 'salinity' but category is 'data' SELECT * FROM learn WHERE category LIKE '%data%' ORDER BY dateAdded DESC LIMIT 2;
	All resources	SELECT * FROM learn WHERE category = 'data' ORDER BY title;
	FAQs	SELECT * FROM faqs_learn WHERE category = 'data' ORDER BY listOrder; SELECT * FROM faqs WHERE faqsId = '$faqsId';
learn-salt.cgi	What's New	SELECT * FROM learn WHERE category LIKE '%salt%' ORDER BY dateAdded DESC LIMIT 2;
	All resources	SELECT * FROM learn WHERE category = 'salt' ORDER BY title;
	FAQs	SELECT * FROM faqs_learn WHERE category = 'data' ORDER BY listOrder; SELECT * FROM faqs WHERE faqsId = '$faqsId';
link-check-publication.cgi		SELECT * FROM publications WHERE prePrint = 'PP' ORDER BY pubId DESC; SELECT * FROM publications WHERE title LIKE '$userInput' ORDER BY pubId DESC; SELECT * FROM publications ORDER BY pubId DESC;
maps-global.cgi
maps-overview.cgi
meetings.cgi		SELECT * FROM meetings WHERE type = '$id' ORDER BY dateAdded DESC; SELECT * FROM documents WHERE category LIKE '%$category%';
meetings-documents.cgi		SELECT * FROM documents WHERE category LIKE '%$id%'; SELECT * FROM meetings WHERE category = '$id'; SELECT * FROM meetings WHERE category = '$id'; SELECT * FROM meetings WHERE category = '$id'; SELECT * FROM meetings WHERE category = '$id'; SELECT * FROM documents WHERE category LIKE '%$id%' ORDER BY title; SELECT * FROM meetings WHERE category = '$id'; SELECT * FROM meetings WHERE category = '$sortId'; SELECT * FROM documents WHERE category LIKE '%$sortId%'; SELECT * FROM documents WHERE category LIKE '%$sortId%' ORDER BY credit; SELECT * FROM documents WHERE category LIKE '%$sortId%' ORDER BY title;
meetings-documents-all.cgi
meetings-documents-more.cgi
meetings-list.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-salinity-conference-2022.cgi		SELECT DATE_FORMAT(`date`, '%d-%b-%Y') AS `day`, `title`, `presenter`, `affiliation`, `youtube_link`, `pdf_file` FROM `presentations` WHERE `date` IS NOT NULL ORDER BY `id` ASC; SELECT `title`, `presenter`, `affiliation`, `poster_img`, `poster_thm`, `poster_pdf` FROM `presentations` WHERE `date` IS NULL ORDER BY `poster_thm` ASC;
ocean-salinity-from-space.cgi
oi-anomaly.cgi
oi-climatology.cgi
oi-salinity.cgi
overview.cgi
overview-faqs-more.cgi
overview-faqs.cgi
overview-links.cgi
overview-salinity.cgi
people.cgi		SELECT * FROM people WHERE gallery = 'Y' ORDER BY sortOrder;
pinch-of-salt.cgi
process-contract.cgi
process-login.cgi (obsolete)		SELECT * FROM users WHERE password='$password'; SELECT * FROM minutes; SELECT * FROM minute_categories ORDER BY date DESC; SELECT * FROM minutes WHERE category='$category';
publications.cgi		SELECT * FROM publications WHERE category LIKE '%$cat%' ORDER BY author, date DESC; SELECT * FROM publications WHERE category LIKE '%$cat%' ORDER BY title; SELECT * FROM publications WHERE category LIKE '%$cat%' ORDER BY date DESC, author;
quiz_salty.cgi
quiz_salty_fresh.cgi
research.cgi		SELECT * FROM documents WHERE category = 'research'; SELECT * FROM documents WHERE category = 'research' ORDER BY dateAdded DESC; SELECT * FROM documents WHERE category = 'research' ORDER BY $orderBy;
salinity-login.cgi (obsolete)
salinity-logout.cgi (obsolete)
sassie.cgi		SELECT showId,title FROM shows WHERE title IN ('SASSIE Airborne Gallery','SASSIE Mid-Cruise Gallery') ORDER BY 2; SELECT showId,assignId,type FROM slides_sliders WHERE showId=? ORDER BY orderSort; SELECT * FROM images WHERE imageId=?;
sassie-cruise.cgi		static page
sassie-data.cgi		SELECT * FROM slides_sliders WHERE showId='29' ORDER BY orderSort; SELECT * FROM people WHERE peopleId='$assignId';
sassie-field.cgi		SELECT showId,title FROM shows WHERE title IN ('SASSIE Airborne Gallery','SASSIE Mid-Cruise Gallery') ORDER BY 2; SELECT showId,assignId,type FROM slides_sliders WHERE showId=? ORDER BY orderSort; SELECT * FROM images WHERE imageId=?;
sassie-tools.cgi		SELECT * FROM cardsSASSIE WHERE cardShow='sassieShip' ORDER BY sortOrder; SELECT * FROM cardsSASSIE WHERE cardShow='sassiePilot' ORDER BY sortOrder; SELECT * FROM cardsSASSIE WHERE cardShow='sassieAirborne' ORDER BY sortOrder;
science.cgi		static page
science-highlight01.cgi		static page
science-highlight02.cgi		static page
science-highlight03.cgi		static page
science-highlights.cgi		static page
science-publications.cgi		static page
science-publications-soil-moisture.cgi		static page
science-results.cgi		static page
science-salinity.cgi		static page
science-satellites.cgi		static page
science-spurs.cgi		SELECT * FROM publications WHERE category LIKE '%spurs%'; SELECT * FROM publications WHERE category LIKE '%spurs%' ORDER BY date DESC LIMIT 5; SELECT * FROM publications WHERE category LIKE '%spurs%' ORDER BY date DESC LIMIT 100 OFFSET;
science-spurs-datatool.cgi		static page
science-spurs-how-*.cgi		static page
science-spurs-webinars-*.cgi		static page
science-spurs-why-*.cgi
search.cgi		SELECT contentType, path, contentName, contentTitle FROM contentLocs where activebool ORDER BY contentType, path, contentTitle;
smap-jpl-cap-menu-js.cgi		SELECT * FROM maps WHERE category IN ('smap_sss_jpl_cap', 'smap_sss_jpl_cap_nh', 'smap_sss_jpl_cap_sh') ORDER BY dateAdded DESC;
smap-jpl-cap.cgi		SELECT * FROM maps WHERE category = 'smap_sss_jpl_cap' ORDER BY dateAdded DESC; SELECT * FROM maps WHERE category = 'smap_sss_jpl_cap_nh' ORDER BY dateAdded DESC; SELECT * FROM maps WHERE category = 'smap_sss_jpl_cap_sh' ORDER BY dateAdded DESC;
smap-maps.cgi		SELECT * FROM maps WHERE (category = 'smap' OR category = 'smap_nh' OR category = 'smap_sh'); SELECT * FROM maps WHERE category = 'smap-rfi';
smap-radiometer.cgi		SELECT * FROM maps WHERE category = 'smap-rfi' ORDER BY dateAdded DESC";
smap-salinity-nh.cgi		SELECT * FROM slides_slideshows WHERE showId='37' ORDER BY slideOrder;
smap-salinity-sh.cgi		SELECT * FROM slides_slideshows WHERE showId='38' ORDER BY slideOrder;
storymap-collection.cgi		SELECT * FROM storymap_collections WHERE collectionId='$colId'; SELECT * FROM storymaps WHERE (collectionId = '$colId') ORDER BY sortOrder"; SELECT * FROM storymaps WHERE (gallery = 'T' && collectionId = '$colId') ORDER BY sortOrder";
storymaps.cgi		SELECT * FROM storymap_collections WHERE collectionId='$colId' SELECT * FROM storymaps WHERE (gallery = 'T' && collectionId = '$colId') SELECT * FROM storymaps WHERE storyId = $id SELECT * FROM storymaps WHERE (gallery = 'T' && collectionId = '$colId' && sortOrder = '$previous') SELECT * FROM storymaps WHERE (gallery = 'T' && collectionId = '$colId' && sortOrder = '$next')
support.cgi
telecon.cgi