SELECT SQL_CALC_FOUND_ROWS G.id, G.nazev, G.nazev2, G.nakupnicena, G.beznacena, G.dph, G.vypocetceny, G.kategorie, G.recycle, G.recycle_category, G.custom_recycle_price, P.name AS vyrobce_nazev, G.quantity_after, G.catnum, U.url, G.set,GS.cena as SetCenaBez, (SELECT SUM(GS.cena * (100 + GS.dph) / 100) FROM good_sety GS WHERE GS.good_set = G.id GROUP BY GS.good_set) as SetCena, -- expedice E.comment AS expedice_name, -- alternativní expedice / expedice-sklad IF ( (S.quantity < 1) AND (S.onempty = 'setexped'), stE.comment, altE.comment ) AS alt_st_expedice_name, G.popis FROM goods G LEFT JOIN url U ON U.id = G.id AND U.page = 'product_detail' AND U.default = 1 LEFT JOIN modifications M ON M.modification = G.id -- výrobce LEFT JOIN producers P ON P.id = G.vyrobce -- skladové zásoby LEFT JOIN stock S ON S.good = G.id -- Akce na homepage LEFT JOIN actions A ON (A.good = G.id) AND (296 = 45) AND (A.department = 45) -- SETY LEFT JOIn good_sety GS ON G.id = GS.good_set -- 1. expedice => normální, nastavená u zboží LEFT JOIN expeditions E ON E.id = G.expedice LEFT JOIN product_category PC ON PC.product = G.id -- 2. expedice => alternativní od určitého data LEFT JOIN expeditions altE ON (altE.id = G.expedice_alt) AND (G.expedice_alt_enable = 1) AND (G.expedice_alt_date <= 1284015600) -- 3. expedice => změna při vyčerpání skladových zásob LEFT JOIN expeditions stE ON stE.id = S.exped LEFT JOIN pe_goodsprices GP ON (GP.good = G.id) AND (GP.category = '2') AND ((G.vypocetceny = 'manual' AND GP.price > 0) OR G.vypocetceny = 'auto') WHERE ((PC.category = 296) OR ((296 = 45) AND (A.good IS NOT NULL))) AND (G.vlozeni < 1284015600) AND ((G.stazeni > 1284015600) OR (G.stazeni = 0)) AND (G.`delete` != 'y') AND (G.skryte = 'n') AND (G.nakupnicena > 0) AND M.main IS NULL -- hledání -- aby se neopakovalo zboží, které je ve více odděleních GROUP BY G.id -- řazení ORDER BY G.nazev

SELECT SQL_CALC_FOUND_ROWS G.id, G.nazev, G.nazev2, G.nakupnicena, G.beznacena, G.dph, G.vypocetceny, G.kategorie, G.recycle, G.recycle_category, G.custom_recycle_price, P.name AS vyrobce_nazev, G.quantity_after, G.catnum, U.url, G.set,GS.cena as SetCenaBez, (SELECT SUM(GS.cena * (100 + GS.dph) / 100) FROM good_sety GS WHERE GS.good_set = G.id GROUP BY GS.good_set) as SetCena, -- expedice E.comment AS expedice_name, -- alternativní expedice / expedice-sklad IF ( (S.quantity < 1) AND (S.onempty = 'setexped'), stE.comment, altE.comment ) AS alt_st_expedice_name, G.popis FROM goods G LEFT JOIN url U ON U.id = G.id AND U.page = 'product_detail' AND U.default = 1 LEFT JOIN modifications M ON M.modification = G.id -- výrobce LEFT JOIN producers P ON P.id = G.vyrobce -- skladové zásoby LEFT JOIN stock S ON S.good = G.id -- Akce na homepage LEFT JOIN actions A ON (A.good = G.id) AND (296 = 45) AND (A.department = 45) -- SETY LEFT JOIn good_sety GS ON G.id = GS.good_set -- 1. expedice => normální, nastavená u zboží LEFT JOIN expeditions E ON E.id = G.expedice LEFT JOIN product_category PC ON PC.product = G.id -- 2. expedice => alternativní od určitého data LEFT JOIN expeditions altE ON (altE.id = G.expedice_alt) AND (G.expedice_alt_enable = 1) AND (G.expedice_alt_date <= 1284015600) -- 3. expedice => změna při vyčerpání skladových zásob LEFT JOIN expeditions stE ON stE.id = S.exped LEFT JOIN pe_goodsprices GP ON (GP.good = G.id) AND (GP.category = '2') AND ((G.vypocetceny = 'manual' AND GP.price > 0) OR G.vypocetceny = 'auto') WHERE ((PC.category = 296) OR ((296 = 45) AND (A.good IS NOT NULL))) AND (G.vlozeni < 1284015600) AND ((G.stazeni > 1284015600) OR (G.stazeni = 0)) AND (G.`delete` != 'y') AND (G.skryte = 'n') AND (G.nakupnicena > 0) AND M.main IS NULL -- hledání -- aby se neopakovalo zboží, které je ve více odděleních GROUP BY G.id -- řazení ORDER BY G.nazev LIMIT 0, 12