elektromos taxi

2017. február 16. 09:53
Néhány év múlva akár teljesen eltűnhetnek a hagyományos meghajtású taxik Budapestről.
(SELECT nodes.StrId, nodes.Title, nodes.SubTitle, nodes.MediumId, nodes.Lead, nodes.Link, nodes.UTDate, (SELECT StrId FROM nodes AS parnodes WHERE parnodes.Id=nodes.ParentId) AS ParentStrId, DATE_FORMAT( nodes.CreationDate, '%Y. %M %e. %H:%i' ) AS CreationDate, DATE_FORMAT( nodes.StartDate, '%Y. %M %e. %H:%i' ) AS StartDate, IFNULL( nodes.StartDate, nodes.CreationDate ) AS pubDate, nodes.SubdomainId, NULL AS HostName, 'http://mandiner.hu' AS Host FROM node_tag JOIN nodes ON node_tag.NodeId = nodes.Id 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.Deleted IS NULL WHERE node_tag.TagId = 18 ORDER BY UTDate DESC LIMIT 500 ) UNION (SELECT nodes.StrId, nodes.Title, nodes.SubTitle, nodes.MediumId, nodes.Lead, nodes.Link, nodes.UTDate, (SELECT StrId FROM nodes AS parnodes WHERE parnodes.Id=nodes.ParentId) AS ParentStrId, DATE_FORMAT( nodes.CreationDate, '%Y. %M %e. %H:%i' ) AS CreationDate, DATE_FORMAT( nodes.StartDate, '%Y. %M %e. %H:%i' ) AS StartDate, IFNULL( nodes.StartDate, nodes.CreationDate ) AS pubDate, nodes.SubdomainId, subdomains.Name AS HostName, CONCAT('http://', subdomains.StrId,'.mandiner.hu') AS Host FROM `mandiner_subdomains`.node_tag JOIN `mandiner_subdomains`.nodes ON node_tag.NodeId = nodes.Id 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.Deleted IS NULL JOIN `mandiner`.subdomains ON subdomains.Id=nodes.SubdomainId WHERE node_tag.TagId = 18 ORDER BY UTDate DESC LIMIT 500) ORDER BY UTDate DESC LIMIT 18 OFFSET 0