Exhibitions
CQWP_Query:
SELECT
TOP 50
Nr,
Case
when (CTSpecificVar30Im2 = 'NL' and len(CTSpecificVar200Im2)>1)
then CTSpecificVar200Im2
when (CTSpecificVar30Im3 = 'NL' and len(CTSpecificVar200Im1)>1)
then CTSpecificVar200Im1
when (CTSpecificVar30Im4 = 'NL' 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 = 'NL' and len(CTSpecificVar200Im2)>1)
then CTSpecificTextIm1
when (CTSpecificVar30Im3 = 'NL' and len(CTSpecificVar200Im1)>1)
then CTSpecificTextIm9
when (CTSpecificVar30Im4 = 'NL' and len(CTSpecificVar200Im5)>1)
then CTSpecificTextIm10
else description
End as description
,
RTRIM(SUBSTRING(Isnull(CTSpecificTextIm1, description), 1, (CHARINDEX(' ', Isnull(CTSpecificTextIm1, description) + SPACE(60), 60)))) as ShortDescription,
ShortDescriptionSuffix = CASE WHEN (LEN(Isnull(CTSpecificTextIm1, description)) >= 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
22 - 24 February 2010 in Stamford, Connecticut (USA)
16 - 18 March 2010 in Hong Kong
16 - 18 March in Cape Town (South Africa)
16 - 18 March 2010 in Cape Town (South Africa)
24 - 26 March 2010 in Singapore
12 - 15 April 2010 in Johannesburg (South Africa)
30 April - 2 May 2010 in Durban (South Africa)
3 - 6 May in Houston (USA)
7 - 9 May 2010 in Hong Kong
24 - 26 May 2010 in Dubai (United Arab Emirates)
13 - 15 August 2010 in Johannesburg (South Africa)
17 - 20 August in Trondheim (Norway)
31 August - 2 September 2010 in Johanesburg (South Africa)
7 - 10 September 2010 in Hamburg (Germany)
22 - 25 September in Port Hercules (Monaco)
8 - 10 October 2010 in Cape Town (South Africa)
28 October - 1 November 2010 in Ft. Lauderdale (USA)
16 - 18 November in Amsterdam (Netherlands)
30 November - 3 December in Singapore
1 - 3 December 2010 in New Orleans (USA)
