Exhibitions

CQWP_Query: SELECT TOP 50 Nr, Case when (CTSpecificVar30Im2 = 'EN' and len(CTSpecificVar200Im2)>1) then CTSpecificVar200Im2 when (CTSpecificVar30Im3 = 'EN' and len(CTSpecificVar200Im1)>1) then CTSpecificVar200Im1 when (CTSpecificVar30Im4 = 'EN' and len(CTSpecificVar200Im5)>1) then CTSpecificVar200Im5 else title End as title , target = CASE WHEN target IS NOT NULL THEN 'target="' + target + '"' ELSE '' END , ISNULL(ShowFrom,Adddate) as ShowFrom, Case when (CTSpecificVar30Im2 = 'EN' and len(CTSpecificVar200Im2)>1) then CTSpecificTextIm1 when (CTSpecificVar30Im3 = 'EN' and len(CTSpecificVar200Im1)>1) then CTSpecificTextIm9 when (CTSpecificVar30Im4 = 'EN' and len(CTSpecificVar200Im5)>1) then CTSpecificTextIm10 else description End as description , contenttype , CASE WHEN contenttype = 21 THEN ISNULL(ShowFrom,Adddate) ELSE null END AS newsDate ,CTSpecificDate2, RTRIM(SUBSTRING( Case when (CTSpecificVar30Im2 = 'EN' and len(CTSpecificVar200Im2)>1) then CTSpecificTextIm1 when (CTSpecificVar30Im3 = 'EN' and len(CTSpecificVar200Im1)>1) then CTSpecificTextIm9 when (CTSpecificVar30Im4 = 'EN' and len(CTSpecificVar200Im5)>1) then CTSpecificTextIm10 else description End , 1, (CHARINDEX(' ', Case when (CTSpecificVar30Im2 = 'EN' and len(CTSpecificVar200Im2)>1) then cast(CTSpecificTextIm1 as varchar(200)) when (CTSpecificVar30Im3 = 'EN' and len(CTSpecificVar200Im1)>1) then cast(CTSpecificTextIm9 as varchar(200)) when (CTSpecificVar30Im4 = 'EN' and len(CTSpecificVar200Im5)>1) then cast(CTSpecificTextIm10 as varchar(200)) else description End + SPACE(60), 60)))) as ShortDescription, ShortDescriptionSuffix = CASE WHEN (LEN( Case when (CTSpecificVar30Im2 = 'EN' and len(CTSpecificVar200Im2)>1) then cast(CTSpecificTextIm1 as varchar(200)) when (CTSpecificVar30Im3 = 'EN' and len(CTSpecificVar200Im1)>1) then cast(CTSpecificTextIm9 as varchar(200)) when (CTSpecificVar30Im4 = 'EN' and len(CTSpecificVar200Im5)>1) then cast(CTSpecificTextIm10 as varchar(200)) else description End ) >= 60 AND 1 = 1) THEN '...' ELSE '' END FROM vwActive_DEF WHERE Nr IN (Select nr from dbo.fn_RecurseChildren( '17261' ,0 ) ) -- Parent = 17261 Order by Sortindex

National Boat Show (August 13 2010)

13 - 15 August 2010 in Johannesburg (South Africa)

NORFishing (August 17 2010)

17 - 20 August in Trondheim (Norway)

IFSEC South Africa Securex (August 31 2010)

31 August - 2 September 2010 in Johanesburg (South Africa)

SMM 2010 (September 7 2010)

7 - 10 September 2010 in Hamburg (Germany)

Monaco Yachtshow (September 22 2010)

22 - 25 September in Port Hercules (Monaco)

Cape Town International Boatshow (October 8 2010)

8 - 10 October 2010 in Cape Town (South Africa)

Ft Lauderdale Boatshow (October 28 2010)

28 October - 1 November 2010 in Ft. Lauderdale (USA)

METS (November 16 2010)

16 - 18 November in Amsterdam (Netherlands)

OSEA (November 30 2010)

30 November - 3 December in Singapore

International Boatshow (December 1 2010)

1 - 3 December 2010 in New Orleans (USA)