SELECT opere.*, opere_dettagli.*, opere.id FROM opere
LEFT JOIN opere_dettagli ON opere.id=opere_dettagli.id_art
LEFT JOIN correlati ON opere.id=correlati.id_art
LEFT JOIN autori ON autori.id=correlati.id_tabella AND correlati.tabella='autori'
LEFT JOIN tag_correlati ON opere.id=tag_correlati.id_art AND tag_correlati.tabella='opere'
LEFT JOIN tag ON tag.id=tag_correlati.id_tag
WHERE opere.id!=''
AND opere.collection = '1' AND (correlati.id_tabella='79' AND correlati.tabella='autori' OR correlati.id_tabella='79' AND correlati.tabella='altri_autori')
GROUP BY opere.id
ORDER BY opere.ordine DESC, opere.titolo
Collection of Collections - Vladimir Kozhukhar
This site uses cookies. By continuing to browse the site you agree to our use of cookies. DetailsX
