SELECT d_dilo.id_dilo,
d_dilo.id_author,
d_dilo.url,
d_dilo.nazevdila as nazevdila,
d_dilo.imgbase as imagebase,
d_dilo.technika as technika,
d_dilo.rok as rok,
d_hnuti.nazev_cz as hnuti,
d_dilo.hnuti as idhnuti,
d_dilo.category,
d_dilo.category2,
d_dilo.dostupnost,
d_dilo.doporucujeme,
d_author.foldername as foldername,
d_dilo.vlozeno as vlozeno,
d_dilo.visits as visits,
d_dilo.adjustace,
(d_dilo.cena * 1/1) as cena,
(d_dilo.cena *(100-d_dilo.sleva)/100 * 1/1) as uprav_cena,
d_dilo.sleva,
d_dilo_detail.format_plocha as format_tiskove_plochy,
d_dilo_detail.format_papir as format_papiru,
d_dilo_detail.format_adjustace as format_po_adjustaci,
d_dilo_detail.signatura_tuska as signatura_tuska,
d_dilo_detail.signatura_plocha as signatura_plocha,
d_dilo_detail.signatura_tuspero as signatura_tuspero,
d_dilo_detail.signatura_tuska_note as signatura_tuska_note,
d_dilo_detail.signatura_plocha_note as signatura_plocha_note,
d_dilo_detail.signatura_tuspero_note as signatura_tuspero_note,
d_dilo_detail.cislovano as cislovano,
d_dilo_detail.datovano as datovano,
d_dilo_detail.cislovano_note as cislovano_note,
d_dilo_detail.datovano_note as datovano_note,
d_dilo_detail.stav as stav,
d_dilo_detail.stav_note as stav_note,
d_dilo_detail.certifikate as certifikate,
d_dilo_detail.certifikate_file as certifikate_file,
d_dilo_detail.certifikate_file2 as certifikate_file2,
d_dilo_detail.certifikate_galerie as certifikate_galerie,
d_dilo_detail.dokumentace as dokumentace,
d_dilo_detail.dokumentace_file1 as dokumentace_file1,
d_dilo_detail.dokumentace_file2 as dokumentace_file2,
TO_DAYS( CURDATE( ) ) - TO_DAYS( datum ) as stari,
concat(d_author.firstname, ' ', d_author.secondname) as author,
d_author.firstname as firstname,
d_author. secondname as secondname
FROM d_dilo
LEFT JOIN d_author ON d_dilo.id_author=d_author.id_author
LEFT JOIN d_hnuti ON d_dilo.hnuti=d_hnuti.id_hnuti
LEFT JOIN d_dilo_detail ON d_dilo.id_dilo=d_dilo_detail.id_dilo
WHERE d_dilo.id_dilo="217"