SELECT products.id, products.country_id, products.coefficient, products.creation_date, products.denomination_min, products.in_home_slider, products.modification_date, products.name, products.percent_buy, products.percent_sell, products.product_type, products.short_description, products.sku, products.sort_order, products.spot, products.spot_yoda, products.status, products.url_key, products.visibility, products.yodaforex_id
FROM products
WHERE products.status = %(status_1)s AND products.product_type = %(product_type_1)s ORDER BY products.name