include("inc/photoData.php");
//
// ALLE KONTINENTE AUSLESEN
//
$select_continent = "select fo.fID, fo.frStateID, st.fID, st.frCountryID, co.fID, co.frContinentID, count(co.frContinentID) as ContinentNr, con.fID as ContinentID, con.fTitleGE as Continent, fows.frFotoID, fows.frWebsiteID
from tb_Foto fo
inner join comState st on st.fID = fo.frStateID
inner join comCountry co on co.fID = st.frCountryID
inner join comContinent con on con.fID = co.frContinentID
inner join tb_Foto_Website fows on fows.frFotoID = fo.fID
where ".$basic."
group by co.frContinentID";
$continent_data = @mysql_query($select_continent,$dbh);
//
// ALLE KONTINENTE AUSLESEN
//
$select_continentRegion = "select fo.fID, fo.frStateID, st.fID, st.frCountryID, core.frCountryID, core.frContinentRegionID as ContinentRegionID, count(core.frContinentRegionID) as ContinentRegionNr, cr.fID, cr.fTitleGE as ContinentRegion, fows.frFotoID, fows.frWebsiteID
from tb_Foto fo
left outer join comState st on st.fID = fo.frStateID
inner join comCountry co on co.fID = st.frCountryID
inner join comCountry_ContinentRegion core on core.frCountryID = co.fID
inner join comContinentRegion cr on cr.fID = core.frContinentRegionID
inner join tb_Foto_Website fows on fows.frFotoID = fo.fID
where ".$basic."
group by core.frContinentRegionID
order by cr.fTitleGE";
$continentRegion_data = @mysql_query($select_continentRegion,$dbh);
//
// ALLE LAENDER AUSLESEN
//
$select_country = "select co.fID as CountryID, co.fTitleGE as Country, fo.fID, fo.frStateID, st.fID, st.frCountryID, count(fo.fID) as CountryNr, fows.frFotoID, fows.frWebsiteID
from comCountry co
inner join comState st on st.frCountryID = co.fID
inner join tb_Foto fo on fo.frStateID = st.fID
inner join tb_Foto_Website fows on fows.frFotoID = fo.fID
where ".$basic."
group by co.fID
order by co.fTitleGE";
$country_data = @mysql_query($select_country,$dbh);
//
// ALLE REGIONEN AUSLESEN
//
$select_state = "select st.fID as StateID, st.fTitle as State, fo.fID, fo.frStateID, count(fo.fID) as StateNr, fows.frFotoID, fows.frWebsiteID
from comState st
inner join tb_Foto fo on fo.frStateID = st.fID
inner join tb_Foto_Website fows on fows.frFotoID = fo.fID
where ".$basic."
group by st.fID
order by st.fTitle";
$state_data = @mysql_query($select_state,$dbh);
//
// ALLE STAEDTE AUSLESEN
//
$select_city = "select ci.fID as CityID, ci.fTitle as City, fo.fID, fo.frCityID, count(fo.fID) as CityNr, fows.frFotoID, fows.frWebsiteID
from comCity ci
inner join tb_Foto fo on fo.frCityID = ci.fID
inner join tb_Foto_Website fows on fows.frFotoID = fo.fID
where ".$basic."
group by ci.fID
order by ci.fTitle";
$city_data = @mysql_query($select_city,$dbh);
//
// ALLE BEZIRKE AUSLESEN
//
$select_district = "select di.fID as DistrictID, di.fTitle as District, fo.fID, fo.frDistrictID, count(fo.fID) as DistrictNr, fows.frFotoID, fows.frWebsiteID
from comDistrict di
inner join tb_Foto fo on fo.frDistrictID = di.fID
inner join tb_Foto_Website fows on fows.frFotoID = fo.fID
where ".$basic."
group by di.fID
order by di.fTitle";
$district_data = @mysql_query($select_district,$dbh);
//
// ALLE PLÄTZE AUSLESEN
//count(fo.fID) as PlaceNr,
$select_place = "select pl.fID as PlaceID, pl.fTitle as Place, fopl.frPlaceID as PlaceID, fopl.frFotoID, fo.fID, fows.frFotoID, fows.frWebsiteID, count(fo.fID) as PlaceNr, pl.fStatus
from comPlace pl
inner join tb_Foto_Place fopl on fopl.frPlaceID = pl.fID
inner join tb_Foto fo on fo.fID = fopl.frFotoID
inner join tb_Foto_Website fows on fows.frFotoID = fo.fID
where ".$basic."
group by fopl.frPlaceID
order by pl.fTitle";
$place_data = @mysql_query($select_place,$dbh);
?>
- Alle Entstehungsorte der Fotos
if ($testServer == ""): ?>
endif; ?>
if (($DebugID == 0) && ($testServer != "")): ?>
endif; ?>