Akcija

SELECT SQL_CALC_FOUND_ROWS at.art_id, at.sifra, at.nazivk, at.nazivd, at.cena, at.cena_pop, at.aktivnost, at.opisk, at.znacka, at.ime_dat, at.alt, k.naziv, at.kat_id, at.date_added datum, at.artPermalink, at.katPermalink, at.p_outlet FROM ( SELECT sart.art_id, sart.sifra, sart.nazivk, sart.nazivd, sart.cena, sart.cena_pop, sart.kat_id, sart.aktivnost, sart.opisk, sart.znacka, sart.ime_dat, sart.alt, sart.trgovina, sart.zaloga, sart.date_added, sart.artPermalink, sart.katPermalink, sart.p_outlet FROM ( SELECT DISTINCT a.art_id, a.sifra, a.nazivk, a.nazivd, a.cena, a.cena_pop, a.kat_id, a.aktivnost, a.opisk, a.trgovina, a.znacka, s.ime_dat, s.alt, a.zaloga, a.date_added, a.artPermalink, a.katPermalink, a.p_outlet FROM (SELECT DISTINCT artikli.art_id, artikli.sifra, IFNULL((SELECT text FROM translations_data td WHERE td.group_name = 'artikli' AND td.field='nazivk' AND td.doc_id = artikli.art_id AND td.language_id = 593), artikli.nazivk) nazivk, IFNULL((SELECT text FROM translations_data td WHERE td.group_name = 'artikli' AND td.field='nazivd' AND td.doc_id = artikli.art_id AND td.language_id = 593), artikli.nazivd) nazivd, IF (vec_cen='Y', pp.price_tax, artikli.cena_ddv) cena, IF (vec_cen='Y', pp.special_price_tax, artikli.cena_ddv_pop) cena_pop, artikli.kat_id, artikli.aktivnost, artikli.opisk, artikli.trgovina, IFNULL((SELECT text FROM translations_data td WHERE td.group_name = 'artikli' AND td.field='znacka' AND td.doc_id = artikli.art_id AND td.language_id = 593), artikli.znacka) znacka, artikli.zaloga, artikli.date_added, artikli.permalink artPermalink, k_pool.katPermalink, artikli.p_outlet FROM artikli LEFT JOIN products_prices pp ON pp.id = (SELECT id FROM products_prices pp1 WHERE pp1.product_id = artikli.art_id ORDER BY price_tax ASC LIMIT 1) INNER JOIN (SELECT root.naziv as root_naziv, root.kat_id as root_id, root.permalink as katPermalink, parent1.kat_id as parent1_id, parent2.kat_id as parent2_id, parent3.kat_id as parent3_id FROM kategorije as root LEFT OUTER JOIN kategorije as parent1 ON (root.kat_id = parent1.kat_id_nadr AND parent1.aktivnost='Y') LEFT OUTER JOIN kategorije as parent2 ON (parent1.kat_id = parent2.kat_id_nadr AND parent1.aktivnost='Y') LEFT OUTER JOIN kategorije as parent3 ON (parent2.kat_id = parent3.kat_id_nadr AND parent1.aktivnost='Y') WHERE root.aktivnost='Y') k_pool on (artikli.art_id IN (SELECT prd_id FROM products_categories pc0 WHERE cat_id = k_pool.root_id) OR artikli.art_id IN (SELECT prd_id FROM products_categories pc0 WHERE cat_id = k_pool.parent1_id) OR artikli.kat_id IN (SELECT prd_id FROM products_categories pc0 WHERE cat_id = k_pool.parent2_id) OR artikli.kat_id IN (SELECT prd_id FROM products_categories pc0 WHERE cat_id = k_pool.parent3_id)) ) a LEFT JOIN ( SELECT DISTINCT ime_dat, alt, artikel FROM slike WHERE sort > 0 ORDER BY sort ASC ) s ON (a.art_id = s.artikel) GROUP BY a.art_id ) sart INNER JOIN trgovine t ON (sart.trgovina = t.trgovina_id) ) at LEFT JOIN kategorije k ON (at.kat_id = k.kat_id AND k.aktivnost='Y') WHERE at.aktivnost = 'Y' AND at.p_outlet='N' AND at.trgovina = '1' AND at.sifra <> '-1' AND at.cena_pop>0 ORDER BY at.nazivk ASC, at.nazivd ASC LIMIT 36, 12;
• 
  Aloe vera sok
  3,90 EUR 4,90 EUR
• 
  Aluminijasta steklenica z različnimi zapirali - 100 ml
  1,99 EUR 2,10 EUR
• 
  Amphotensid GB 2009 conc (tenzid, surfaktant)
  1,90 EUR 3,90 EUR
• 
  Anato barvilo (iz semen drevesa Bixa orellana)
  3,90 EUR 4,90 EUR
• 
  Antique Ivory - barva za sveče
  1,59 EUR 2,50 EUR
• 
  Antistresnik - mešanica eteričnih olj
  2,90 EUR 3,90 EUR
• 
  Arctic White Mica
  3,50 EUR 3,90 EUR
• 
  Augeo - osnova (tekočina) za aroma difuzorje s paličicami
  2,50 EUR 2,90 EUR
• 
  Avokadovo maslo (mešanica)
  4,10 EUR 4,90 EUR
• 
  BIO!
  Avokadovo olje - BIO, hladno stiskano
  3,30 EUR 3,80 EUR
• 
  Babassu olje/maslo - rafinirano
  4,60 EUR 4,90 EUR
• 
  Bambus v prahu (fini)
  7,00 EUR 7,50 EUR