De kaart wordt geladen…

Gevonden: resultaten voor binnen dit gebied

q=var.q,lang=user.language,q2=form.q2,q1=form.q, ndid=form.id,lblid=form.lblid,regio=var.regio,radius=form.straal CREATE TEMPORARY TABLE searchres AS WITH loc AS (SELECT loc FROM location WHERE name = :q2 LIMIT 1) SELECT DISTINCT mf.ndid,ndl.lblid AS catid FROM namedata mf JOIN namedatalabel ndl ON ndl.ndid=mf.ndid JOIN label regio ON regio.name=:regio JOIN namedatalabel ndlregio ON ndlregio.ndid=mf.ndid AND ndlregio.lblid=regio.lblid JOIN labelgroup lg ON lg.lblid=ndl.lblid JOIN label ln ON ln.lblid = lg.lblid AND ln.name NOT LIKE 'pro-%' JOIN label lbn ON lbn.name='category' AND lbn.lblid=lg.lblgrid LEFT JOIN loc ON TRUE WHERE (mf.ndid=COALESCE(:ndid::INT,0) OR :lblid::INT IS NOT NULL AND (SELECT 1 FROM namedatalabel sl LEFT JOIN label slb USING(lblid) LEFT JOIN usertxt slu ON slu.utxtid=slb.lblid AND slu.language=:lang WHERE sl.ndid=mf.ndid AND ( sl.lblid IN (:lblid) OR slu.txt=:q1::TEXT ) LIMIT 1) IS NOT NULL OR (:radius::DOUBLE PRECISION IS NULL OR loc.loc IS NULL) AND LENGTH(:q::TEXT)>1 AND mf.txtsearch_index_col @@ PLAINTO_TSQUERY('dutch',:q) OR :radius IS NOT NULL AND ( NOT LENGTH(:q1::TEXT)>1 OR mf.txtsearch_index_col @@ PLAINTO_TSQUERY('dutch',:q1) ) ) AND mf.status='4' AND (:q2='' OR :q2 IS NULL OR :radius::DOUBLE PRECISION IS NOT NULL AND loc.loc IS NOT NULL OR LOWER(:q2) IN (LOWER(mf.city),LOWER(mf.village),LOWER(mf.region))) AND (:radius::DOUBLE PRECISION IS NULL OR loc.loc IS NULL OR :q2='' OR :q2 IS NULL OR ST_DWithin(mf.loc, -- case insensitive query suboptimal, FIXME loc.loc, :radius*1000.0) )

RXML parse error: No current scope.
 | &_.catname;

" />

Zoek & Verfijn

Advertenties

[[zzfiltered]] Gevonden: resultaten voor () [[ofcompany]] [[incategory]]

Wist u dat…

RXML parse error: No current scope.
 | &_.description;

inc stats

RXML parse error: No current scope.
 | <sqlquery bindings="ndid=_.ndid" query="SELECT incstatsw(:swid,:mfid) AS statsw">

RXML parse error: No current scope.
 | &_.ndid;

" class="title">

RXML parse error: No current scope.
 | &_.title;

(rank: 0 =

RXML parse error: No current scope.
 | &_.ranka;

RXML parse error: No current scope.
 | &_.rankb;

RXML parse error: No current scope.
 | &_.rankc;

RXML parse error: No current scope.
 | &_.rankd;

)

RXML parse error: No current scope.
 | &_.description;

Rubriek:

RXML parse error: No current scope.
 | &_.rubrieken;

RXML parse error: No current scope.
 | &_.city;

" title="Zoek naar alles in

RXML parse error: No current scope.
 | &_.city;

RXML parse error: No current scope.
 | &_.city;

(

RXML parse error: No current scope.
 | &_.region;

" title="Zoek naar alles in

RXML parse error: No current scope.
 | &_.region;

RXML parse error: No current scope.
 | &_.region;

)

RXML parse error: No current scope.
 | &_.ndid;

" title="

RXML parse error: No current scope.
 | &_.lastname;

" class="image">

RXML parse error: No current scope.
 | &_.microb;

" alt="

RXML parse error: No current scope.
 | &_.title;

" title="

RXML parse error: No current scope.
 | &_.title;

RXML parse error: No current scope.
 | &_.ndid;

" class="meerInfo">Meer info ›

RXML parse error: No current scope.
 | &_.ndid;

" class="title">

RXML parse error: No current scope.
 | &_.title;

Rubriek:

RXML parse error: No current scope.
 | &_.rubrieken;

RXML parse error: No current scope.
 | &_.city;

" title="Zoek naar alles in

RXML parse error: No current scope.
 | &_.city;

RXML parse error: No current scope.
 | &_.city;

(

RXML parse error: No current scope.
 | &_.region;

" title="Zoek naar alles in

RXML parse error: No current scope.
 | &_.region;

RXML parse error: No current scope.
 | &_.region;

)

RXML parse error: No current scope.
 | &_.ndid;

" class="meerInfo">Meer info ›

RXML parse error: No current scope.
 | &_.counter;
 | <script type="text/javascript">

RXML parse error: No current scope.
 | &_.value;

" />

[[zzsearch1fortooshort]]