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
| ID | COUNTRY_ID | COEFFICIENT | CREATION_DATE | DENOMINATION_MIN | IN_HOME_SLIDER | MODIFICATION_DATE | NAME | PERCENT_BUY | PERCENT_SELL | PRODUCT_TYPE | SHORT_DESCRIPTION | SKU | SORT_ORDER | SPOT | SPOT_YODA | STATUS | URL_KEY | VISIBILITY | YODAFOREX_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124 | 56 | 1 | 2016-10-23 14:55:42+02:00 | 1 | False | 2026-01-15 07:24:35.506662+01:00 | Allemagne - billets périmés (DEM) | 50.0 | 0.0 | Billets périmés | DEM-périmé | 4001 | 1.9558 | None | active | allemagne-dem-billets-perimes | true | None | |
| 125 | 14 | 1 | 2016-10-23 15:04:07+02:00 | 1 | False | 2026-01-15 07:24:35.506671+01:00 | Australie - billets périmés | 40.0 | 0.0 | Billets périmés | AUD-périmé | 4011 | 1.57 | None | active | australie-billets-perimes | true | None | |
| 126 | 38 | 1 | 2016-10-23 15:08:21+02:00 | 1 | False | 2026-01-15 07:24:35.506680+01:00 | Canada - billets périmés (CAD) | 40.0 | 0.0 | Billets périmés | CAD-périmé | 4021 | 1.48 | None | active | canada-billets-perimes-cad | true | None | |
| 172 | 113 | 1 | 2016-11-10 16:57:54+01:00 | 1 | False | 2026-01-15 07:24:35.514121+01:00 | Japon - billets périmés (JPY) | 40.0 | 0.0 | Billets périmés | JPY-périmé | 4041 | 135.0 | None | active | japon-jpy | true | None | |
| 129 | 76 | 1 | 2016-10-23 15:19:34+02:00 | 1 | False | 2026-01-15 07:24:35.506690+01:00 | Royaume Uni - billets périmés (GPB) | 30.0 | 0.0 | Billets périmés | GBP-périmé | 4051 | 0.92 | None | active | royaume-uni-billets-perimes-gpb | true | None | |
| 130 | 43 | 1 | 2016-10-23 15:23:36+02:00 | 1 | False | 2026-01-15 07:24:35.506698+01:00 | Suisse - billets périmés (CHF) | 15.0 | 0.0 | Billets périmés | CHF-périmé | 4061 | 1.04 | None | active | suisse-billets-perimes-chf | true | None |