Specializirana trgovina za opremo vašega doma | info@vsezavasdom.com

SELECT MAX(val) val FROM (SELECT MAX(LEAST(a.cena_ddv, a.cena_ddv_pop)) val FROM artikli a WHERE a.aktivnost='Y' AND a.kat_id IN (SELECT kat_id FROM kategorije WHERE permalink='kreme-in-olja') UNION SELECT MAX(LEAST(ap.cena, ap.cena_akcija)) val FROM artikli_podrobnosti ap, artikli a WHERE ap.aktivnost='YES' AND a.art_id = ap.artikel_id AND a.kat_id IN (SELECT kat_id FROM kategorije WHERE permalink='kreme-in-olja')) a

Kreme in olja

    SELECT SQL_CALC_FOUND_ROWS at.art_id, at.sifra, at.nazivk, at.nazivd, at.cena, at.cena_pop, at.aktivnost, at.opisk, at.brand_id, at.znacka, k.naziv, at.kat_id, at.date_added AS datum, at.artPermalink, at.katPermalink, at.p_outlet, at.podrobnosti_id, at.vec_moznosti, at.ddv FROM (SELECT a.art_id, a.sifra, COALESCE(td_k.text, a.nazivk) AS nazivk, COALESCE(td_d.text, a.nazivd) AS nazivd, IF(a.vec_moznosti = 'Y', ap.cena, a.cena) AS cena, IF(a.vec_moznosti = 'Y', ap.cena_akcija, a.cena_pop) AS cena_pop, a.kat_id, a.aktivnost, a.opisk, a.brand_id, COALESCE(td_z.text, a.znacka) AS znacka, a.zaloga, a.date_added, a.permalink AS artPermalink, k_pool.katPermalink, a.p_outlet, ap.id AS podrobnosti_id, a.vec_moznosti, a.ddv FROM artikli a LEFT JOIN artikli_podrobnosti ap ON ap.id = (SELECT ap1.id FROM artikli_podrobnosti ap1 JOIN artikli_podatki ad ON ap1.barva_id = ad.id WHERE ap1.artikel_id = a.art_id AND ap1.aktivnost = 'YES' AND ap1.cena > 0 ORDER BY ap1.cena ASC, ap1.id ASC LIMIT 1) LEFT JOIN translations_data td_k ON td_k.group_name = 'artikli' AND td_k.field = 'nazivk' AND td_k.doc_id = a.art_id AND td_k.language_id = 593 LEFT JOIN translations_data td_d ON td_d.group_name = 'artikli' AND td_d.field = 'nazivd' AND td_d.doc_id = a.art_id AND td_d.language_id = 593 LEFT JOIN translations_data td_z ON td_z.group_name = 'artikli' AND td_z.field = 'znacka' AND td_z.doc_id = a.art_id AND td_z.language_id = 593 INNER JOIN (SELECT 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 root LEFT JOIN kategorije parent1 ON root.kat_id = parent1.kat_id_nadr AND parent1.aktivnost = 'Y' LEFT JOIN kategorije parent2 ON parent1.kat_id = parent2.kat_id_nadr AND parent2.aktivnost = 'Y' LEFT JOIN kategorije parent3 ON parent2.kat_id = parent3.kat_id_nadr AND parent3.aktivnost = 'Y' WHERE root.aktivnost = 'Y' AND root.permalink = 'kreme-in-olja' ) k_pool ON a.art_id IN (SELECT pc0.prd_id FROM products_categories pc0 WHERE pc0.cat_id IN (k_pool.root_id, k_pool.parent1_id, k_pool.parent2_id, k_pool.parent3_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.sifra <> '-1' ORDER BY at.nazivk ASC, at.nazivd ASC LIMIT 0, 30;
  • Ni artiklov.
NALOŽI VEČ