News
CQWP_Query:
SELECT
TOP 75
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
,
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( '11082' ,0 ) )
AND hiddenchild <> 1
-- Parent = 11082
Order by Isnull(showfrom, addDate) DESC
Venteville, supplies systems for ballast water treatment and...
Imtech Marine has been awarded a contract to supply the hybrid...
Imtech Marine has been awarded the contract for the design,...
Imtech Marine will be present at Europort 2011 (8-11 November,...
Imtech announces that Imtech Marine will be involved in the...
Air conditioning systems require regular maintenance. On ships...
Imtech Marine announces the opening of a new office in the Algeciras-Strait...
Imtech N.V. is expanding its marine services network with a...
Imtech N.V. announces that Her Royal Highness the Queen of the...
Imtech N.V. announces the acquisition of the Canadian marine...
Imtech is observing a substantial increase in the number of...
Imtech Marine, developed an IPTV based crew entertainment solution...
Pole Star and Radio Holland signed a Distributor contract to...
Radio Holland Connect, the connectivity competence center of...
Recently Imtech received the order for Amels build number 6503,...
West Coast Shipyard-led Team to Highlight World-Class Resources,...
Imtech Marine will launch its modular and flexible concept “Multiflex"....
Imtech Marine, through its member Radio Holland, is the first...
The renowned VHF Sailor RT-2048 VHF that has been in the market...
Imtech Marine France will be present at the Antibes Yacht Show,...
Imtech Marine announces its new 2011 - 2015 growth strategy....
Imtech has received a major order from the German shipyard Meyer...
Imtech Schiffbau-/Dockbautechnik has been awarded a contract...
Radio Holland Netherlands and Spliethoff’s Bevrachtingskantoor...
Imtech has received new orders for new and existing ships from...
Imtech Marine is present at the oil & gas industry exhibition...
Imtech N.V. is acquiring the Turkish maritime technical service...
At SMM, Imtech Marine will present a unique live satellite connection...
Imtech is observing a recovery of the technological maritime...
On 24th June, Imtech Marine & Offshore organised an event...
With the Zero Emission Ships initiative Imtech Marine Group...
Imtech has developed a new Electronic Chart Display and Information...
Imtech N.V. announces that it is acting as technology partner...
Imtech Marine Group has appointed Arjan Kleinveld as Managing...
Radio Holland USA (Houston, TX) – Radio Holland USA has...
Imtech Schiffbau-/Dockbau-technik, headquartered in Hamburg/Germany,...
Imtech (technical services provider in Europe) is celebrating...
Radio Holland Connect introduces the VSAT Prepaid Calling Card....
Imtech has been awarded a design & build contract for the...
Radio Holland Group announces the official opening of a new...
The Board of Management of Imtech (technical services provider...
Van Berge Henegouwen Installaties announces two valuable new...
At the Monaco Yacht show (23-26 September) four companies of...
With the recently signed contract for the RRS system on the...
IMG will be at the Norshipping exhibition in Oslo. At Norshipping,...
Imtech has recently acquired orders from various ship owners...
Imtech has received an order from Meyer Werft, a German ship...
Radio Holland Group announces the official opening of a new...
RH introduces the Falcon-line at the Construction & Shipping...
Marine electrical system integration contractor Imtech Marine...
Imtech has been awarded the contract by the F125 work group...
Radio Holland Group announces that per 15th January 2009, the...
A new Radio Holland service location in the southern part of...
Imtech Deutschland is to play a part in refitting the first...
On Thursday 23 October the Alderman of Economics, Harbour and...
As of 1st November Pieter Bloemendaal will become Managing Director...
On 8 October the Radio Holland Group (Rotterdam) signed a contract...
Imtech announces that it has been commissioned to provide the...