Smarty

[efab]

Hey there,

We're using JTL and its default export functionality for data feeds.
For our google shopping campaigns, we would like to adjust our default title.
We already created a custom field and I already caught the fields in our database, this is the SQL query:

select a.cArtNr as SKU, b.cName as Title_Default, f.cWertVarchar as Title_Google_Shopping
from tArtikel a
left join tArtikelBeschreibung b on a.kArtikel = b.kArtikel
left join tArtikelAttribut c on a.kArtikel = c.kArtikel
left join tAttribut d on c.kAttribut = d.kAttribut
left join tAttributSprache e on d.kAttribut = e.kAttribut
left join tArtikelAttributSprache f on c.kArtikelAttribut = f.kArtikelAttribut

/*google shopping title*/
where e.kAttribut = 1182 and f.cWertVarchar != '' and f.cWertVarchar is not null

NOW, how to translate this query into smarty?
Never worked before with smarty.

I hope you can help me.

Cheers

Christoph

[AnrDaemon]

You don't "translate SQL to Smarty".
You prepare data in your PHP code, as you need them, and THEN pass them to Smarty.