NOTE: Only includes images upto 5604724 (2017-11-19 21:13:47)<title>Bulk Download</title>
<form method=get name="theform">
<table border=1 cellspacing=0 cellpadding=2 style=background-color:#eee>
<tr>
	<th colspan=2>Column</th>
	<th>Include in Output</th>
	<th>Example</th>
	<th>Filter</th>
<tr><th align=left>gridimage_id</th><td>int(11)</td><td><input type=checkbox name="include[gridimage_id]" checked></td><td>1160964</td><td><select name="filter[gridimage_id]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[gridimage_id]" value=""></td></tr>
<tr><th align=left>user_id</th><td>int(11)</td><td><input type=checkbox name="include[user_id]"></td><td>22713</td><td><select name="filter[user_id]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[user_id]" value=""></td></tr>
<tr><th align=left>moderation_status</th><td>enum('rejected','pending','accepted','geograph')</td><td><input type=checkbox name="include[moderation_status]"></td><td>accepted</td><td><select name="filter[moderation_status]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[moderation_status]" value=""></td></tr>
<tr><th align=left>title</th><td>varchar(128)</td><td><input type=checkbox name="include[title]" checked></td><td>Dumbarton Prison - entrance portico</td><td><select name="filter[title]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[title]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>submitted</th><td>datetime</td><td><input type=checkbox name="include[submitted]"></td><td>2009-02-13 20:21:40</td><td><select name="filter[submitted]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[submitted]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>imageclass</th><td>varchar(32)</td><td><input type=checkbox name="include[imageclass]"></td><td>Doorway</td><td><select name="filter[imageclass]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[imageclass]" value=""></td></tr>
<tr><th align=left>imagetaken</th><td>date</td><td><input type=checkbox name="include[imagetaken]"></td><td>2006-11-01</td><td><select name="filter[imagetaken]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[imagetaken]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>upd_timestamp</th><td>timestamp</td><td><input type=checkbox name="include[upd_timestamp]"></td><td>2009-02-14 16:30:25</td><td><select name="filter[upd_timestamp]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[upd_timestamp]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>x</th><td>smallint(3)</td><td><input type=checkbox name="include[x]"></td><td>445</td><td><select name="filter[x]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[x]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>y</th><td>smallint(4)</td><td><input type=checkbox name="include[y]"></td><td>675</td><td><select name="filter[y]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[y]" value=""></td></tr>
<tr><th align=left>grid_reference</th><td>varchar(6)</td><td><input type=checkbox name="include[grid_reference]"></td><td>NS3975</td><td><select name="filter[grid_reference]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[grid_reference]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>credit_realname</th><td>tinyint(4)</td><td><input type=checkbox name="include[credit_realname]"></td><td></td><td><select name="filter[credit_realname]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[credit_realname]" value=""></td></tr>
<tr><th align=left>realname</th><td>varchar(128)</td><td><input type=checkbox name="include[realname]" checked></td><td>Lairich Rig</td><td><select name="filter[realname]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[realname]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>reference_index</th><td>tinyint(1)</td><td><input type=checkbox name="include[reference_index]"></td><td>1</td><td><select name="filter[reference_index]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[reference_index]" value=""></td></tr>
<tr><th align=left>comment</th><td>text</td><td><input type=checkbox name="include[comment]"></td><td>See the main item: [[1160950]].

This is the building's en ...</td><td><select name="filter[comment]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[comment]" value=""></td></tr>
<tr><th align=left>wgs84_lat</th><td>decimal(10,6)</td><td><input type=checkbox name="include[wgs84_lat]"></td><td>55.944343</td><td><select name="filter[wgs84_lat]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[wgs84_lat]" value=""></td></tr>
<tr><th align=left>wgs84_long</th><td>decimal(10,6)</td><td><input type=checkbox name="include[wgs84_long]"></td><td>-4.565646</td><td><select name="filter[wgs84_long]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[wgs84_long]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>ftf</th><td>tinyint(3) unsigned</td><td><input type=checkbox name="include[ftf]"></td><td></td><td><select name="filter[ftf]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[ftf]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>seq_no</th><td>smallint(5) unsigned</td><td><input type=checkbox name="include[seq_no]"></td><td>113</td><td><select name="filter[seq_no]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[seq_no]" value=""></td></tr>
<tr><th align=left>tags</th><td>text</td><td><input type=checkbox name="include[tags]"></td><td>top:Derelict, Disused?top:Historic sites and artefacts?bucke ...</td><td><select name="filter[tags]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[tags]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>licence</th><td>enum('cc-by-sa/2.0','cc-by-sa/3.0')</td><td><input type=checkbox name="include[licence]"></td><td>cc-by-sa/2.0</td><td><select name="filter[licence]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[licence]" value=""></td></tr>
<tr class="adv" style="display:none"><th align=left>points</th><td>set('','tpoint')</td><td><input type=checkbox name="include[points]"></td><td></td><td><select name="filter[points]"><option value="" selected></option><option value="=">Equals</option><option value="<">Less Than</option><option value=">">Greater Than</option><option value="!=">Not Equals</option><option value="LIKE%">Starts With</option><option value="LIKE%%">Contains</option><option value="LIKE">LIKE</option></select><input type=text name="value[points]" value=""></td></tr>
<tr><td colspan=4 align=right>Keyword (searches: title, description and tags)</td><td>contains: <input type=text name="keywords" value=""></table><input type=checkbox id=show>Show extra columns &nbsp; <input type=submit value=Update></form>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<script>
$(function() {
	$('form').submit(function() {

		$(this).find(':input[value=""]').attr("disabled", "disabled");
		setTimeout(function(){
			$(':input[value=""]').attr("disabled", false);
		},1000);
	        return true; // ensure form still submits
    	});
	$('#show').click(function() {
		$('.adv').toggle($(this).attr('checked'));
	});
});
</script>