SELECT SQL_CALC_FOUND_ROWS
	pro.ProductID,
	a.AuthorName,
	pro.extension,
	pro.ProductName,
	pro.ProductIsActive,
	pro.ProductQuantity,
	pro.ProductPrice AS price,
	promo.promo_price AS newPrice,
	promo.promo_percent,
	promo.promo_reduction,
	COALESCE(promo.promo_price, pro.ProductPrice) AS currentPrice
	FROM Products AS pro
	LEFT JOIN _promotions AS promo ON pro.ProductID = promo.ProductID
	LEFT JOIN Authors AS a ON pro.AuthorID = a.AuthorID WHERE ProductIsActive=1 AND pro.AuthorID IN (138) ORDER BY pro.ProductID DESC LIMIT 0, 24

Търсене

Намерени са 1 продукт(а) отговарящи на критериите:

  • Автор: Апостол Стаматов
Промени търсенето
1 продукт(а)