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.in_home_slider IS true AND products.status = %(status_1)s AND products.visibility = %(visibility_1)s AND products.product_type = %(product_type_1)s
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19 | 14 | 1 | 2016-06-22 21:41:24+02:00 | 5 | True | 2026-02-11 07:49:59.012997+01:00 | Australie (AUD) | 2.3 | 2.8 | Devise | Dollar australien | AUD | 1030 | 1.6765 | 1.6765 | active | dollar-australie | true | 1 |
| 18 | 38 | 1 | 2016-06-22 21:39:21+02:00 | 5 | True | 2026-02-11 07:49:59.012975+01:00 | Canada (CAD) | 2.0 | 2.4 | Devise | Dollar canadien | CAD | 1050 | 1.6114 | 1.6114 | active | dollar-canada | true | 2 |
| 23 | 48 | 1 | 2016-06-22 21:46:38+02:00 | 50 | True | 2026-02-11 07:49:59.013056+01:00 | Chine (CNY) | 5.5 | 6.0 | Devise | Yuan chinois | CNY | 1070 | 8.2359 | 8.2359 | active | yuan-chine | true | 179 |
| 11 | 231 | 1 | 2026-02-11 15:53:33.152057+01:00 | 1 | True | 2026-02-11 15:53:33.152057+01:00 | Etats-Unis (USD) | 2.2 | 1.0 | Devise | Dollar Etats-Unis | USD | 1140 | 1.184 | 1.1917 | active | dollar-etats-unis | true | 6 |
| 21 | 76 | 1 | 2016-06-22 21:43:25+02:00 | 5 | True | 2026-02-11 07:49:59.013033+01:00 | Royaume Uni (GPB) | 1.8 | 1.6 | Devise | Livre britanniqueangleterre - grande bretagne | GBP | 1340 | 0.8718 | 0.8718 | active | livre-angleterre | true | 48 |
| 22 | 113 | 100 | 2016-06-22 21:45:11+02:00 | 1000 | True | 2026-02-11 07:49:59.013045+01:00 | Japon (JPY) | 1.5 | 3.0 | Devise | Yen japonais | JPY | 1210 | 182.4052 | 182.4052 | active | yen-japon | true | 41 |