SELECT

SQL Select

Executed SQL
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.visibility = %(visibility_1)s AND products.product_type = %(product_type_1)s ORDER BY products.name
Time
0.71 ms

Results

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
177 247 100 2026-02-11 13:00:26.681772+01:00 10000 False 2026-02-11 13:00:26.681772+01:00 Afrique de l'Ouest 3.0 5.0 Devise Afrique de l'Ouest (XOF) XOF 126 655.8237 655.8237 active afrique-de-l-ouest-xop true 20
34 245 1 2016-06-23 18:24:44+02:00 50 False 2026-02-11 07:49:59.013215+01:00 Afrique du Sud (ZAR) 4.0 6.0 Devise Rand sud africain ZAR 1000 18.9499 18.9499 active rand-afrique-du-sud true 8
33 192 1 2016-06-23 18:22:08+02:00 1 False 2026-02-11 07:49:59.013204+01:00 Arabie saoudite (SAR) 9.0 6.0 Devise Riyal saoudien SAR 1010 4.4679 4.4679 active riyal-arabie-saoudite true 7
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
12 46 100 2016-04-18 13:26:51+02:00 1000 False 2026-02-11 07:49:59.012910+01:00 Chili (CLP) 9.0 17.5 Devise Peso chilien CLP 1060 1020.4082 1020.4082 active peso-chili true 180
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
163 49 100 2016-11-09 16:44:36+01:00 10000 False 2026-02-11 07:49:59.013748+01:00 Colombie (COP) 3.0 16.0 Devise COP 1075 4354.4524 4354.4524 active peso-colombie true 177
31 121 100 2016-06-23 18:17:34+02:00 1000 False 2026-02-11 07:49:59.013179+01:00 Corée du Sud (KRW) 3.0 11.0 Devise Won coréen KRW 1080 1728.9372 1728.9372 active won-coree-du-sud true 40
143 50 100 2016-11-08 16:00:25+01:00 10000 False 2026-02-11 07:49:59.013471+01:00 Costa Rica (CRC) 6.0 9.5 Devise Colón costaricien CRC 1085 590.0053 590.0053 active colon-costa-rica true 240
17 58 100 2016-06-22 21:37:20+02:00 50 False 2026-02-11 07:49:59.012965+01:00 Danemark (DKK) 10.0 2.5 Devise Couronne danoise DKK 1100 7.471 7.471 active couronne-danemark true 26
36 2 1 2016-06-23 18:29:54+02:00 10 False 2026-02-11 07:49:59.013238+01:00 Emirats arabes unis (AED) 3.5 4.0 Devise Dirham émirati AED 1130 4.3762 4.3762 active dirham-emirats-arabes-unis true 15
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
28 94 1 2016-06-23 18:08:39+02:00 50 False 2026-02-11 07:49:59.013138+01:00 Hong Kong (HKD) 6.8 4.0 Devise Dollar hong-kongais HKD 1150 9.3127 9.3127 active dollar-hong-kong true 3
25 99 100 2016-06-23 17:39:45+02:00 500 False 2026-02-11 07:49:59.013101+01:00 Hongrie (HUF) 3.5 5.0 Devise Forint hongrois HUF 1160 377.8718 377.8718 active forint-hongrie true 199
10 104 100 2016-04-18 12:51:45+02:00 500 False 2026-02-11 07:49:59.012864+01:00 Inde (INR) 6.0 10.5 Devise Roupie indienne INR 1170 107.9226 107.9226 active roupie-inde true 33
52 100 1000 2016-06-23 19:09:56+02:00 50000 False 2026-02-11 07:49:59.013409+01:00 Indonésie (IDR) 5.0 15.0 Devise Roupie indonésienne IDR 1180 19984.0128 19984.0128 active rupiah-indonesie true 175
13 108 100 2016-06-07 11:34:06+02:00 1000 False 2026-02-11 07:49:59.012921+01:00 Islande (ISK) 3.8 6.0 Devise Couronne islandaise ISK 1190 145.02 145.02 active couronne-islande true 27
24 102 1 2016-06-23 17:34:32+02:00 20 False 2026-02-11 07:49:59.013082+01:00 Israël (ILS) 3.0 5.5 Devise Sheqel israëlien ILS 1200 3.666 3.666 active sheqel-israel true 25
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
42 112 1 2016-06-23 18:47:31+02:00 10 False 2026-02-11 07:49:59.013302+01:00 Jordanie (JOD) 4.0 4.8 Devise Dinar jordanien JOD 1220 0.8449 0.8449 active dinar-jordanie true 226
51 157 1 2016-06-23 19:08:04+02:00 1 False 2026-02-11 07:49:59.013399+01:00 Malaisie (MYR) 1.0 7.0 Devise Ringitt malaisien MYR 1230 4.6738 4.6738 active ringitt-malaisie true 174
37 136 100 2026-02-11 09:52:19.240325+01:00 200 False 2026-02-11 09:52:19.240325+01:00 Maroc (MAD) 2.5 18.0 Devise Dirham marocain MAD 1240 10.8695 10.8695 active dirham-maroc true 173
54 153 100 2016-06-23 19:15:17+02:00 100 False 2026-02-11 07:49:59.013429+01:00 Maurice (Ile) (MUR) 5.0 9.0 Devise Roupie mauricienne MUR 1250 54.4301 54.4301 active roupie-maurice-ile true 34
29 156 100 2016-06-23 18:10:46+02:00 50 False 2026-02-11 07:49:59.013151+01:00 Mexique (MXN) 2.5 12.0 Devise Peso mexicain MXN 1260 20.4593 20.4593 active peso-mexique true 198
15 166 1 2016-06-22 18:11:09+02:00 50 False 2026-02-11 07:49:59.012943+01:00 Norvège (NOK) 2.8 2.8 Devise Couronne norvégienne NOK 1270 11.3047 11.3047 active couronne-norvege true 28
38 170 1 2016-06-23 18:36:15+02:00 10 False 2026-02-11 07:49:59.013259+01:00 Nouvelle Zélande (NZD) 4.5 4.0 Devise Dollar néo-zélandais NZD 1280 1.967 1.967 active dollar-nouvelle-zelande true 4
151 171 1 2016-11-09 15:45:36+01:00 5 False 2026-02-11 07:49:59.013579+01:00 Oman (OMR) 5.0 5.5 Devise Rial omanais OMR 1285 0.4582 0.4582 active rial-oman true 32
47 173 1 2016-06-23 18:58:43+02:00 10 False 2026-02-11 07:49:59.013354+01:00 Pérou (PEN) 5.0 10.0 Devise Sol péruvien PEN 1300 4.0034 4.0034 active nuevo-sol-perou true 156
50 176 100 2016-06-23 19:06:22+02:00 500 False 2026-02-11 07:49:59.013385+01:00 Philippines (PHP) 7.0 11.0 Devise Peso philippin PHP 1310 69.471 69.471 active peso-philippines true 171
39 178 1 2016-06-23 18:38:31+02:00 10 False 2026-02-11 07:49:59.013271+01:00 Pologne (PLN) 6.0 3.5 Devise Zloty polonais PLN 1320 4.2173 4.2173 active zloty-pologne true 170
49 60 100 2016-06-23 19:04:14+02:00 500 False 2026-02-11 07:49:59.013375+01:00 République dominicaine (DOP) 5.0 9.8 Devise Peso dominicain DOP 1123 74.7256 74.7256 active peso-dominicaine-republique true 224
41 55 100 2016-06-23 18:42:38+02:00 100 False 2026-02-11 07:49:59.013292+01:00 République tchèque (CZK) 3.9 4.1 Devise Couronne tchèque CZK 1325 24.246 24.246 active couronne-tcheque-republique true 169
45 188 1 2016-06-23 18:54:18+02:00 1 False 2026-02-11 07:49:59.013333+01:00 Roumanie (RON) 8.5 7.0 Devise Leu roumain RON 1330 5.0914 5.0914 active leu-roumanie true 237
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
154 189 1 2016-11-09 15:54:12+01:00 1 False 2026-02-11 07:49:59.013617+01:00 Serbie (RSD) 15.0 4.0 Devise RSD 0 117.3599 117.3599 active dinar-serbie true 241
40 197 1 2016-06-23 18:40:17+02:00 2 False 2026-02-11 07:49:59.013282+01:00 Singapour (SGD) 5.0 5.5 Devise Dollar singapourien SGD 1360 1.5046 1.5046 active dollar-singapour true 5
16 196 100 2016-06-22 21:31:58+02:00 50 False 2026-02-11 07:49:59.012954+01:00 Suède (SEK) 3.3 2.8 Devise Couronne suédoise SEK 1370 10.5499 10.5499 active couronne-suede true 29
20 43 1 2016-06-22 21:42:16+02:00 10 False 2026-02-11 07:49:59.013015+01:00 Suisse (CHF) 2.5 1.3 Devise Franc suisse CHF 1380 0.9123 0.9123 active franc-suisse true 21
43 226 1 2016-06-23 18:50:13+02:00 1000 False 2026-02-11 07:49:59.013313+01:00 Taïwan (TWD) 15.0 18.0 Devise Dollar taïwanai TWD 1390 37.4755 37.4755 active dollar-taiwan true 23
14 216 100 2016-06-14 08:17:56+02:00 100 False 2026-02-11 07:49:59.012932+01:00 Thaïlande (THB) 5.5 5.0 Devise Baht taï THB 1410 37.035 37.035 active baht-thailande true 38
159 221 1 2026-01-28 15:02:33.920226+01:00 10 False 2026-02-11 07:49:59.013692+01:00 Tunisie (TND) 3.0 12.0 Devise Dinar Tunisien TND 47 3.4294 3.4294 active dinar-tunisie true 43
30 223 1 2026-02-02 11:25:43.601058+01:00 100 False 2026-02-11 07:49:59.013162+01:00 Turquie (TRY) 15.0 12.0 Devise Livre turque TRY 1420 52.0291 52.0291 active livre-turquie true 39
161 239 1000 2016-11-09 16:35:05+01:00 100000 False 2026-02-11 07:49:59.013714+01:00 Vietnam (VND) 10.0 15.5 Devise Dong Vietnamien VND 1440 30921.4595 30921.4595 active dong-vietnam true 181