--
-- Tabellenstruktur für Tabelle `tbl_shop_products`
--

CREATE TABLE `tbl_shop_products` (
 `PZN` int(7) unsigned zerofill NOT NULL,
 `ID_SHOP` smallint(5) unsigned NOT NULL,
 `PRICE` decimal(10,2) unsigned NOT NULL,
 UNIQUE KEY `PZN` (`PZN`,`ID_SHOP`),
 KEY `PRICE` (`PRICE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Shop Preise';

--
-- Daten für Tabelle `tbl_shop_products`
--

INSERT INTO `tbl_shop_products` (`PZN`, `ID_SHOP`, `PRICE`) VALUES
(1691621, 1, 5.75),
(1797130, 2, 2.99),
(1691621, 2, 5.75),
(1797130, 1, 8.61),
(1691621, 3, 12.99);

SELECT `ID_SHOP`, SUM(`PRICE`) AS PRICE_TOTAL, COUNT(`PZN`) AS COUNT FROM `tbl_shop_products` WHERE `PZN` IN (1797130,1691621)
GROUP BY `ID_SHOP`
HAVING COUNT = 2
ORDER BY `PRICE` ASC

SELECT `ID_SHOP`, SUM(`PRICE`) + SUM(`SHIPPING`) AS PRICE_TOTAL, COUNT(`PZN`) AS COUNT FROM `tbl_shop_products` WHERE `PZN` IN (1797130,1691621)
GROUP BY `ID_SHOP`
HAVING COUNT = 2
ORDER BY `PRICE` + 'SHIPPING' ASC