|
0.001 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (5,2) OR category2Id IN (5,2)) AND active = 'yes' |
|
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=30 GROUP BY Product.id |
|
0.001 |
SELECT ColorTable.* FROM ColorTable, ProductColor WHERE ColorTable.id=ProductColor.colorId AND ProductColor.productId=30 ORDER BY id |
|
0.001 |
SELECT size.* FROM size, productsize WHERE size.id=productsize.sizeId AND productsize.productId=30 AND (productsize.stock + productsize.externalStock > 0 OR productsize.stock > 0 AND productsize.externalStock is null OR productsize.externalStock > 0 AND productsize.stock is null) ORDER BY size.sort ASC |
|
0.001 |
SELECT * FROM producttype WHERE id=31 |
|
0.001 |
SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 30 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` |
