(mysqli):
SELECT
nodes.*,
DATE_FORMAT( nodes.CreationDate, '%Y. %M %e. %H:%i' ) AS CreationDate,
DATE_FORMAT( nodes.StartDate, '%Y. %M %e.' ) AS StartDate,
img.Id AS ImgId,
CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), img.Id, '_', img.FileName ) AS ImgPath,
img.Name AS ImgName,
users.Id AS OwnerId,
users.Name AS OwnerName
FROM nodes
LEFT JOIN
users ON
nodes.CreationUserId = users.Id AND
users.Deleted IS NULL
LEFT JOIN node_image ON node_image.NodeId = nodes.Id
LEFT JOIN attachments AS img ON img.ParentId = node_image.AttachmentId AND img.CopyId = 2
WHERE
nodes.TypeId = 24 AND
nodes.Deleted IS NULL AND
( nodes.StartDate IS NULL OR nodes.StartDate <= NOW() ) AND
( nodes.EndDate IS NULL OR nodes.EndDate > NOW() ) AND
nodes.Public IS NOT NULL AND
nodes.StrId = 'inditvany_az_orszaggyules_rendkivuli_ulesszakanak_osszehivasara_2010._junius_14._'
LIMIT 1
(mysqli): SELECT Name, StrId FROM tags, node_tag WHERE tags.Id = node_tag.TagId AND tags.Deleted IS NULL AND node_tag.NodeId = 1393
(mysqli): UPDATE nodes SET ViewCounter = 1 + IFNULL( ViewCounter, 0 ) WHERE Id = 1393
(mysqli):
SELECT SQL_CALC_FOUND_ROWS
nodes.*,
DATE_FORMAT( nodes.CreationDate, '%Y. %M %e. %H:%i' ) AS CreationDate,
DATE_FORMAT( nodes.StartDate, '%Y. %M %e.' ) AS StartDate,
IFNULL( nodes.StartDate, nodes.CreationDate ) AS pubDate,
img.Id AS ImgId,
CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), img.Id, '_', img.FileName ) AS ImgPath,
img.Name AS ImgName,
node_types.StrId AS TypeStrId,
node_types.Detail AS DetailStrId,
users.Id AS OwnerId,
users.Name AS OwnerName
FROM
node_types,
nodes
LEFT JOIN
users ON
nodes.CreationUserId = users.Id
AND
users.Deleted IS NULL
LEFT JOIN node_image ON node_image.NodeId = nodes.Id
LEFT JOIN attachments AS img ON img.ParentId = node_image.AttachmentId AND img.CopyId = 1
WHERE
node_types.Id = 24
AND
node_types.Id = nodes.TypeId
AND
nodes.Deleted IS NULL
AND
( nodes.StartDate IS NULL OR nodes.StartDate <= NOW() )
AND
( nodes.EndDate IS NULL OR nodes.EndDate > NOW() )
AND
nodes.Public IS NOT NULL
AND
nodes.Id <> 1393
GROUP BY
nodes.Id
ORDER BY
pubDate DESC
LIMIT 3
OFFSET 0
Indítvány az Országgyűlés rendkívüli ülésszakának összehívására (2010. június 14.)
