V roce 2016 vyšla obsáhlá kompilace největších hitů Phila Collinse ve variantách 2CD, 3CD a 4LP. Tato 2LP verze je zkráceným výběrem zmíněné kompilace.
LP 1
1. In The Air Tonight (2015 Remastered) [5:35]
2. I Missed Again (2015 Remastered) [3:46]
3. You Can't Hurry Love (2016 Remastered) [2:50]
4. Against All Odds (Take A Look At Me Now) [2016 Remastered] [3:23]
5. Easy Lover [5:03]
6. Sussudio (2016 Remastered) [4:23]
7. One More Night (2016 Remastered) [4:47]
8. Separate Lives (Love Theme From White Nights) [2016 Remastered] [4:06]
9. A Groovy Kind Of Love (2016 Remastered) [3:28]
10. Two Hearts (2016 Remastered) [3:25]
LP 2
1. Another Day In Paradise (2016 Remastered) [5:23]
2. I Wish It Would Rain Down (2016 Remastered) [5:28]
3. Something Happened On The Way To Heaven (2016 Remastered) [4:52]
4. Do You Remember? (2016 Remastered) [4:36]
5. Both Sides Of The Story (2015 Remastered) [6:43]
6. Dance Into The Light (2016 Remastered) [4:25]
7. True Colors (2016 Remastered) [4:33]
8. Can't Stop Loving You (2016 Remastered) [4:17]
9. (Love Is Like A) Heatwave (2016 Remastered) [2:52]
Chyba při dotazu "select p.* from
(
select distinct on (p.seskupeni) p.seskupeni,p.* from
(
select p.*,dph.hodnota as hodnota_dph,
(
select polozky2produkty.polozka from polozky2produkty
left join polozky_parametru pp on polozky2produkty.polozka=pp.id
where produkt=p.id and parametr=8 limit 1
) as nosic_id, v.cena_eshop as cena_order, pt.nazev as nazev_order, pt.nazev, vt.nazev as v_nazev ,
pt.popis, v.kat_cislo, v.cena_eshop,v.cena_nakupni, v.cena_maloobchodni,
(
select sum(zakoupeno_aktualne) from varianty where varianty.produkt=p.id limit 1
) as zakoupeno_aktualne,
(
select sum(skladem) from varianty where varianty.produkt=p.id limit 1
) as skladem,
CASE WHEN (
select sum(skladem) from varianty where varianty.produkt=p.id limit 1
) > 0 THEN 1 ELSE 0 END as jeskladem,
(
select sum(stav) from prodejny_stav where prodejny_stav.varianta=v.id and prodejny_stav.prodejna<>5100 limit 1
) as sklademprodejny
from produkty p
left join produkty_text pt on p.id=pt.produkt
left join dph on p.dph=dph.id
left join varianty v on v.id=p.hl_varianta
left join varianty_text vt on v.id=vt.varianta
WHERE pt.mutace=2 and vt.mutace=2
and p.viditelny = 1 and p.id != 903932 and ( (1=2) or (p.id='853020853019853021') )
) as p
order by seskupeni,p.id
) as p
order by datum_vydani desc nulls last limit 6 offset 0" do databáze
ERROR: value "853020853019853021" is out of range for type integer
LINE 30: ...elny = 1 and p.id != 903932 and ( (1=2) or (p.id='853020853...
^
Nastala chyba. Omlouváme se.