[18] main_db(m_db):
<![CDATA[query with error: SELECT
SQL_CALC_FOUND_ROWS
p.id,
p.id_vyrobca,
p.nazov_cz AS nazov,
p.kod_cz AS kod,
p.kod_vyrobca_cz AS kod_vyrobca,
p.ean,
p.zobrazit_vyrobcu_v_nazve,
p.zobrazit_kod_v_nazve,
p.dostupnost_cz AS dostupnost,
p.nasobky,
p.min_odber,
p.min_cena,
p.min_cena * (1 + IFNULL(p.dph_cz, 21) / 100) * (1 + IFNULL(p.rabat_cz, 21) / 100) AS min_cena_s_dph,
p.zlava_cz AS zlava,
p.rabat_cz AS rabat,
p.novinka_cz AS novinka,
p.dph_cz AS dph,
p.obrazok,
p.obrazok_feed,
p.upozornenie_cz AS upozornenie,
p.hmotnost,
p.variacia_cz AS variacia,
p.strana_katalog_cz AS strana_katalog,
p.pocet_skladom_cz AS pocet_skladom,
p.cena_dopravy_cz AS cena_dopravy,
p.nasobit_cenu_dopravy_cz AS nasobit_cenu_dopravy,
p.vydajne_miesto_cz,
p.text_dopravy,
IFNULL(pj.nazov_cz, 'ks') AS jednotka,
max(pc.cena) AS cena,
v.nazov_cz AS vyrobca_nazov,
max(k.zlava_cz) AS zlava_kategoria,
ic.zlava AS individualna_zlava,
ic.cena AS individualna_cena,
count(pc.id) AS pocet_cien,
GREATEST(IFNULL(max(k.zlava_cz), 0), IFNULL(p.zlava_cz, 0), IFNULL(ic.zlava, 0)) AS zlava_final,
ifnull(
(
ic.cena - (
ic.cena / 100 * (ifnull(ic.zlava, 0))
)
),
(
pc.cena+(
pc.cena*ifnull(p.rabat_cz, 0)/100
) - (
(pc.cena + (pc.cena*ifnull(p.rabat_cz, 0)/100)) * (
if(
ifnull(p.zlava_cz, 0) > ifnull(max(k.zlava_cz), 0),
if(
ifnull(p.zlava_cz, 0) > ifnull(ic.zlava, 0),
ifnull(p.zlava_cz, 0),
ifnull(ic.zlava, 0)
),
if(
ifnull(max(k.zlava_cz), 0) > ifnull(ic.zlava, 0),
ifnull(max(k.zlava_cz), 0),
ifnull(ic.zlava, 0)
)
) /100
)
)
)
) * (1 + (ifnull(p.dph_cz, 21)/100)) AS final_cena,
ifnull(
(
ic.cena - (
ic.cena / 100 * (ifnull(ic.zlava, 0))
)
),
(
pc.cena+(
pc.cena*ifnull(p.rabat_cz, 0)/100
) - (
(pc.cena + (pc.cena*ifnull(p.rabat_cz, 0)/100)) * (
if(
ifnull(p.zlava_cz, 0) > ifnull(max(k.zlava_cz), 0),
if(
ifnull(p.zlava_cz, 0) > ifnull(ic.zlava, 0),
ifnull(p.zlava_cz, 0),
ifnull(ic.zlava, 0)
),
if(
ifnull(max(k.zlava_cz), 0) > ifnull(ic.zlava, 0),
ifnull(max(k.zlava_cz), 0),
ifnull(ic.zlava, 0)
)
) /100
)
)
)
) AS final_cena_bez_dph
from praktis_produkty p
left join praktis_produkty_kategorie pk on pk.id_produkt = p.id
left join praktis_jednotky pj ON pj.id = p.id_jednotka
left join praktis_produkty_ceny pc on pc.id_produkt = p.id and pc.mutacia = 2
left join praktis_vyrobcovia v on v.id = p.id_vyrobca
left join praktis_kategorie k on k.id = pk.id_kategoria
left join praktis_odberatelia_ceny ic on ic.id_produkt = p.id and ic.id_odberatel = -1
where p.aktivny_cz = 1 and (p.vyradeny_cz = 0 or p.vyradeny_cz is null) and pocet_skladom_cz > 0 AND pk.id_kategoria IN(278,1432,279,1031,549,550,1045,287,290,291,292,288,293,294,295,296,297,298,1333,317,328,329,330,331,929,1229,865,866,867,1190,980,981,982,988,997,1001,280,258,300,301,310,311,312,302,303,304,305,306,313,314,315,307,308,309,907,1063,498,500,1234,979,984,987,998,999,1231,1344,1345,1346,1347,1235,1479,281,316,323,324,325,326,327,973,975,976,318,332,333,334,335,336,337,338,339,968,319,341,342,343,344,345,320,346,347,348,349,350,351,352,1466,977,983,1244,321,353,354,355,356,358,360,361,362,363,364,365,366,367,970,971,368,198,972,974,322,369,370,371,372,373,374,375,376,991,992,993,994,995,996,919,357,359,985,990,920,921,922,923,924,963,1002,1003,1004,1005,1006,282,378,383,384,385,928,379,386,387,380,388,389,390,391,392,393,394,969,989,1000,283,1041,1056,641,1410,395,397,398,399,396,402,1230,978,286,1033,1057,403,404,954,551,1179,1180,1181,1182,1183,1184,1188,1335,1336,1339,1340,1342,1337,1338,1341)
group by p.id
having final_cena > 0
order by p.vaha_poradia_cz asc
limit 0, 32
Error writing file '/tmp/MYsMO0p9' (Errcode: 28 - No space left on device)
]]>
Bydlení | praktis.cz
Tato webová stránka je pouze testovací - pokud chcete vytvořit objednávku, proveďte to zde: https://www.praktis.cz/
Děkujeme.
Zavřít
Bydlení
Domácnost domácnost Domácnost domácnosti
Číst více
Nebyli nalezeny žádné produkty
