Reply to thread

Message

<blockquote data-quote="Dragy" data-source="post: 823839" data-attributes="member: 91197">Ik heb zojuist de api geüpdate. Nu wordt alles van nettv EN van de ipad weergegeven. Was nog een heel gedoe om het voor elkaar te krijgen dat er geen dubbele videos tussen kwamen. Voor de geeks, zo was het eerst:[code]SELECT&nbsp; &nbsp; &nbsp; &nbsp; IF(serienaam = title, serienaam, CONCAT(serienaam, &quot; - &quot;, title)) as title,&nbsp; &nbsp; &nbsp; &nbsp; DATE_FORMAT(broadcastdatetime, &quot;%e-%m-%Y %H:%i&quot;) as date,&nbsp; &nbsp; &nbsp; &nbsp; CONCAT(&quot;Zender: &quot;, UPPER(station),&quot;\n&quot;, &quot;Titel: &quot;, title, &quot;\n&quot;, samenvattinglang) as beschrijving,&nbsp; &nbsp; &nbsp; &nbsp; CONCAT(&quot;http://iptv.rtl.nl/xl/Images/512/288/&quot;,thumbnail) as thumbnail,&nbsp; &nbsp; &nbsp; &nbsp; CONCAT(&quot;http://iptv.rtl.nl/ipadxlapp/&quot;,movie) as movie,&nbsp; &nbsp; &nbsp; &nbsp; classname as extra&nbsp; &nbsp; FROM items&nbsp; &nbsp; WHERE &nbsp; &nbsp; &nbsp; &nbsp; DATE(broadcastdatetime) = DATE(NOW()) - INTERVAL '.$_GET['daysback'].' DAY&nbsp; &nbsp; ORDER BY broadcastdatetime DESC[/code]En nu:[code]SELECT * FROM &nbsp; &nbsp; (&nbsp; &nbsp; (SELECT &nbsp; &nbsp; &nbsp; &nbsp; IF(serienaam = title, serienaam, CONCAT(serienaam, &quot; - &quot;, title)) as title,&nbsp; &nbsp; &nbsp; &nbsp; DATE_FORMAT(broadcastdatetime, &quot;%e-%m-%Y %H:%i&quot;) as date,&nbsp; &nbsp; &nbsp; &nbsp; CONCAT(&quot;Zender: &quot;, UPPER(station),&quot;\n&quot;, &quot;Titel: &quot;, title, &quot;\n&quot;, samenvattinglang) as beschrijving,&nbsp; &nbsp; &nbsp; &nbsp; CONCAT(&quot;http://iptv.rtl.nl/xl/Images/512/288/&quot;,thumbnail) as thumbnail,&nbsp; &nbsp; &nbsp; &nbsp; CONCAT(&quot;http://iptv.rtl.nl/ipadxlapp/&quot;,movie) as movie,&nbsp; &nbsp; &nbsp; &nbsp; classname as extra,&nbsp; &nbsp; &nbsp; &nbsp; broadcastdatetime,&nbsp; &nbsp; &nbsp; &nbsp; &quot;ipadxlapp&quot; as tbl&nbsp; &nbsp; FROM items&nbsp; &nbsp; WHERE &nbsp; &nbsp; NOT EXISTS (&nbsp; &nbsp; &nbsp; &nbsp; SELECT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; FROM items_nettv&nbsp; &nbsp; &nbsp; &nbsp; WHERE items.uniqueid=items_nettv.uniqueid&nbsp; &nbsp; ))&nbsp; &nbsp; UNION&nbsp; &nbsp; (SELECT &nbsp; &nbsp; &nbsp; &nbsp; IF(serienaam = title, serienaam, CONCAT(serienaam, &quot; - &quot;, title)) as title,&nbsp; &nbsp; &nbsp; &nbsp; DATE_FORMAT(DATE_ADD(broadcastdatetime, INTERVAL 1 HOUR), &quot;%e-%m-%Y %H:%i&quot;) as date,&nbsp; &nbsp; &nbsp; &nbsp; CONCAT(&quot;Zender: &quot;, UPPER(station),&quot;\n&quot;, &quot;Titel: &quot;, title, &quot;\n&quot;, samenvattinglang) as beschrijving,&nbsp; &nbsp; &nbsp; &nbsp; CONCAT(&quot;http://iptv.rtl.nl/nettv/&quot;,thumbnail) as thumbnail,&nbsp; &nbsp; &nbsp; &nbsp; CONCAT(&quot;http://iptv.rtl.nl/nettv/&quot;,movie) as movie,&nbsp; &nbsp; &nbsp; &nbsp; classname as extra,&nbsp; &nbsp; &nbsp; &nbsp; DATE_ADD(broadcastdatetime, INTERVAL 1 HOUR) as broadcastdatetime,&nbsp; &nbsp; &nbsp; &nbsp; &quot;nettv&quot; as tbl&nbsp; &nbsp; FROM items_nettv)&nbsp; &nbsp; ) as t &nbsp; &nbsp; WHERE &nbsp; &nbsp; &nbsp; &nbsp; DATE(broadcastdatetime) = DATE(NOW()) - INTERVAL '.$_GET['daysback'].' DAY&nbsp; &nbsp; ORDER BY broadcastdatetime DESC[/code]Ik weet niet of dit optimaal is, maar het werkt <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" /></blockquote>

[QUOTE="Dragy, post: 823839, member: 91197"] Ik heb zojuist de api geüpdate. Nu wordt alles van nettv EN van de ipad weergegeven. Was nog een heel gedoe om het voor elkaar te krijgen dat er geen dubbele videos tussen kwamen. Voor de geeks, zo was het eerst: [code]SELECT IF(serienaam = title, serienaam, CONCAT(serienaam, " - ", title)) as title, DATE_FORMAT(broadcastdatetime, "%e-%m-%Y %H:%i") as date, CONCAT("Zender: ", UPPER(station),"\n", "Titel: ", title, "\n", samenvattinglang) as beschrijving, CONCAT("http://iptv.rtl.nl/xl/Images/512/288/",thumbnail) as thumbnail, CONCAT("http://iptv.rtl.nl/ipadxlapp/",movie) as movie, classname as extra FROM items WHERE DATE(broadcastdatetime) = DATE(NOW()) - INTERVAL '.$_GET['daysback'].' DAY ORDER BY broadcastdatetime DESC[/code] En nu: [code]SELECT * FROM ( (SELECT IF(serienaam = title, serienaam, CONCAT(serienaam, " - ", title)) as title, DATE_FORMAT(broadcastdatetime, "%e-%m-%Y %H:%i") as date, CONCAT("Zender: ", UPPER(station),"\n", "Titel: ", title, "\n", samenvattinglang) as beschrijving, CONCAT("http://iptv.rtl.nl/xl/Images/512/288/",thumbnail) as thumbnail, CONCAT("http://iptv.rtl.nl/ipadxlapp/",movie) as movie, classname as extra, broadcastdatetime, "ipadxlapp" as tbl FROM items WHERE NOT EXISTS ( SELECT 1 FROM items_nettv WHERE items.uniqueid=items_nettv.uniqueid )) UNION (SELECT IF(serienaam = title, serienaam, CONCAT(serienaam, " - ", title)) as title, DATE_FORMAT(DATE_ADD(broadcastdatetime, INTERVAL 1 HOUR), "%e-%m-%Y %H:%i") as date, CONCAT("Zender: ", UPPER(station),"\n", "Titel: ", title, "\n", samenvattinglang) as beschrijving, CONCAT("http://iptv.rtl.nl/nettv/",thumbnail) as thumbnail, CONCAT("http://iptv.rtl.nl/nettv/",movie) as movie, classname as extra, DATE_ADD(broadcastdatetime, INTERVAL 1 HOUR) as broadcastdatetime, "nettv" as tbl FROM items_nettv) ) as t WHERE DATE(broadcastdatetime) = DATE(NOW()) - INTERVAL '.$_GET['daysback'].' DAY ORDER BY broadcastdatetime DESC[/code] Ik weet niet of dit optimaal is, maar het werkt :P [/QUOTE]

Verification