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='120' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
- Distillers tours
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='82' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
- Wandelingen & Tours
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='134' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
- Bedrijfsuitjes
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='81' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
- Rondvaarten
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='85' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
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='84' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
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='88' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam