Home B-movie & trasherie Fatal frames - Fotogrammi mortali

Fatal frames - Fotogrammi mortali Fatal frames - Fotogrammi mortali
Categoria B-movie & trasherie
Tipologia Lungometraggio
Genere Horror, Thriller
Parole chiave Serial Killer

Regia: Al Festa
Cast:
Stefania Stella, Rick Gianasi, David Warbeck, Linnea Quigley, Ugo Pagliai, Giorgio Albertazzi, Donald Pleasence, Alida Valli, Ciccio Ingrassia, Rossano Brazzi, Angus Scrimm
Sceneggiatura Al Festa, Alessandro Monese, Mary Rinaldi
Colonna Sonora Al Festa
Anno: 1996
Nazione: Italia
Durata: 125 minuti
In breve:
Un omaggio (piuttosto maldestro) al glorioso thriller italiano dei tempi andati
Visite: 3374

Il Film


CARATTERISTICHE DEL FILM:

Stile: “videoclipparo” e patinatissimo
Ritmo: memore dei gloriosi gialli del passato
Humour: perenne ma involontario
Tensione: suspense e fiato sospeso
Erotismo: anni ‘80
Violenza: sufficiente
Sangue: in buona dose

 

Recensione:

Thriller in “Festa”

Come rendere omaggio al glorioso thriller italiano dei tempi andati senza capirne l'essenza ne tantomeno le regole che lo resero così particolare.

Arrivato da New York a Roma per dirigere un videoclip della cantante Stefania Stella, il regista Alex Ritt (Gianasi) assiste più o meno direttamente alle imprese di un serial killer cinefilo.

Film dalle premesse nobili, dalle location sontuose (il comune di Roma ha autorizzato a girare a Fontana di Trevi, a Castel S.Angelo e persino sotto il Colosseo) e vincitore del gran premio Lucio Fulci alla XVI edizione del Fantafestival. Nella sostanza però si assiste a qualcosa di ben diverso: un'opera scritta e diretta da Festa in funzione totalmente promozionale della compagna Stefania Stella, convinta(si) a sfondare come cantante pop internazionale, e niente più. Si susseguono, attraverso una sceneggiatura scolastica, una serie di attori di calibro inspiegabilmente coinvolti nel folle progetto: David Warbeck, Ugo Pagliai, Alida Valli, Giorgio Albertazzi, Ciccio Ingrassia, Rossano Brazzi, Angus Scrimm e persino il povero Donald Pleasance (che morirà durante le riprese, costringendo il regista ad una soluzione cinematografica al limite della farsa).

Fotografato per circa 120 minuti (nella snervante versione tedesca, integrata persino con dialoghi aggiuntivi) sotto discutibili luci tagliate, Fatal Frames rappresenta l'amara occasione mancata per chi credeva che il cinema di genere Italiano potesse rinascere dopo oltre vent'anni. Molto meglio faranno anni dopo Paolo Sorrentino con L'amico di famiglia (2005) o Eros Puglielli con Occhi di cristallo (2003), consci di dover aggiornare le tematiche rispettando le regole visive e narrative del giallo. Merito comunque alle musiche, perfettamente integrate nei momenti più topici della storia e mai fini ad un semplice compiacimento autoriale. Attualmente Fatal Frames resta l'ultimo lungometraggio realizzato da Al Festa (prodotto dalla stessa Stefania Stella, al secolo Stefania di Giandomenico), che in futuro sarà ricordato anche e soprattutto per aver ispirato - a detta dello stesso autore Alberto Farina - il titolo del suo saggio sul cinema exploitation Sparate sul regista! (ed. Il Castoro, 1997). (Jacopo Coccia)

 

Da notare- Nella prolifica attività musicale di Al Festa sono da ricordare le accattivanti colonne sonore di After Death di Claudio Fragasso e di diversi lavori del grande Bruno Mattei (Robowar, Nato per combattere e Cop Game)

Perché su Bizzarro- coraggioso nel rappresentare, prima del new horror americano e delle rivalutazioni cinefile tarantiniane, un dovuto omaggio al grande cinema Italiano degli anni ‘70.

Film (più o meno) Simili: Cattive inclinazioni (2003) di Pierfrancesco Campanella.

 

NOTE:

Edizione italiana: fuori catalogo

Premi: premio Lucio Fulci al Fantafestival 1996

 

Scheda del film a cura di: Jacopo Coccia


1 Commento

Autore Commento
dbnispifs cialis online п»їcialis п»їcialis generic cialis cialis online
Commento inserito : Sun 24-05-20
Deannaceart The kit of viable multiplicity interproximal papillae Branded cialis Generic viagra online rather vexation of diuretic
http://sildenafilmen.com/

generic cialis for daily use
buy generic cialis
best place to buy cialis online
canadian pharmacies online

The chorion is holden to section rich and multicentric
Forward movement Plat vak
Correct Position vak
Correct Plat vak
Forgather Leaning vak
1f9ed32
Commento inserito : Fri 13-03-20
Homework Good Or Bad essays essays essays essay.com
Commento inserito : Thu 08-02-18
Spotloan personal loans personal loans personal loans bad credit personal loans with bad credit
Commento inserito : Thu 08-02-18
insurance quotes liberty auto insurance cheap auto insurance cheap auto insurance cheap auto insurance quotes
Commento inserito : Thu 08-02-18
Payday loan application loans companies online loan real payday loans online
Commento inserito : Mon 05-02-18
Getting A Loan personal loans personal loans for poor credit direct lending reviews independent payday lenders
Commento inserito : Mon 05-02-18
Personal Loans check cash advance fast cash advance short term lenders best personal loans online
Commento inserito : Sun 04-02-18
JamesPlurn payday loan direct lenders pay day loans same day payday loans online best payday loan brainfuse homework help school papers school papers school papers free webcam sluts free webcam girls cam chat free sex webcam payday loans direct lender payday loans direct lenders payday loans online direct lender direct payday loan lenders free xxx webcams free sexy webcams free webcams free xxx webcams
Commento inserito : Sun 04-02-18
JamesPlurn best payday loan best payday loan online the best online payday loans best payday loan real sex cam webcam amateur girl webcam free sex video chat payday loans online direct lender online payday loans direct lenders online payday loans direct lenders instant loans online nude shows free bbw cams free webcam porn free webcam porn online payday loan application payday cash advances payday loans online direct lender easy online payday loans free cam porn web cam sex chat free cam porn free cam porn 10 top loan companies online payday advance loan quick loan cash advance loan
Commento inserito : Sat 03-02-18
Online Lenders best personal loans loan till payday payday advances online unsecured personal loans
Commento inserito : Fri 02-02-18
JamesPlurn free sex cam chat free sex cam chat free sex cam chat free sex cam chat money loan money loan payday loan a payday loan instant loans online bad credit small online payday loans payday loans online direct lenders bad credit payday loans direct lenders bad credit payday loans direct lenders bad credit payday loans direct lenders bad credit payday loans direct lenders payday loan direct lenders 15 minute loans direct lenders payday lenders direct payday lenders direct free webcam sex chat live webcams sex free webcam sex free webcam sex primary homework help ancient greece buy essays buy essays buy essays online
Commento inserito : Fri 02-02-18
Loan Cash bad credit installment loans guaranteed next day loans bad credit installment loans installment loans
Commento inserito : Thu 01-02-18
JamesPlurn online payday advance cash loans quick loans 100 approval cash loans online payday loans cash loans online direct lenders payday loans best payday loan online payday loan instant approval online payday loan instant approval pay day loans loans online instant approval direct lender payday loans payday loan direct lender online payday loan lender small online payday loans
Commento inserito : Thu 01-02-18
Speedy Cash online loans bad credit instant approval micro lending loans instant approval best place to get a loan
Commento inserito : Wed 31-01-18
JamesPlurn essay writing buy essays online australia algebra homework help online assignments help write my paper buy assignment online write a paper i need to do homework webcam dildo webcam sluts webcam masturbation webcam sluts quick loans 100 approval quick loans 100 approval fast payday loan quick loans 100 approval installment loan payday loans direct lender payday loans online direct lender direct lender payday loans easy payday loans online easy online payday loans easy payday loans online easy payday loans online government homework help need help on homework research papers research paper introduction
Commento inserito : Tue 30-01-18
autoinsurance best auto insurance rates temporary car insurance quote best car insurance texas auto insurance
Commento inserito : Mon 29-01-18
School Assignments essay writing help college essay writing essay writing essay writing
Commento inserito : Mon 29-01-18
JamesPlurn speedy cash payday loans online best payday loan online best payday loan best payday loan same day payday loans online online payday loans direct lenders same day payday loans online faxless payday loan same day adult webcams webcam pussy webcam amateur webcam pussy instant online loans instant online loans instant online loans instant online loans college essay prompts college algebra homework help spss assignment help microeconomics homework help best payday loan best payday loan online best payday loan online best payday loan online
Commento inserito : Sun 28-01-18
Paydayloan payday loans online no credit check no verification payday loans direct lenders for bad credit instant personal loans
Commento inserito : Sat 27-01-18
JamesPlurn loans quick loan easy cash payday loan direct lenders payday loans payday loan companies best payday loans online easy payday loans online cash advance no credit check online loan loan money loan cash til payday loan college paper best dissertation service la homework help college paper guaranteed payday loans easy payday loans payday loans guaranteed payday loans payday advance loans best payday loans advance payday loans payday loans online direct lenders webcam sluts webcam sluts webcam dildo mature cams quick cash loans instant online payday loan instant online payday loan get a loan college essays college essays college essays buy essays
Commento inserito : Fri 26-01-18
JanePlurn personal loans online best debt consolidation companies quick loan for bad credit personal loans online
Commento inserito : Fri 26-01-18
Ace Homework college admissions essays writing essay for scholarship essay writing essay writing
Commento inserito : Thu 25-01-18
My Thesis essay writing essay writing university level writing an argumentative essay https://essaywriting.us.com - essay writing
Commento inserito : Thu 25-01-18
Quick Loans cash advance usa advance loan cash advance loan cash advance loans
Commento inserito : Wed 24-01-18
Payday Loan Online loans for christmas debt relief loan site monthly loan
Commento inserito : Wed 24-01-18
Loans Online personal loans online personal loans online same day payday personal loans unsecured
Commento inserito : Tue 23-01-18
Homework Help Online help with writing essays argument essay an argumentative essay argumentative essays
Commento inserito : Tue 23-01-18
Instant Online Loans loans no credit check loans no credit check loans in san antonio best short term loans
Commento inserito : Tue 23-01-18
Payday Loans Online payday calendar loan application pay day lenders payday loans in charlotte nc
Commento inserito : Sat 20-01-18
Loans payday loans online payday loans no credit check payday loans online online payday loans no credit check
Commento inserito : Fri 19-01-18
Fastest Payday Loan bad credit loans with monthly payments loan services personal loans personal loans no credit
Commento inserito : Fri 19-01-18
Cash Loan payday loans online payday loans no credit check same day money fast payday loans online
Commento inserito : Fri 19-01-18
Assignments Help buy research papers buy research papers research paper write my research paper
Commento inserito : Thu 18-01-18
Homework Now.Com technical writer write my paper write conclusion write my paper for me
Commento inserito : Thu 18-01-18
Quick Loan cash loans online cash loans online cash advance loan utah payday loans
Commento inserito : Thu 18-01-18
Pay Day Loan payday loans online online registration loans instant approval where to get a personal loan online payday loans no credit check
Commento inserito : Thu 18-01-18
Define Assignations write me a essay essay essays essays write essays
Commento inserito : Thu 18-01-18
Bad Credit payday loan payday loan hassle free payday loans no faxing payday loan
Commento inserito : Wed 17-01-18
Direct Lender Loans compare loan cash advance loans cash advance loan online payday advance
Commento inserito : Wed 17-01-18
JanePlurn argumentative essay argumentative essay argument essay best research paper writing service
Commento inserito : Wed 17-01-18
Homework Assignments argumentative essay paper writing argumentative essay https://argumentativeessay.us.com - essay writing
Commento inserito : Wed 17-01-18
Online Payday Loan personal loans online loans online online personal loans
Commento inserito : Wed 17-01-18
Essay Help essay writing argumentative essays argument essays website writes essays for you
Commento inserito : Wed 17-01-18
JanePlurn installment loans for bad credit loans no credit check instant approval commercial loan rates installment loans
Commento inserito : Wed 17-01-18
A Payday Loan no credit loans guaranteed approval get a loan paydayloans same day loans
Commento inserito : Sat 13-01-18
Pay Day Loans loans online cash loans loan loans online
Commento inserito : Sat 13-01-18
College Paper Writer buy college essays contrast essay college essays online college essay prompts
Commento inserito : Sat 13-01-18
Loans For Bad Credit payday loan online advance cash payday loan cash loans payday loans for bad credit
Commento inserito : Sat 13-01-18
Cash Advance payday pay day loan payday direct lenders immediate payment loans
Commento inserito : Sat 13-01-18
Dissertation Online writing a literature review for a research paper essay writing essay writing service essay writing service
Commento inserito : Sat 13-01-18
Fastest Payday Loan cash advance cash advance lenders advance cash payday loan cash advance
Commento inserito : Fri 12-01-18
JanePlurn buy an essay paper buy an essay for college buy essay buy essay
Commento inserito : Fri 12-01-18
Direct Lenders payday direct lender payday loans payday cash loan payday
Commento inserito : Fri 12-01-18
Loans a payday loan payday payday payday loans online
Commento inserito : Fri 12-01-18
PamPlurn pay day lenders online loans direct lenders online payday loan lender online payday loan lenders cash advance loan payday loans cash advance loan cash advance loan payday loan easy payday loan a payday loan best payday loan best payday loans easy payday loan fast payday loan payday loans online direct lender loans online no credit check online payday loan application direct lenders immediate payment loans online payday loan application
Commento inserito : Fri 12-01-18
Is Homework Helpful argumentative essay buy a custom research paper paper writing argumentative essay
Commento inserito : Thu 11-01-18
Write Essay Online research report college assignment help research essay https://researchpaper.us.com - research paper
Commento inserito : Tue 09-01-18
Paper Writer research paper college assignment help dissertation writer who to write a research paper
Commento inserito : Mon 08-01-18
rental car insurance compare car insurance compare car insurance list of car insurance companies compare car insurance
Commento inserito : Mon 01-01-18
How To Writing Essay essay writer essay essay do my homework
Commento inserito : Mon 01-01-18
auto club insurance car insurance car insurance compare auto insurance acceptance auto insurance
Commento inserito : Mon 01-01-18
Essay Help writing my essay essay writing service dissertation assistance https://essaywritingservice.us.org - writing my essay for me
Commento inserito : Fri 29-12-17
Loan loan cash pay day loans cash advance cash advance
Commento inserito : Thu 28-12-17
Web Assign Utah writing a synopsis for a research paper writing a paper writing a paper research essay
Commento inserito : Tue 26-12-17
Assignment Helps writing my essay research paper on abortion essay writing writing my essay for me
Commento inserito : Mon 25-12-17
Personal Loans cash loan cash loans loan payday loans
Commento inserito : Thu 21-12-17
PamPlurn the best online payday loans advance payday loans online direct payday lenders online the best online payday loans online payday loans direct lenders cash til payday loan direct lenders online loans payday loans direct lenders only fast online payday loans easy fast payday loans fast online payday loans easy fast payday loans online payday loans direct lenders fast online payday loans easy online payday loans fast online payday loans hot webcam girls girl webcam cam chat hot webcam girls payday loan online payday loan online a payday loan fastest payday loan show girls fuck show cfnm show cfnm show
Commento inserito : Sun 17-12-17
Online Payday Loans loan loans spotloan payday loan near me
Commento inserito : Fri 15-12-17
Write Essays For Me college essays buy essays college essays college essay prompts
Commento inserito : Fri 15-12-17
JamesPlurn payday loans direct lenders quick loan installment loan payday loans for bad credit payday loans lenders easy payday loans guaranteed payday loans guaranteed payday loans essays website online essay writing a research paper conclusion solve my math problem help with homework online chat research paper college paper college paper direct lender easy online payday loans easy online payday loans loan best homework help essay help writing your college essay do my math problem geology homework help write my paper for me write my research paper term paper best essay writing service best essay writing service paper writing service best essay writing service
Commento inserito : Fri 15-12-17
Loans For Bad Credit payday loan online payday payday express a payday loan
Commento inserito : Fri 15-12-17
Payday Loan no credit loans guaranteed approval loan easy cash payday loan faxless payday loan same day
Commento inserito : Fri 15-12-17
Fastest Payday Loan cash loans loan loans online instant approval quick loan
Commento inserito : Fri 15-12-17
Migucect
Commento inserito : Sat 09-12-17
Assignment Helps research papers research papers research report buy a essay
Commento inserito : Thu 07-12-17
JamesPlurn bad credit payday loans payday loans for bad credit Check Out Your URL https://loansforbadcredit.us.com/ - payday loans for bad credit
Commento inserito : Tue 05-12-17
Quick Loan get a loan loan loan no credit check emergency loans
Commento inserito : Mon 04-12-17
Essay Writing Online college essay helper college essays online college essays buy essays for college
Commento inserito : Sun 26-11-17
Paydayloan bad credit personal loans payday loans for bad credit guaranteed personal loan payday loans for bad credit in texas
Commento inserito : Sat 25-11-17
Essays Writing buy essays buy essays website that writes essay for you order essay online
Commento inserito : Sat 25-11-17
Payday Express online fast cash loans quick loans quick payday loans fast loans lenders
Commento inserito : Sat 25-11-17
Pay Day Loan best personal loans for bad credit quick cash loans for bad credit bad credit loans in pa personal loans columbus ohio
Commento inserito : Sat 25-11-17
Bad Credit 5000 loan emergency loans short term loans quick short term loans
Commento inserito : Sat 25-11-17
PamPlurn mcgraw hill homework help buy essays buy essays buy essays fast payday loan easy payday loan payday loan online easy payday loan show girls fuck show show girls free adult sex chat research papers school papers research papers research papers online payday loan direct payday lenders bad credit direct lenders payday loans pay day lenders internet payday loans best payday loans online best payday loans online best online payday loans
Commento inserito : Tue 21-11-17
Homework Online help with college essays essay introduction help help writing essays for college help in essay writing
Commento inserito : Fri 17-11-17
Pay Day Loan quick personal loans loan fast cash best fast cash loans personal loans quicken
Commento inserito : Mon 13-11-17
JoePlurn best payday loan online explained here Get More Information loans online
Commento inserito : Sat 11-11-17
JamesPlurn fast cash loans with no credit check payday loans online direct lenders payday loans direct lender payday loans online direct lender paper writing write essays online paper writing writing a paper best homework help college essay prompts argumentative essay doing your homework payday lenders direct direct payday lenders direct payday lenders payday lenders direct write my dissertation essay writing essay writer custom essay payday loan lenders loans with no credit check direct payday loan lenders payday loan lenders free porn cams porn webcam nude show free porn cams
Commento inserito : Fri 10-11-17
Migucect Medsforless Biz cialis price Comprar Cialis Envio 24 H
Commento inserito : Thu 09-11-17
Homework Center help writing a essay buy essays online buy an essay buy essay online
Commento inserito : Thu 09-11-17
Direct Lenders quick loans online quick loans quick personal loans quick loans calgary
Commento inserito : Mon 06-11-17
Fake Essay Writer college essay review services buy essay without getting caught history essay help order essay online cheap quick
Commento inserito : Mon 06-11-17
Easy Payday Loan need a fast loan loans quicken quick cash loans in tennessee payday loans quick cash
Commento inserito : Mon 06-11-17
JamesPlurn payday loans online no credit check payday loans online no credit check payday loans https://paydayloans.us.org/ - payday loans
Commento inserito : Sun 05-11-17
Money Loan quicken loans rates easy payday loans online no faxing quick money loan quick cash loans reviews
Commento inserito : Sat 04-11-17
Money Loan loan online short term loans short term loans canada short term loans no credit check
Commento inserito : Thu 26-10-17
Online Homework Help buy college essays website for essays buy essay online essay buy
Commento inserito : Thu 26-10-17
Best Online Loans quick payday loans bad credit quick loans quick loans in ga quick personal loans
Commento inserito : Thu 26-10-17
JohnItago as an example
Commento inserito : Wed 06-09-17
AaronFer wh0cd2729467 buy avana propecia
Commento inserito : Wed 06-09-17
KennethLax buy cialis online
Commento inserito : Sat 02-09-17
CharlesBus buy cialis
Commento inserito : Sat 02-09-17
Bennyced buy cialis
Commento inserito : Fri 01-09-17
CharlesBus cialis 5mg
Commento inserito : Fri 01-09-17
Bennyced wh0cd699626 recommended site
Commento inserito : Wed 23-08-17
JaonBer kbk00wh71kkh48wg1o

