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, profile.xpon_card from profile left join (zip_city) on (profile.zip=zip_city.zip) where profile.status !="inactive" and xpon_card=1 and profile.zip>=5000 and profile.zip<=5999 group by profile.id order by rand() Spisegavekortet | Fyn

Fyn

Kong Volmer

Dansk, Smørrebrød | Odense C

Skovbakken

Dansk, Fransk, ... | Odense C

Sortebro Kro

Dansk, Fransk, ... | Odense S

Teglværksskoven

Dansk, Fransk | Nyborg