REQUEST_URI: /frankrijk-bed-and-breakfast/
query: select directory.name as 'directoryname', directory.sort as 'directorysort', directory.directbooking as 'directorydirectbooking', directory.id as 'directoryid', directory.urlshortcut as 'directoryurlshortcut', directory.url as 'directoryurl',
(directory.idescription + directory.iprices + directory.igeography + directory.icalender + directory.iphotos + directory.iurl + directory.iemail) as 'irate', (directory.sprices + directory.sgeography + directory.scalender + directory.ssize + directory.sother) as 'srate',
directorylanguage.grabtitle as 'directorylanguagegrabtitle', directorylanguage.grabdescription as 'directorylanguagegrabdescription', directorylanguage.grabkeywords as 'directorylanguagegrabkeywords', directorylanguage.url as 'directorylanguageurl', directorylanguage.grabsucces as 'directorylanguagegrabsucces',
directory.costsowner as 'directorycostsowner', directory.costsvisitor as 'directorycostsvisitor',
directorylanguage.keydata as 'directorylanguagekeydata', directorylanguage.id as 'directorylanguageid',
directorycountryobject.number as 'directorycountryobjectnumber', directorycountryobject.date as 'directorycountryobjectdate'
from directory, directorylanguage, directorycountry, directorycountryobject
where directory.id = directorylanguage.directoryid and directory.id = directorycountry.directoryid
and directorylanguage.languageid = '2' and directorycountry.countryid = '1'
and directorycountry.id = directorycountryobject.directorycountryid
and directory.active = 'Y'
and directorycountryobject.objectid = '2' and directory.costsowner = 'N' and directory.costsvisitor = 'N' order by directory.sort desc, directory.costsvisitor, directory.costsowner, directorycountryobject.number desc
query: select directory.name as 'directoryname', directory.sort as 'directorysort', directory.directbooking as 'directorydirectbooking', directory.id as 'directoryid', directory.urlshortcut as 'directoryurlshortcut', directory.url as 'directoryurl',
(directory.idescription + directory.iprices + directory.igeography + directory.icalender + directory.iphotos + directory.iurl + directory.iemail) as 'irate', (directory.sprices + directory.sgeography + directory.scalender + directory.ssize + directory.sother) as 'srate',
directorylanguage.grabtitle as 'directorylanguagegrabtitle', directorylanguage.grabdescription as 'directorylanguagegrabdescription', directorylanguage.grabkeywords as 'directorylanguagegrabkeywords', directorylanguage.url as 'directorylanguageurl', directorylanguage.grabsucces as 'directorylanguagegrabsucces',
directory.costsowner as 'directorycostsowner', directory.costsvisitor as 'directorycostsvisitor',
directorylanguage.keydata as 'directorylanguagekeydata', directorylanguage.id as 'directorylanguageid',
directorycountryobject.number as 'directorycountryobjectnumber', directorycountryobject.date as 'directorycountryobjectdate'
from directory, directorylanguage, directorycountry, directorycountryobject
where directory.id = directorylanguage.directoryid and directory.id = directorycountry.directoryid
and directorylanguage.languageid = '2' and directorycountry.countryid = '1'
and directorycountry.id = directorycountryobject.directorycountryid
and directory.active = 'Y'
and directorycountryobject.objectid = '2' and (directory.costsowner <> 'N' or directory.costsvisitor <> 'N') order by directory.sort desc, directory.costsvisitor, directory.costsowner, directorycountryobject.number desc
|