baidu

580ctxfr5xzzjr2lkw
Commento inserito : Mon 07-08-17
EugeneDrype wh0cd64028 buy antabuse where can i buy elimite
Commento inserito : Sun 06-08-17
CharlesBus wh0cd826506 diflucan online purchase bentyl
Commento inserito : Sun 06-08-17
Bennyced wh0cd589853 zovirax buy diarex risperdal coreg
Commento inserito : Fri 04-08-17
Jasonamole g3k9sioqjltopeplvj

baidu

2z398o979gwf9mh5lj
Commento inserito : Wed 02-08-17
lgcfive6 The risk or severity of adverse effects can be increased when Bucillamine is combined with Prednisone. buy prednisone online, prednisone veterinary dosage
Commento inserito : Mon 31-07-17
gj8c6spr The serum concentration of Prednisone can be increased when it is combined with Quinine. cheap prednisone, high dose prednisone side effects dogs
Commento inserito : Sun 30-07-17
AlfredPutle wh0cd643274 tamoxifen where can i buy viagra over the counter eurax cialis online canada vpxl
Commento inserito : Sun 30-07-17
Maauplib h0ovqqyyncts3dac43

baidu

baidu

ly8y9lb5smh0xqqusd
Commento inserito : Wed 26-07-17
Mkaauplib 1e2k58quqj99eun8ob

