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='121' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Gin 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='97' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Evenement/theater/concert
  • 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='99' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • Arrangement met varen
  • 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='98' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam
  • tours/workshop
  • 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='96' AND i_oms!='' ORDER BY t_volgorde,t_tag , i_naam