|
0.001 |
SELECT Product.*, t.name AS tm_name, t.homepage AS tm_homepage, t.garancijskaDoba as tm_garancija, Product.preorder, count(productdiscount.productId)>0 AS hasqdisc FROM Product LEFT JOIN trademark AS t ON t.id=Product.trademarkId LEFT JOIN productdiscount ON Product.id=productdiscount.productId WHERE Product.id=6 GROUP BY Product.id |
|
0.001 |
SELECT ColorTable.* FROM ColorTable, ProductColor WHERE ColorTable.id=ProductColor.colorId AND ProductColor.productId=6 ORDER BY id |
|
0.001 |
SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 6 AND definesPackagePart='no' AND additional_product = '0') AND active='yes' ORDER BY (Product.unitPrice*(1-Product.discount/100)) |
|
0.001 |
SELECT COUNT(*), `productId` FROM `OrderItem` WHERE `productId` != 0 GROUP BY `productId` |
