Søgeresultat : Snaps

select profile.id, profile.status, unix_timestamp(new_date) as unix_new, profile.name as profile_name, profile.img_path, profile.short_name, profile.summary, profile.username, profile.address, profile.zip, zip_city.city, other.name, profile.xpon_card from profile left join (zip_city) on (profile.zip=zip_city.zip) left outer join (profile_other) on (profile_other.profile_id=profile.id) left outer join (other) on (profile_other.other_id=other.id) left join (profile_district) on (profile_district.profile_id=profile.id) left join (district) on (profile_district.district_id=district.id) where profile.status !="inactive" and profile.status !="redirect" and (other.name="Restaurant" or other.name="Café" or ((other.name!="Bar") and (other.name!="Natklub") and (other.name!="Natklub/Diskotek") and (other.name!="Cocktailbar")) or other.name is null) and ((lower(profile.name) like "%Snaps%") or (lower(profile.short_name) like "%Snaps%") or (lower(profile.summary) like "%Snaps%") or (lower(profile.spellings) like "%Snaps%") or (lower(profile.address) like "%Snaps%") or (lower(zip_city.city) like "%Snaps%") or (lower(zip_city.city) like "%Snaps%") or (lower(zip_city.city) like "%Snaps%")) group by profile.id order by (profile.status="full") desc, ((profile.zip>=1000 and profile.zip<=2999) or (profile.zip>=3700 and profile.zip<=3799)) desc, ( profile.name like "Snaps%") desc, ( profile.name like "%Snaps%") desc, rand() limit 11

Spisesteder

Snapstinget

København K

Told & Snaps

København K

Snapstinget

Kolding

Natteliv

Bar7

København K

Grønttorvet

Odense C

Holms Restaurant

Middelfart

Guides

Aktuelt

Opskrifter

 

 

 

 

Nyhedsbrev

Modtag det ugentlige nyhedsbrev fra Spiseliv med inspiration til madoplevelser – ude og hjemme.