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='') 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='')) a

    SELECT SQL_CALC_FOUND_ROWS at.art_id, at.sifra, at.nazivk, at.nazivd, at.cena, at.cena_pop, at.aktivnost, at.opisk, at.opis, at.brand_id, at.znacka, at.ime_dat, at.alt, k.naziv, at.kat_id, at.date_added datum, at.artPermalink, k.permalink katPermalink, at.p_outlet, at.podrobnosti_id, at.vec_moznosti FROM ( SELECT sart.art_id, sart.sifra, sart.nazivk, sart.nazivd, sart.cena, sart.cena_pop, sart.kat_id, sart.aktivnost, sart.opisk, sart.opis, sart.znacka, sart.ime_dat, sart.alt, sart.trgovina, sart.brand_id, sart.zaloga, sart.date_added, sart.artPermalink, sart.p_outlet, sart.podrobnosti_id, sart.vec_moznosti 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.opis, a.trgovina, a.brand_id, a.znacka, s.ime_dat, s.alt, a.zaloga, a.date_added, a.artPermalink, a.p_outlet, a.podrobnosti_id, a.vec_moznosti 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_moznosti='Y', ap.cena, artikli.cena) cena, IF (vec_moznosti='Y', ap.cena_akcija, artikli.cena_pop) cena_pop, artikli.kat_id, artikli.aktivnost, artikli.opisk, artikli.opis, artikli.trgovina, artikli.brand_id, 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, artikli.p_outlet, ap.id podrobnosti_id, artikli.vec_moznosti FROM artikli LEFT JOIN artikli_podrobnosti ap ON ap.id = (SELECT id FROM artikli_podrobnosti ap1 WHERE ap1.artikel_id = artikli.art_id AND ap1.aktivnost='YES' AND ap1.cena>0 ORDER BY cena ASC LIMIT 1) ) a LEFT JOIN ( SELECT DISTINCT ime_dat, alt, artikel FROM slike WHERE sort = 1 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, kategorije k WHERE at.kat_id = k.kat_id AND k.aktivnost='Y' AND at.aktivnost = 'Y' AND at.p_outlet = 'N' AND at.sifra <> '-1' AND at.art_id IN (SELECT product_id FROM collections_products WHERE collection_id = 7) ORDER BY at.nazivk ASC, at.nazivd ASC LIMIT 0, 20;
  • Ni artiklov.