SELECT 
  a.* 
FROM 
  cscart_destination_elements as a 
  LEFT JOIN cscart_destinations as b ON b.destination_id = a.destination_id 
WHERE 
  b.status = 'A'

Query time 0.00348

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "20.43"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "b",
          "access_type": "index",
          "possible_keys": [
            "PRIMARY",
            "c_status"
          ],
          "key": "c_status",
          "used_key_parts": [
            "destination_id",
            "status"
          ],
          "key_length": "6",
          "rows_examined_per_scan": 6,
          "rows_produced_per_join": 1,
          "filtered": "16.67",
          "using_index": true,
          "cost_info": {
            "read_cost": "3.03",
            "eval_cost": "0.20",
            "prefix_cost": "3.23",
            "data_read_per_join": "776"
          },
          "used_columns": [
            "destination_id",
            "status"
          ],
          "attached_condition": "((`ea201_francemaqu`.`b`.`status` = 'A') and (`ea201_francemaqu`.`b`.`destination_id` is not null))"
        }
      },
      {
        "table": {
          "table_name": "a",
          "access_type": "ref",
          "possible_keys": [
            "c_status"
          ],
          "key": "c_status",
          "used_key_parts": [
            "destination_id"
          ],
          "key_length": "3",
          "ref": [
            "ea201_francemaqu.b.destination_id"
          ],
          "rows_examined_per_scan": 41,
          "rows_produced_per_join": 41,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "9.00",
            "eval_cost": "8.20",
            "prefix_cost": "20.43",
            "data_read_per_join": "31K"
          },
          "used_columns": [
            "element_id",
            "destination_id",
            "element",
            "element_type"
          ]
        }
      }
    ]
  }
}

Result

element_id destination_id element element_type
5326 1 FR C
5325 1 FX C
3807 7 US C
3808 7 CA C
3806 7 CN C
3805 7 RU C
597 10 AU C
598 10 JP C
599 10 BR C
2054 11 DE C
2053 11 GB C
2052 11 LU C
2051 11 NL C
2050 11 BE C
5323 12 MC C
5322 12 AD C
5321 12 LI C
5320 12 CH C
5319 12 ES C
5318 12 IT C
5317 12 AT C
5316 13 AF C
5315 13 ZA C
5314 13 AL C
5313 13 DZ C
5312 13 AO C
5311 13 AI C
5310 13 AQ C
5309 13 AG C
5308 13 CW C
5307 13 SA C
5306 13 AR C
5305 13 AM C
5304 13 AW C
5303 13 AP C
5302 13 AT C
5301 13 AZ C
5300 13 BS C
5299 13 BH C
5298 13 BD C
5297 13 BB C
5296 13 BZ C
5295 13 BJ C
5294 13 BM C
5293 13 BT C
5292 13 BY C
5291 13 MM C
5290 13 BO C
5289 13 BA C
5288 13 BW C
5287 13 BN C
5286 13 BG C
5285 13 BF C
5284 13 BI C
5283 13 KH C
5282 13 KY C
5281 13 CV C
5280 13 CM C
5279 13 TD C
5278 13 CL C
5277 13 CO C
5276 13 CY C
5275 13 CN C
5274 13 KM C
5273 13 CI C
5272 13 CR C
5271 13 CG C
5270 13 HR C
5269 13 CU C
5268 13 DK C
5267 13 DJ C
5266 13 DM C
5265 13 EG C
5264 13 AE C
5263 13 EC C
5262 13 ER C
5261 13 EE C
5260 13 ET C
5259 13 FJ C
5258 13 FI C
5257 13 LT C
5256 13 MO C
5255 13 MK C
5254 13 MG C
5253 13 MY C
5252 13 MW C
5251 13 MV C
5250 13 ML C
5249 13 MT C
5248 13 MA C
5247 13 MQ C
5246 13 MU C
5245 13 MR C
5244 13 YT C
5243 13 MX C
5242 13 FM C
5241 13 MD C
5240 13 MN C
5239 13 ME C
5238 13 MS C
5237 13 MZ C
5236 13 NA C
5235 13 NR C
5234 13 NP C
5233 13 NI C
5232 13 NE C
5231 13 NG C
5230 13 NU C
5229 13 NO C
5228 13 NC C
5227 13 NZ C
5226 13 OM C
5225 13 UG C
5224 13 UZ C
5223 13 PK C
5222 13 PW C
5221 13 PS C
5220 13 PA C
5219 13 PG C
5218 13 PY C
5217 13 NL C
5216 13 PE C
5215 13 PH C
5214 13 PL C
5213 13 PF C
5212 13 PR C
5211 13 PT C
5210 13 QA C
5209 13 CF C
5208 13 DO C
5207 13 IR C
5206 13 CZ C
5205 13 RO C
5204 13 RW C
5203 13 EH C
5202 13 SM C
5201 13 PM C
5200 13 VC C
5199 13 SH C
5198 13 LC C
5197 13 SV C
5196 13 WS C
5195 13 AS C
5194 13 ST C
5193 13 SN C
5192 13 CS C
5191 13 RS C
5190 13 SC C
5189 13 SL C
5188 13 SG C
5187 13 SK C
5186 13 SI C
5185 13 SO C
5184 13 SD C
5183 13 LK C
5182 13 KN C
5181 13 SE C
5180 13 SR C
5179 13 SJ C
5178 13 SZ C
5177 13 SY C
5176 13 TJ C
5175 13 TW C
5174 13 TZ C
5173 13 TF C
5172 13 IO C
5171 13 TH C
5170 13 TG C
5169 13 TK C
5168 13 TO C
5167 13 TT C
5166 13 TN C
5165 13 TM C
5164 13 TR C
5163 13 TV C
5162 13 UA C
5161 13 UY C
5160 13 VU C
5159 13 VA C
5158 13 VE C
5157 13 VN C
5156 13 WF C
5155 13 YE C
5154 13 ZR C
5153 13 ZM C
5152 13 ZW C
5151 13 LR C
5150 13 LY C
5149 13 LI C
5148 13 FX C
5147 13 GA C
5146 13 GH C
5145 13 GE C
5144 13 GM C
5143 13 GI C
5142 13 GR C
5141 13 GD C
5140 13 GU C
5139 13 GP C
5138 13 GL C
5137 13 GT C
5136 13 GN C
5135 13 GQ C
5134 13 GW C
5133 13 GF C
5132 13 GY C
5131 13 HT C
5130 13 HN C
5129 13 HK C
5128 13 HU C
5127 13 BV C
5126 13 CX C
5125 13 HM C
5124 13 NF C
5123 13 AX C
5122 13 CC C
5121 13 CK C
5120 13 FO C
5119 13 FK C
5118 13 MP C
5117 13 MH C
5116 13 PN C
5115 13 SB C
5114 13 TC C
5113 13 VI C
5112 13 VG C
5111 13 IN C
5110 13 ID C
5109 13 IQ C
5108 13 IE C
5107 13 IS C
5106 13 IL C
5105 13 JM C
5104 13 JO C
5103 13 KZ C
5102 13 KE C
5101 13 KG C
5100 13 KI C
5099 13 KP C
5098 13 KR C
5097 13 KW C
5096 13 RE C
5095 13 LA C
5094 13 LS C
5093 13 LV C
5092 13 LB C