SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__arena_zpravy` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t0.cck = 'zpravy'
  AND t1.priznak IN (2)
  AND t1.platna = 1
ORDER BY t1.datum DESC
LIMIT 100

0.032 seconds (0.032); 21.06 MB (21.059) - afterSearch [Cache=OFF] = 0 result.
0.032 seconds (0.000); 21.06 MB (0.002) - afterRender

Veřejné zakázky