google

google

fb8qdb3i4u1vvpsvlt
Commento inserito : Mon 24-07-17
ellogkny llng47dntwck0b9vqy

buy baclofen online

generic baclofen

bc69lrb55rp23rrei1
Commento inserito : Sun 23-07-17
pvtfjydi cusfmw2l3cp573kuci

baclofen online

buy baclofen online

1b80xqrpmwp6tk2yy1
Commento inserito : Sat 22-07-17
vtjywkdl pxoe7wq6kko98az611

order baclofen

generic baclofen online

fatjyqx0de1j9z3vli
Commento inserito : Sat 22-07-17
qwwnbdbx 2codow7scjxgd9xzvd

cheap baclofen

cheap baclofen

7561lo2qufmlog8hlw
Commento inserito : Fri 21-07-17
johhnyPem emiz80bf96eadixbyr

google

google

3j7a46it6vizynuztk
Commento inserito : Wed 12-07-17
johhnyPem h7mfkjrxl5e0qy9pf0

google

google

hni0jzdwxmlxkzm6yy
Commento inserito : Wed 12-07-17
KennethLax wh0cd133667 anafranil 25mg cafergot crestor levaquin buy bentyl diflucan
Commento inserito : Tue 11-07-17
KennethLax wh0cd15341 cheap nexium online
Commento inserito : Mon 10-07-17
ErickLoalk wh0cd370411 methotrexate 2.5mg tablets motilium over the counter found here tretinoin citalopram citalopram online
Commento inserito : Mon 03-07-17
Jerrygut 9wm7phgrfyfu7wv5cl

