All The Love We Lost

Vass Corporation
All The Love We Lost

Label: Kay Dee
Code: KD 018
Style: Soul, Funk
Media: Vinyl
Format: 7" Usa
Out of Stock
Price: € 10,90
Tracklist
1
One More Day ( Kenny Dope Mix )
2
All The Love We Lost ( Kenny Dope Mix )
Recommended
    Query Error: # prodotti selezionati manualmente in recommended SELECT DISTINCT P.IDP, P.DISPONIBILITA, P.PREZZO, P.MARCA, P.TBA, P.DATA, PL.NOME, PL.DESCRIZIONE, S.NOME AS NOME_SUP, F.NOME AS NOME_FORMATO, M.NOME AS NOME_MARCA, 0 AS ORDINE, PR.ORDINE AS ORDHP FROM EC_PRODOTTI AS P INNER JOIN EC_PRODOTTI_RECOMMENDED AS PR ON P.IDP=PR.RECOMMENDED AND PR.PRODOTTO=72054 INNER JOIN EC_PRODOTTI_LANG AS PL ON P.IDP=PL.PRODOTTO AND PL.LINGUA=2 LEFT JOIN EC_SUPPORTI AS S ON P.SUPPORTO=S.IDS LEFT JOIN EC_FORMATI AS F ON P.FORMATO=F.IDF LEFT JOIN EC_MARCHE AS M ON P.MARCA=M.IDM INNER JOIN EC_PRODOTTI_CATEGORIE AS PC ON PC.PRODOTTO=P.IDP WHERE P.ATTIVO=1 AND P.DISPONIBILITA>=1 AND P.IDP<>72054 UNION # prodotti delle stesse categorie SELECT DISTINCT P.IDP, P.DISPONIBILITA, P.PREZZO, P.MARCA, P.TBA, P.DATA, PL.NOME, PL.DESCRIZIONE, S.NOME AS NOME_SUP, F.NOME AS NOME_FORMATO, M.NOME AS NOME_MARCA, 1 AS ORDINE, 0 AS ORDHP FROM EC_PRODOTTI AS P INNER JOIN EC_PRODOTTI_LANG AS PL ON P.IDP=PL.PRODOTTO AND PL.LINGUA=2 LEFT JOIN EC_SUPPORTI AS S ON P.SUPPORTO=S.IDS LEFT JOIN EC_FORMATI AS F ON P.FORMATO=F.IDF LEFT JOIN EC_MARCHE AS M ON P.MARCA=M.IDM INNER JOIN EC_PRODOTTI_CATEGORIE AS PC ON PC.PRODOTTO=P.IDP WHERE P.ATTIVO=1 AND P.IDP<>72054 AND DISPONIBILITA>=1 AND ( PC.CATEGORIA=122 OR PC.CATEGORIA=151) UNION # Prodotti in evidenza in home page SELECT DISTINCT P.IDP, P.DISPONIBILITA, P.PREZZO, P.MARCA, P.TBA, P.DATA, PL.NOME, PL.DESCRIZIONE, S.NOME AS NOME_SUP, F.NOME AS NOME_FORMATO, M.NOME AS NOME_MARCA, 2 AS ORDINE, P.ORDERHP AS ORDHP FROM EC_PRODOTTI AS P INNER JOIN EC_PRODOTTI_LANG AS PL ON P.IDP=PL.PRODOTTO AND PL.LINGUA=2 LEFT JOIN EC_SUPPORTI AS S ON P.SUPPORTO=S.IDS LEFT JOIN EC_FORMATI AS F ON P.FORMATO=F.IDF LEFT JOIN EC_MARCHE AS M ON P.MARCA=M.IDM INNER JOIN EC_PRODOTTI_CATEGORIE AS PC ON PC.PRODOTTO=P.IDP WHERE P.ATTIVO=1 AND P.IDP<>72054 AND DISPONIBILITA>=1 AND P.HOMEPAGE=1 #ordinamento e limit ORDER BY ORDINE, ORDHP, RAND(), DISPONIBILITA DESC, DATA, IDP DESC LIMIT 6 #LIMIT 20
    Error:Query execution was interrupted