SELECT * FROM shop_products WHERE deleted_at IS NULL AND type = :type AND price > '0' AND active = :active AND forsale > 0 ORDER BY url, name, priceSELECT * FROM shop_products WHERE deleted_at IS NULL AND type = :type AND price > '0' AND active = :active AND forsale > 0 ORDER BY url, name, price