SELECT * FROM sdamkoppel LEFT JOIN sdamitem ON k_item=i_id LEFT JOIN sdamtag ON k_tag=t_id WHERE i_actief=1 and k_tag='32' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Overnachten
  • SELECT * FROM sdamkoppel LEFT JOIN sdamitem ON k_item=i_id LEFT JOIN sdamtag ON k_tag=t_id WHERE i_actief=1 and k_tag='27' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Koffie- en theesalons
  • SELECT * FROM sdamkoppel LEFT JOIN sdamitem ON k_item=i_id LEFT JOIN sdamtag ON k_tag=t_id WHERE i_actief=1 and k_tag='28' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Lunch & snacks
  • SELECT * FROM sdamkoppel LEFT JOIN sdamitem ON k_item=i_id LEFT JOIN sdamtag ON k_tag=t_id WHERE i_actief=1 and k_tag='29' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Restaurants
  • SELECT * FROM sdamkoppel LEFT JOIN sdamitem ON k_item=i_id LEFT JOIN sdamtag ON k_tag=t_id WHERE i_actief=1 and k_tag='30' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Eetcafés
  • SELECT * FROM sdamkoppel LEFT JOIN sdamitem ON k_item=i_id LEFT JOIN sdamtag ON k_tag=t_id WHERE i_actief=1 and k_tag='31' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Borrelen en uitgaan
  • SELECT * FROM sdamkoppel LEFT JOIN sdamitem ON k_item=i_id LEFT JOIN sdamtag ON k_tag=t_id WHERE i_actief=1 and k_tag='145' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Flex studie- en werkplek
  • SELECT * FROM sdamkoppel LEFT JOIN sdamitem ON k_item=i_id LEFT JOIN sdamtag ON k_tag=t_id WHERE i_actief=1 and k_tag='26' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Zaalverhuur