[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(138,1457,1468,1470,1474,1476,139,1078,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,755,1064,631,789,791,1062,635,782,633,783,784,785,786,787,788,790,632,634,636,146,768,873,767,149,150,756,1054,881,757,141,758,760,762,764,766,872,547,554,555,556,140,142,143,41,144,184,201,202,203,880,747,174,1025,1331,1332,593,1028,594,595,640,598,616,617,884,175,178,1071,1072,1073,837,838,839,840,841,842,843,844,845,846,223,224,225,226,227,228,229,230,180,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,217,218,1017,181,917,214,215,183,877,878,205,206,207,209,210,211,212,185,192,193,194,195,196,197,199,1020,200,1042,1043,792,793,795,796,797,204,213,1238,216,748,779,780,781,749,776,777,778,750,751,769,770,771,772,773,774,775,148,1019,752,889,891,892,895,897,899,186,798,799,800,801,802,803,804,805,806,187,189,190,191,231,232,233,234,235,1016,179,829,830,831,832,833,834,835,836,885,886,220,1069,828,219,221,1021,162,1039,883,165,171,173,1074,1075,163,164,857,169,172,167,168,858,859,860,208,753,852,853,854,855,856,754,847,848,849,850,861,1022,145,1024,596,630,642,147,151,152,153,1246,741,742,743,744,1023,284,1065,1068,400,401,1236,1243,154,879,155,156,158,159,160,161,1362,1363,1364,1365,1366,1373,1374,1367,1368,1369,1371,1372,759,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1406,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1375,1376,1377,1378,1379,1380,1381,1382)
group by p.id
having final_cena > 0
order by p.vaha_poradia_cz asc
limit 0, 32
Error writing file '/tmp/MYasrpnw' (Errcode: 28 - No space left on device)
]]>
Dílna | 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
Dílna
Železářství Železářství
Číst více
Nebyli nalezeny žádné produkty