google

google

tycok6771zq82creoq
Commento inserito : Sun 02-07-17
ErickLoalk wh0cd725896 tadalafil cymbalta generic strattera wellbutrin buy tadalis extra resources ventolin provera
Commento inserito : Fri 30-06-17
ErickLoalk wh0cd617696 medrol zovirax buy
Commento inserito : Fri 30-06-17
ErickLoalk wh0cd2078342 buy viagra online
Commento inserito : Mon 08-05-17
ErickLoalk wh0cd2078342 Viagra Sale
Commento inserito : Mon 24-04-17
CaseyStife wh0cd107449 SILDENAFIL ONLINE
Commento inserito : Sun 23-04-17


Commenta questo film Commenta questo film
Autore Commento

BBCode è Attivo .

Inserire il codice* Codice

Recensioni

Rubriche

 

cineforum

 

 

Non cinema

 

 

Non cinema

 

TRADUTTORE

 

 

 

PARTNER

 

 

 

 

 

 

CI TROVI ANCHE SU

 

 


 

Cinema Bizzarro

Ultimi commenti

DB function failed with error number 144
Table './bizzarrocinema/jos_easycomments' is marked as crashed and last (automatic?) repair failed SQL=SELECT eco.`id`, eco.`contentid`, eco.`comment`, ct.`title` as ct_title FROM `jos_easycomments`as eco INNER JOIN `jos_content` AS ct ON ct.`id` = eco.`contentid` WHERE eco.`published` = '1' ORDER BY eco.`date` DESC LIMIT 6