[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(8,9,695,17,591,662,590,589,20,53,673,54,675,676,18,1282,1283,1284,1103,1104,21,1281,56,58,59,47,50,48,664,57,49,863,51,575,52,663,106,1027,579,1429,1430,1431,571,1428,22,25,672,14,10,557,560,561,562,563,564,565,136,13,24,61,62,63,64,65,687,688,689,690,26,67,1438,1437,1439,28,66,27,29,30,558,566,567,568,862,864,582,583,584,585,586,587,588,646,684,685,730,1150,1151,1152,1153,1154,1186,1193,1194,650,32,33,34,35,36,37,674,651,569,578,691,692,652,1425,577,581,671,1196,1197,1198,1199,1200,1423,1107,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1185,1187,1189,1191,1192,1467,1029,1030,1287,1040,1303,1408,1411,1412,1415,1416,1414,1417,1413,544,545,552,553,686,1245,1419,1420,1421,1418,1422,15,38,68,69,71,73,74,609,610,611,714,1076,649,694,176,84,706,708,707,628,659,45,612,613,614,615,78,721,722,723,724,80,107,716,717,647,876,117,124,126,127,129,130,131,134,135,648,725,660,661,1471,76,88,718,719,720,624,697,698,699,871,82,701,700,702,703,81,704,705,79,918,86,83,87,709,710,711,42,104,696,39,1334,75,712,713,478,85,89,868,882,912,658,177,956,1469,729,541,644,733,734,250,40,77,625,626,627,91,90,92,656,657,653,93,94,95,96,97,98,99,100,101,102,654,655,1424,46,108,109,110,111,112,113,715,476,580,1441,55,44,114,115,116,118,119,121,122,123,125,128,132,133,677,1426,19,103,665,592,548,667,668,669,670,869)
group by p.id
having final_cena > 0
order by p.vaha_poradia_cz asc
limit 0, 32
Error writing file '/tmp/MYFJ7lbp' (Errcode: 28 - No space left on device)
]]>
Stavebniny | 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
Stavebniny
Hrubá stavba
Hrubá stavba
Dalším prvkem, který patří do základní desky, je izolace vodorovných a svislých konstrukcí domu, která pomáhá výrazně redukovat náklady na energie, což je z dlouhodobého hlediska významné.
Číst více
Nebyli nalezeny žádné produkty
