Teatro Olympia
SELECT * FROM ((SELECT * FROM ((SELECT * FROM ((SELECT outstandings.target,outstandings.idOutstanding,outstandings.idType,outstandings.outOrder,events.idEvent as idRel,events.name_100,events.brief_100,events.link,events.content_100, outstandings.inhome FROM outstandings INNER JOIN events ON outstandings.idRel=events.idEvent WHERE outstandings.idType=1 AND outstandings.active=1 AND outstandings.idSpace=2 AND (outstandings.publishStart=STR_TO_DATE(“08/04/2021″,”%d/%m/%Y”))) UNION (SELECT outstandings.target,outstandings.idOutstanding,outstandings.idType,outstandings.outOrder,articles.idArticle as idRel,articles.name_100,articles.brief_100,articles.originalSource as link,articles.content_100, outstandings.inhome FROM outstandings INNER JOIN articles ON outstandings.idRel=articles.idArticle WHERE outstandings.idType=2 AND outstandings.active=1 AND outstandings.idSpace=2 AND (outstandings.publishStart=STR_TO_DATE(“08/04/2021″,”%d/%m/%Y”)))) TABLA ) UNION … Read more