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.product_type = %(product_type_1)s ORDER BY products.name
Time
1.24 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
167 246 100 2016-11-09 16:55:41+01:00 500 False 2026-02-11 07:49:59.013824+01:00 Afrique centrale (XAF) 15.0 3.0 Devise XAF 0 655.9528 655.9528 active franc-cfa-afrique-centrale false 18
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
48 11 1 2016-06-23 19:00:42+02:00 500 False 2026-02-11 07:49:59.013365+01:00 Argentine (ARS) 35.0 1.0 Devise Peso argentin ARS 1020 1673.0801 1673.0801 active peso-argentine false 213
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
168 32 1 2016-11-09 16:59:01+01:00 1 False 2026-02-11 07:49:59.013840+01:00 Bahamas (BSD) 15.0 2.3 Devise BSD 0 1.1904 1.1904 active dollar-bahamas false 152
165 24 1 2016-11-09 16:51:07+01:00 1 False 2026-02-11 07:49:59.013781+01:00 Bahreïn (BHD) 12.0 4.6 Devise BHD 0 0.4492 0.4492 active dinar-bahrein false 244
166 20 100 2016-11-09 16:53:28+01:00 500 False 2026-02-11 07:49:59.013807+01:00 Bangladesh (BDT) 50.0 5.0 Devise BDT 0 145.6198 145.6198 active taka-bangladesh false 206
162 28 1 2016-11-09 16:37:43+01:00 1 False 2026-02-11 07:49:59.013731+01:00 Bermudes (BMD) 15.0 10.0 Devise BMD 0 1.1946 1.1946 active dollar-bermudes false 168
26 31 1 2026-02-02 11:09:29.597365+01:00 100 False 2026-02-11 07:49:59.013126+01:00 Brésil (BRL) 3.5 13.0 Devise Real brésilien BRL 1040 6.1958 6.1958 active real-bresil false 203
164 123 1 2016-11-09 16:48:20+01:00 1 False 2026-02-11 07:49:59.013764+01:00 Caïmans (Iles) (KYD) 20.0 10.0 Devise KYD 0 0.9935 0.9935 active dollar-caimans-iles false 243
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
176 248 1 2017-01-13 13:21:38+01:00 1 False 2026-02-11 07:49:59.013876+01:00 Dollar Caraïbes Orientales 20.0 3.0 Devise XCD 128 3.2107 3.2107 active dollar-caraibes-orientales false 9
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
144 70 1 2016-11-09 14:38:22+01:00 1 False 2026-02-11 07:49:59.013481+01:00 Fidji (FJD) 10.0 6.0 Devise FJD 0 2.6064 2.6064 active dollar-fidji-iles false 212
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
145 114 1 2016-11-09 14:43:01+01:00 1 False 2026-02-11 07:49:59.013498+01:00 Kenya (KES) 20.0 8.0 Devise KES 0 153.4401 153.4401 active schilling-kenya false 98
146 122 1 2016-11-09 14:51:02+01:00 1 False 2026-02-11 07:49:59.013509+01:00 Koweït (KWD) 8.5 4.015 Devise KWD 0 0.3656 0.3656 active dinar-koweit false 12
174 125 1000 2016-12-13 14:38:00+01:00 500 False 2026-02-11 07:49:59.013860+01:00 Laos (LAK) 8.0 7.0 Devise LAK 0 25562.3722 25562.3722 active kip-laos false 295
147 126 1 2016-11-09 14:57:02+01:00 1 False 2026-02-11 07:49:59.013525+01:00 Liban (LBP) 50.0 1.0 Devise LBP 0 106609.8081 106609.8081 active livre-liban false 248
148 141 1000 2016-11-09 15:36:01+01:00 100 False 2026-02-11 07:49:59.013535+01:00 Madagascar (MGA) 15.0 10.0 Devise MGA 0 5277.6019 5277.6019 active ariary-madagascar false 130
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
149 167 100 2016-11-09 15:41:22+01:00 1 False 2026-02-11 07:49:59.013551+01:00 Népal (NPR) 15.0 5.0 Devise NPR 0 172.4406 172.4406 active roupie-nepal false 235
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
56 174 1 2016-06-23 19:20:16+02:00 10000 True 2026-02-11 07:49:59.013440+01:00 Pacifique - Franc (XPF) 1.0 10.0 Devise Franc CFP polynésien XPF 1290 119.4529 119.4529 active franc-pacifique false 231
152 177 100 2016-11-09 15:48:43+01:00 1 False 2026-02-11 07:49:59.013590+01:00 Pakistan (PKR) 50.0 1.0 Devise PKR 0 333.0114 333.0114 active roupie-pakistan false 172
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
153 186 1 2016-11-09 15:51:36+01:00 1 False 2026-02-11 07:49:59.013600+01:00 Qatar (QAR) 10.0 6.0 Devise Riyal qatari QAR 1325 4.3384 4.3384 active riyal-qatar false 209
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
156 194 100 2016-11-09 16:11:24+01:00 1 False 2026-02-11 07:49:59.013635+01:00 Seychelles (SCR) 15.0 8.0 Devise SCR 0 16.316 16.316 active roupie-seychelles false 35
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
158 224 1 2016-11-09 16:24:51+01:00 1 False 2026-02-11 07:49:59.013681+01:00 Trinité et Tobago (TTD) 15.0 7.0 Devise TTD 0 7.2469 7.2469 active dollar-trinidad-et-tobago false 250
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
44 228 1 2016-06-23 18:52:32+02:00 10 False 2026-02-11 07:49:59.013323+01:00 Ukraine (UAH) 15.0 3.0 Devise Hryvnia ukrainien UAH 1430 51.2679 51.2679 active hryvnia-ukraine false 247
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