dibi::test mi netiskne subquery a vse za nim

Dobrý den,
nejde mi do hlavy proč při tomto dotazu:

$res = dibi::test('
      SELECT *, COUNT(vps_index) AS [count]
      FROM [visitor_states] AS [vs]
      WHERE ([vps_index] =%s', $vps_index,')
      AND
      [date] >=%s',$date,'
      AND ( SELECT [id] FROM [visitors] WHERE [session_id] = [vs].[visitors_session_id] AND [pojistnik_prijmeni] LIKE '%uzivatel%')
      GROUP BY [value]
    ');

    die();

se mi do prohlížeče vytiskne:

SELECT *, COUNT(vps_index) AS `count`
FROM `visitor_states` AS `vs`
WHERE (`vps_index` ='utm_source' )
 AND
 `date` >='2011-04-01' 0

Nevim proc je za „date“ ta nula a proc to nevytiskne ten subdotaz a vse co je za nim?

Dekuji