SELECT 
  cscart_categories.category_id, 
  cscart_categories.parent_id, 
  cscart_categories.id_path, 
  cscart_category_descriptions.category, 
  cscart_categories.position, 
  cscart_categories.status, 
  cscart_categories.company_id, 
  cscart_categories.storefront_id, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path, 
  cscart_categories.ab__lc_catalog_image_control 
FROM 
  cscart_categories 
  LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id 
  AND cscart_category_descriptions.lang_code = 'ar' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id 
  AND cscart_seo_names.type = 'c' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'ar' 
WHERE 
  1 = 1 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A') 
  AND cscart_categories.category_id != 264 
  AND cscart_categories.parent_id != 264 
  AND cscart_categories.storefront_id IN (0, 1) 
  AND cscart_categories.category_id IN(
    166, 
    167, 
    170, 
    174, 
    190, 
    203, 
    204, 
    208, 
    219, 
    228, 
    229, 
    230, 
    231, 
    234, 
    235, 
    236, 
    245, 
    250, 
    458, 
    251, 
    305, 
    308, 
    320, 
    321, 
    322, 
    323, 
    324, 
    325, 
    326, 
    328, 
    329, 
    330, 
    331, 
    332, 
    333, 
    334, 
    336, 
    337, 
    339, 
    340, 
    341, 
    342, 
    543, 
    343, 
    344, 
    346, 
    347, 
    350, 
    351, 
    352, 
    353, 
    354, 
    355, 
    356, 
    357, 
    358, 
    359, 
    360, 
    361, 
    362, 
    363, 
    364, 
    366, 
    369, 
    371, 
    372, 
    378, 
    379, 
    380, 
    381, 
    382, 
    383, 
    384, 
    385, 
    386, 
    387, 
    393, 
    394, 
    395, 
    397, 
    398, 
    399, 
    400, 
    401, 
    402, 
    404, 
    405, 
    406, 
    407, 
    408, 
    409, 
    410, 
    411, 
    412, 
    413, 
    414, 
    415, 
    416, 
    417, 
    418, 
    419, 
    420, 
    421, 
    422, 
    423, 
    424, 
    425, 
    426, 
    428, 
    429, 
    430, 
    432, 
    434, 
    435, 
    436, 
    438, 
    439, 
    440, 
    441, 
    443, 
    444, 
    446, 
    448, 
    449, 
    450, 
    451, 
    452, 
    453, 
    454, 
    455, 
    457, 
    459, 
    460, 
    461, 
    462, 
    463, 
    464, 
    566, 
    465, 
    466, 
    467, 
    468, 
    469, 
    470, 
    471, 
    577, 
    473, 
    474, 
    475, 
    476, 
    477, 
    480, 
    481, 
    482, 
    483, 
    485, 
    486, 
    487, 
    488, 
    489, 
    490, 
    491, 
    492, 
    493, 
    494, 
    496, 
    497, 
    498, 
    499, 
    500, 
    502, 
    503, 
    504, 
    505, 
    506, 
    507, 
    513, 
    514, 
    515, 
    516, 
    517, 
    518, 
    519, 
    520, 
    521, 
    522, 
    523, 
    524, 
    525, 
    526, 
    527, 
    528, 
    530, 
    531, 
    532, 
    535, 
    536, 
    537, 
    538, 
    539, 
    540, 
    472, 
    542, 
    544, 
    545, 
    546, 
    547, 
    548, 
    552, 
    549, 
    550, 
    551, 
    553, 
    554, 
    555, 
    556, 
    557, 
    559, 
    560, 
    561, 
    562, 
    563, 
    564, 
    565, 
    567, 
    568, 
    569, 
    570, 
    571, 
    572, 
    573, 
    574, 
    575, 
    576, 
    578, 
    579, 
    580, 
    581, 
    582, 
    583, 
    584, 
    585, 
    586, 
    587, 
    534, 
    588, 
    590, 
    591, 
    592, 
    593, 
    594, 
    595, 
    596, 
    597, 
    598, 
    599, 
    600, 
    601, 
    602, 
    603, 
    612, 
    613, 
    614, 
    615, 
    616, 
    617, 
    618, 
    619, 
    620, 
    621, 
    622, 
    623, 
    624, 
    625, 
    626, 
    627, 
    558, 
    628, 
    629, 
    630, 
    631, 
    632, 
    633, 
    634, 
    635, 
    636, 
    637, 
    638, 
    639, 
    640, 
    641, 
    642, 
    643, 
    644, 
    645, 
    646, 
    647, 
    648, 
    649, 
    650, 
    651, 
    652, 
    653, 
    654, 
    655, 
    656, 
    657, 
    658, 
    659, 
    660, 
    661, 
    662, 
    663, 
    664, 
    666, 
    667, 
    668, 
    669
  ) 
ORDER BY 
  cscart_categories.is_trash asc, 
  cscart_categories.position asc, 
  cscart_category_descriptions.category asc

Query time 0.01005

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "186.68"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "ALL",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "parent",
              "p_category_id"
            ],
            "rows_examined_per_scan": 347,
            "rows_produced_per_join": 6,
            "filtered": "1.83",
            "cost_info": {
              "read_cost": "36.91",
              "eval_cost": "0.64",
              "prefix_cost": "37.54",
              "data_read_per_join": "19K"
            },
            "used_columns": [
              "category_id",
              "parent_id",
              "id_path",
              "company_id",
              "storefront_id",
              "usergroup_ids",
              "status",
              "position",
              "is_trash",
              "ab__lc_catalog_image_control"
            ],
            "attached_condition": "(((`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`usergroup_ids`))) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`status` = 'A') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`category_id` <> 264) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`parent_id` <> 264) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`storefront_id` in (0,1)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`category_id` in (166,167,170,174,190,203,204,208,219,228,229,230,231,234,235,236,245,250,458,251,305,308,320,321,322,323,324,325,326,328,329,330,331,332,333,334,336,337,339,340,341,342,543,343,344,346,347,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,369,371,372,378,379,380,381,382,383,384,385,386,387,393,394,395,397,398,399,400,401,402,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,428,429,430,432,434,435,436,438,439,440,441,443,444,446,448,449,450,451,452,453,454,455,457,459,460,461,462,463,464,566,465,466,467,468,469,470,471,577,473,474,475,476,477,480,481,482,483,485,486,487,488,489,490,491,492,493,494,496,497,498,499,500,502,503,504,505,506,507,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,530,531,532,535,536,537,538,539,540,472,542,544,545,546,547,548,552,549,550,551,553,554,555,556,557,559,560,561,562,563,564,565,567,568,569,570,571,572,573,574,575,576,578,579,580,581,582,583,584,585,586,587,534,588,590,591,592,593,594,595,596,597,598,599,600,601,602,603,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,558,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,666,667,668,669)))"
          }
        },
        {
          "table": {
            "table_name": "cscart_category_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "softwarepirmam_hewadelivard_cscart_4.cscart_categories.category_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 6,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "1.59",
              "eval_cost": "0.64",
              "prefix_cost": "39.77",
              "data_read_per_join": "21K"
            },
            "used_columns": [
              "category_id",
              "lang_code",
              "category"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_seo_names",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "dispatch"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "type",
              "dispatch",
              "lang_code"
            ],
            "key_length": "206",
            "ref": [
              "softwarepirmam_hewadelivard_cscart_4.cscart_categories.category_id",
              "const",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 66,
            "rows_produced_per_join": 419,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "104.94",
              "eval_cost": "41.98",
              "prefix_cost": "186.68",
              "data_read_per_join": "711K"
            },
            "used_columns": [
              "name",
              "object_id",
              "type",
              "dispatch",
              "path",
              "lang_code"
            ]
          }
        }
      ]
    }
  }
}

Result

category_id parent_id id_path category position status company_id storefront_id seo_name seo_path ab__lc_catalog_image_control
379 378 166/378/379 Anker 10 A 0 0 anker-ar 166/378 none
323 322 166/322/323 Apple watch 10 A 0 0 apple-watch-ar 166/322 none
440 251 250/458/251/440 Casio 10 A 0 0 casio-ar 250/458/251 none
385 308 250/308/385 Combo 10 A 0 0 combo-ar 250/308 none
441 336 250/336/441 deli 10 A 0 0 deli-ar 250/336 none
568 406 250/402/406/568 Ethernet Cable 10 A 0 0 ethernet-cable-ar 250/402/406 none
593 592 372/572/592/593 Freestanding Ranges 10 A 0 0 freestanding-ranges-ar 372/572/592 none
321 320 166/320/321 iPad 10 A 0 0 ipad-ar 166/320 none
235 234 166/234/235 iPhone 10 A 0 0 iphone-ar 166/234 none
659 658 658/659 Laptop Bags 10 A 0 0 laptop-bags-ar 658 none
628 558 558/628 LEGO 10 A 0 0 lego-ar 558 none
356 167 166/167/356 Mac 10 A 0 0 mac-ar 166/167 none
542 472 472/542 Network Cables 10 A 0 0 network-cables-ar 472 none
539 538 521/538/539 NVR 10 A 0 0 nvr-ar 521/538 none
415 414 166/351/414/415 Online & Smart UPS 10 A 0 0 online-and-smart-ups-ar 166/351/414 none
332 245 245/332 PlayStation 10 A 0 0 playstation-ar 245 none
414 351 166/351/414 UPS 10 A 0 0 ups 166/351 none
357 170 166/170/357 Xiaomi 10 A 0 0 xiaomi-ar 166/170 none
435 434 372/434/435 Xiaomi 10 A 0 0 xiaomi-ar 372/434 none
436 369 203/369/436 Xiaomi 10 A 0 0 xiaomi-ar 203/369 none
549 552 372/552/549 آلات الصودا 10 A 0 0 soda-machine-ar 372/552 none
554 553 250/553/554 آلات القهوة 10 A 0 0 coffee-machine-ar 250/553 none
556 552 372/552/556 آلات القهوة 10 A 0 0 coffee-machine-ar 372/552 none
416 332 245/332/416 أجهزة اللعب وأجهزة التحكم 10 A 0 0 console-and-controllers-ar 245/332 none
419 333 245/333/419 أجهزة اللعب وأجهزة التحكم 10 A 0 0 console-and-controllers-ar 245/333 none
421 334 245/334/421 أجهزة اللعب وأجهزة التحكم 10 A 0 0 console-and-controllers-ar 245/334 none
360 359 166/328/359/360 أكسس بوينت داخلي 10 A 0 0 indoor-access-point-ar 166/328/359 none
412 407 250/402/407/412 أكسس بوينت داخلي 10 A 0 0 indoor-access-point-ar 250/402/407 none
305 458 250/458/305 أوراق 10 A 0 0 paper-ar 250/458 none
535 522 521/522/535 إسطوانية 10 A 0 0 bullet-ar 521/522 none
166 0 166 إلكترونيات 10 A 0 0 electronics-ar none
344 329 166/329/344 إيربودز 10 A 0 0 airpods 166/329 none
493 219 219/493 التجارة 10 A 0 0 business-ar 219 none
560 557 372/552/557/560 القهوة المطحونة 10 A 0 0 ground-coffee-ar 372/552/557 none
562 555 250/553/555/562 القهوة المطحونة 10 A 0 0 ground-coffee-ar 250/553/555 none
623 621 577/621/623 امرأة 10 A 0 0 women-ar 577/621 none
601 600 166/600/601 بروسيسور (CPU) 10 A 0 0 cpu-ar 166/600 none
330 228 228/330 بيانو 10 A 0 0 piano-ar 228 none
453 372 372/453 تلفاز وسينما 10 A 0 0 tv-and-theatre-ar 372 none
190 174 166/174/190 تلفازات 10 A 0 0 tvs 166/174 none
454 453 372/453/454 تلفازات 10 A 0 0 tvs-ar 372/453 none
582 572 372/572/582 ثلاجات 10 A 0 0 refrigerator-ar 372/572 none
341 328 166/328/341 راوتر 10 A 0 0 router-ar 166/328 none
404 402 250/402/404 راوتر 10 A 0 0 router-ar 250/402 none
527 329 166/329/527 ساوند بارز 10 A 0 0 sound-bars-ar 166/329 none
362 342 166/328/342/362 سويتش مدار 10 A 0 0 managed-switch-ar 166/328/342 none
410 405 250/402/405/410 سويتش مدار 10 A 0 0 managed-switch-ar 250/402/405 none
371 250 250/371 طابعات 10 A 0 0 printer-ar 250 none
393 371 250/371/393 طابعات الحبر 10 A 0 0 inkjet-printer-ar 250/371 none
651 650 577/650/651 طلاء الأظافر 10 A 0 0 nail-polish-ar 577/650 none
467 466 372/466/467 قلاية هوائية 10 A 0 0 air-fryers-ar 372/466 none
450 424 166/423/424/450 كابلات 10 A 0 0 cables-ar 166/423/424 none
546 545 521/545/546 كابلات الإيثرنت 10 A 0 0 ethernet-cables-ar 521/545 none
522 521 521/522 كاميرا CCTV 10 A 0 0 cctv-camera-ar 521 none
167 166 166/167 كمبيوترات ولابتوبات 10 A 0 0 laptops 166 none
381 350 166/350/381 كومبو 10 A 0 0 combo-ar 166/350 none
474 473 577/473/474 مجفف شعر 10 A 0 0 hair-dryer-ar 577/473 none
588 534 521/534/588 مقبض باب ذكي 10 A 0 0 smart-door-handle-ar 521/534 none
459 384 372/384/459 مكانس روبوت ذكية 10 A 0 0 smart-robot-vacuums-ar 372/384 none
630 629 577/629/630 منظف ​​الوجه 10 A 0 0 cleaners-ar 577/629 none
462 461 372/461/462 منقّي الهواء 10 A 0 0 air-purifiers-ar 372/461 none
514 513 166/513/514 هارد ديسك درايفز (HDD) 10 A 0 0 hard-disk-drives-hdd-ar 166/513 none
617 616 577/616/617 وجه 10 A 0 0 face-ar 577/616 none
569 406 250/402/406/569 Coaxial Cable 20 A 0 0 coaxial-cable-ar 250/402/406 none
594 592 372/572/592/594 Cooktops 20 A 0 0 cooktops-ar 372/572/592 none
352 167 166/167/352 Dell 20 A 0 0 dell-ar 166/167 none
540 538 521/538/540 DVR 20 A 0 0 dvr-ar 521/538 none
326 234 166/234/326 Galaxy 20 A 0 0 galaxy 166/234 none
325 320 166/320/325 Galaxy Tab 20 A 0 0 galaxy-tab-ar 166/320 none
324 322 166/322/324 Galaxy Watch 20 A 0 0 galaxy-watch-ar 166/322 none
432 378 166/378/432 Hama 20 A 0 0 hama-ar 166/378 none
358 170 166/170/358 LG 20 A 0 0 lg-ar 166/170 none
386 308 250/308/386 Mouse 20 A 0 0 mouse-ar 250/308 none
422 334 245/334/422 Nintendo ألعاب 20 A 0 0 nintendo-games-ar 245/334 none
613 414 166/351/414/613 Offline UPS 20 A 0 0 offline-ups-ar 166/351/414 none
429 351 166/351/429 PDU 20 A 0 0 pdu-ar 166/351 none
418 332 245/332/418 PS ألعاب 20 A 0 0 ps-games-ar 245/332 none
660 658 658/660 Travel Bags 20 A 0 0 travel-bags-ar 658 none
333 245 245/333 XBOX 20 A 0 0 xbox-ar 245 none
420 333 245/333/420 XBOX ألعاب 20 A 0 0 xbox-games-ar 245/333 none
590 534 521/534/590 أجهزة الدخول 20 A 0 0 access-devices-ar 521/534 none
485 458 250/458/485 أقلام 20 A 0 0 pen-ar 250/458 none
361 359 166/328/359/361 أكسس بوينت خارجي 20 A 0 0 outdoor-access-point-ar 166/328/359 none
413 407 250/402/407/413 أكسس بوينت خارجي 20 A 0 0 outdoor-access-point-ar 250/402/407 none
245 0 245 ألعاب فيديو 20 A 0 0 video-games-ar none
573 466 372/466/573 الشوايات والمحامص 20 A 0 0 grillers-and-toasters-ar 372/466 none
536 522 521/522/536 القبة 20 A 0 0 dome-ar 521/522 none
561 557 372/552/557/561 الكبسولات 20 A 0 0 capsules-ar 372/552/557 none
563 555 250/553/555/563 الكبسولات 20 A 0 0 capsules-ar 250/553/555 none
534 521 521/534 تحكم الدخول 20 A 0 0 access-control-ar 521 none
602 600 166/600/602 جرافيكس كاردز (GPU) 20 A 0 0 graphics-cards-gpu-ar 166/600 none
331 228 228/331 جيتار 20 A 0 0 guitar-ar 228 none
555 553 250/553/555 حبوب البن و الكبسولات 20 A 0 0 beans-and-capsules-ar 250/553 none
557 552 372/552/557 حبوب البن و الكبسولات 20 A 0 0 beans-and-capsules-ar 372/552 none
622 621 577/621/622 رجل 20 A 0 0 men-ar 577/621 none
337 174 166/174/337 ساوند بار (مكبرات) 20 A 0 0 sound-bars 166/174 none
455 453 372/453/455 ساوند بار (مكبرات) 20 A 0 0 sound-bars 372/453 none
515 513 166/513/515 سوليد ستيت درايفز (SSD) 20 A 0 0 solid-state-drives-ssd-ar 166/513 none
363 342 166/328/342/363 سويتش غير مدار 20 A 0 0 unmanaged-switch-ar 166/328/342 none
411 405 250/402/405/411 سويتش غير مدار 20 A 0 0 unmanaged-switch-ar 250/402/405 none
342 328 166/328/342 سويتشات 20 A 0 0 switch-ar 166/328 none
405 402 250/402/405 سويتشات 20 A 0 0 switch-ar 250/402 none
424 423 166/423/424 شواحن & HDMI 20 A 0 0 chargers-ar 166/423 none
394 371 250/371/394 طابعات ليزر 20 A 0 0 laser-printer-ar 250/371 none
652 650 577/650/652 علاج الأظافر 20 A 0 0 nail-treatment-ar 577/650 none
618 616 577/616/618 عيون 20 A 0 0 eyes-ar 577/616 none
547 545 521/545/547 كابلات كوكسيل 20 A 0 0 coaxial-cables-ar 521/545 none
494 219 219/494 كتب الأطفال 20 A 0 0 children-books-ar 219 none
382 350 166/350/382 ماوس 20 A 0 0 mouse-ar 166/350 none
451 424 166/423/424/451 محولات 20 A 0 0 power-adapter-ar 166/423/424 none
631 629 577/629/631 مرطبات 20 A 0 0 moisturizers-ar 577/629 none
463 461 372/461/463 مرطّب الهواء 20 A 0 0 air-humidifiers-ar 372/461 none
461 372 372/461 معالجة الهواء 20 A 0 0 air-care-ar 372 none
336 250 250/336 مفرمة ورق 20 A 0 0 shredder-ar 250 none
460 384 372/384/460 مكانس لاسلكية 20 A 0 0 cordless-vacuums-ar 372/384 none
475 473 577/473/475 مكواة فرد الشعر 20 A 0 0 hair-straightener-ar 577/473 none
550 552 372/552/550 نكات الشراب 20 A 0 0 syrup-ar 372/552 none
538 521 521/538 CCTV مسجلات 30 A 0 0 cctv-recorders-ar 521 none
551 552 372/552/551 CO₂ الإكسسوارات و 30 A 0 0 co2-and-accessories-ar 372/552 none
598 384 372/384/598 Handheld Vacuums 30 A 0 0 handheld-vacuums-ar 372/384 none
353 167 166/167/353 HP 30 A 0 0 hp-ar 166/167 none
387 308 250/308/387 Keyboard 30 A 0 0 keyboard-ar 250/308 none
208 204 203/204/208 Mountain Bikes 30 A 0 0 mountain-bikes-ar 203/204 none
334 245 245/334 Nintendo 30 A 0 0 nintendo-ar 245 none
570 406 250/402/406/570 POE Adapters 30 A 0 0 poe-adapters-ar 250/402/406 none
571 545 521/545/571 POE Adapters 30 A 0 0 poe-adapters-ar 521/545 none
236 234 166/234/236 Xiaomi 30 A 0 0 xiaomi-ar 166/234 none
443 378 166/378/443 Xiaomi 30 A 0 0 xiaomi-ar 166/378 none
339 320 166/320/339 Xiaomi Pad 30 A 0 0 xiaomi-pad 166/320 none
340 322 166/322/340 Xiaomi Smart Watches 30 A 0 0 xiaomi-smart-watches-ar 166/322 none
372 0 372 أجهزة منزلية 30 A 0 0 home-appliance-ar none
417 332 245/332/417 إكسسوارات 30 A 0 0 accessories-ar 245/332 none
480 333 245/333/480 إكسسوارات 30 A 0 0 accessories-ar 245/333 none
653 650 577/650/653 الإكسسوارات والأظافر الصناعية 30 A 0 0 accessories-and-fake-nails-ar 577/650 none
619 616 577/616/619 الخدين 30 A 0 0 cheeks-ar 577/616 none
430 351 166/351/430 بطاريات 30 A 0 0 batteries-ar 166/351 none
476 473 577/473/476 تصفيف الشعر 30 A 0 0 hair-stylers-ar 577/473 none
251 458 250/458/251 حاسبات 30 A 0 0 calculators-ar 250/458 none
574 466 372/466/574 خلاطات 30 A 0 0 mixers-ar 372/466 none
489 371 250/371/489 طابعات النقاط 30 A 0 0 dot-matrix-printers-ar 250/371 none
584 572 372/572/584 غسالات الصحون 30 A 0 0 dish-washers-ar 372/572 none
583 372 372/583 غسالات ومجففات الملابس 30 A 0 0 washing-machin-and-dryers-ar 372 none
343 543 166/328/543/343 كابل إيثرنت 30 A 0 0 ethernet-cable-ar 166/328/543 none
406 402 250/402/406 كابل إيثرنت 30 A 0 0 ethernet-cable-ar 250/402 none
452 424 166/423/424/452 كومبو 30 A 0 0 combo-ar 166/423/424 none
383 350 166/350/383 كيبورد 30 A 0 0 keyboard-ar 166/350 none
625 621 577/621/625 للجنسين 30 A 0 0 unisex-ar 577/621 none
603 600 166/600/603 ماذربوردز 30 A 0 0 motherboards-ar 166/600 none
425 423 166/423/425 محطة شحن 30 A 0 0 docking-stations 166/423 none
465 566 372/566/465 مراوح تبريد 30 A 0 0 cooling-fans-ar 372/566 none
384 372 372/384 مكانس كهربائية 30 A 0 0 vacuums-ar 372 none
591 534 521/534/591 نظام إنتركم بالفيديو 30 A 0 0 video-intercom-ar 521/534 none
234 166 166/234 هواتف 30 A 0 0 mobiles 166 none
516 513 166/513/516 يو إس بي فلاش درايفز 30 A 0 0 usb-flash-drives-ar 166/513 none
544 543 166/328/543/544 كابلات كوكسيل 40 A 0 0 coaxial-cable-ar 166/328/543 none
595 566 372/566/595 Air Conditioners (AC) 40 A 0 0 air-conditioners-ac-ar 372/566 none
592 572 372/572/592 Cooking Ranges 40 A 0 0 cooking-ranges-ar 372/572 none
483 378 166/378/483 Dviced 40 A 0 0 dviced-ar 166/378 none
469 320 166/320/469 Huawei Pads 40 A 0 0 huawei-pads-ar 166/320 none
471 322 166/322/471 Huawei Watches 40 A 0 0 huawei-watches-ar 166/322 none
505 170 166/170/505 Lenovo 40 A 0 0 lenovo-ar 166/170 none
354 167 166/167/354 Lenovo 40 A 0 0 lenovo-ar 166/167 none
559 234 166/234/559 Motorola 40 A 0 0 motorola-ar-2 166/234 none
526 170 166/170/526 Samsung 40 A 0 0 samsung-ar 166/170 none
369 203 203/369 Scooter 40 A 0 0 scooter-ar 203 none
633 629 577/629/633 أقنعة الوجه 40 A 0 0 face-masks-ar 577/629 none
359 328 166/328/359 أكسس بوينت 40 A 0 0 access-point-ar 166/328 none
407 402 250/402/407 أكسس بوينت 40 A 0 0 access-point-ar 250/402 none
627 621 577/621/627 العطور المتخصصة 40 A 0 0 niche-fragrances-ar 577/621 none
487 453 372/453/487 بروجكترات 40 A 0 0 projectors-ar 372/453 none
486 174 166/174/486 بروجكترات 40 A 0 0 projectors-ar 166/174 none
320 166 166/320 تابلتات 40 A 0 0 tablets-ar 166 none
170 166 166/170 شاشات كمبيوتر 40 A 0 0 monitors-ar 166 none
620 616 577/616/620 شفه 40 A 0 0 lips-ar 577/616 none
397 371 250/371/397 طابعة الباركود 40 A 0 0 barcode-printers 250/371 none
575 466 372/466/575 غلاية 40 A 0 0 kettle-ar 372/466 none
545 521 521/545 كابلات الشبكة 40 A 0 0 network-cables-ar 521 none
496 219 219/496 كتب الروائية 40 A 0 0 fiction-books-ar 219 none
426 424 166/423/424/426 محولات 40 A 0 0 adapters-ar 166/423/424 none
250 0 250 مستلزمات الشركات 40 A 0 0 office-supplies-ar none
428 458 250/458/428 منظمات المكتب 40 A 0 0 desk-and-workspace-organizer 250/458 none
517 513 166/513/517 ميموري كاردز 40 A 0 0 memory-cards-ar 166/513 none
174 166 166/174 تلفاز وسينما 50 A 0 0 tv-and-theatre 166 none
322 166 166/322 ساعات ذكية 50 A 0 0 smart-watches 166 none
364 328 166/328/364 (فايروال) جدار حماية 50 A 0 0 firewall-ar 166/328 none
408 402 250/402/408 (فايروال) جدار حماية 50 A 0 0 firewall-ar 250/402 none
596 566 372/566/596 Air Coolers 50 A 0 0 air-coolers-ar 372/566 none
355 167 166/167/355 Asus 50 A 0 0 asus-ar 166/167 none
490 378 166/378/490 Belkin 50 A 0 0 belkin-ar 166/378 none
528 170 166/170/528 Dell 50 A 0 0 dell-ar 166/170 none
614 320 166/320/614 Honor Pad 50 A 0 0 honor-pad-ar 166/320 none
470 234 166/234/470 Huawei 50 A 0 0 huawei-ar 166/234 none
567 543 166/328/543/567 POE Adapters 50 A 0 0 poe-adapters-ar 166/328/543 none
599 572 372/572/599 Range Hoods 50 A 0 0 range-hoods-ar 372/572 none
572 372 372/572 أجهزة المطبخ الرئيسية 50 A 0 0 major-kitchen-appliances-ar 372 none
624 621 577/621/624 أطفال 50 A 0 0 kids-ar 577/621 none
626 621 577/621/626 الشموع 50 A 0 0 candles-ar 577/621 none
576 466 372/466/576 القلي العميق 50 A 0 0 deep-fryers-ar 372/466 none
488 458 250/458/488 دباسات 50 A 0 0 stapler-ar 250/458 none
399 329 166/329/399 سماعات الهيدست 50 A 0 0 headsets-ar 166/329 none
398 371 250/371/398 طابعة الملصقات 50 A 0 0 label-printers-ar 250/371 none
518 513 166/513/518 كارد ريدرز 50 A 0 0 card-readers-ar 166/513 none
219 0 219 كتب 50 A 0 0 books-ar none
497 219 219/497 كتب غير روائية 50 A 0 0 non-fiction-books-ar 219 none
446 351 166/351/446 مقابس وحافظات كهربائية 50 A 0 0 sockets-and-wall-plugs-ar 166/351 none
634 629 577/629/634 واقيات الشمس 50 A 0 0 sunscreens-ar 577/629 none
506 378 166/378/506 Baykron 60 A 0 0 baykron-ar 166/378 none
654 572 372/572/654 Freezers 60 A 0 0 freezers-ar 372/572 none
597 566 372/566/597 Heaters 60 A 0 0 heaters-ar 372/566 none
444 167 166/167/444 Microsoft 60 A 0 0 microsoft-ar 166/167 none
466 372 372/466 أجهزة المطبخ 60 A 0 0 kitchen-appliances-ar 372 none
473 577 577/473 العناية بالشعر 60 A 0 0 hair-care-ar 577 none
579 466 372/466/579 الميكروويف والفرن 60 A 0 0 microwave-and-ovens-ar 372/466 none
457 329 166/329/457 سماعات 60 A 0 0 headphone-ar 166/329 none
648 351 166/351/648 شاحن سيارة كهربائية 60 A 0 0 ev-car-chargers-ar 166/351 none
498 219 219/498 كتب الفلسفة 60 A 0 0 philosophy-books-ar 219 none
491 458 250/458/491 مزيل دبابيس 60 A 0 0 staple-remover-ar 250/458 none
395 371 250/371/395 مستلزمات الطباعة 60 A 0 0 printer-supplies-ar 250/371 none
328 166 166/328 معدات الشبكات 60 A 0 0 network-ar 166 none
448 423 166/423/448 واقيات الشاشة 60 A 0 0 screen-protectors-ar 166/423 none
366 328 166/328/366 وحدة تحكم الوصول اللاسلكي (WAC) 60 A 0 0 wireless-access-controller-wac 166/328 none
409 402 250/402/409 وحدة تحكم الوصول اللاسلكي (WAC) 60 A 0 0 wireless-access-controller-wac-ar 250/402 none
525 167 166/167/525 acer 65 A 0 0 acer-ar 166/167 none
530 170 166/170/530 HP 70 A 0 0 hp-ar 166/170 none
532 167 166/167/532 MSI 70 A 0 0 msi 166/167 none
615 371 250/371/615 Thermal Printer 70 A 0 0 thermal-printer-ar 250/371 none
449 423 166/423/449 أغطية وحافظات 70 A 0 0 cases-and-covers-ar 166/423 none
477 423 166/423/477 أقلام لمس 70 A 0 0 stylus-pens-ar 166/423 none
578 577 577/578 تريمرز 70 A 0 0 trimmers-ar 577 none
636 629 577/629/636 علاجات الشفاه 70 A 0 0 lip-treatments-ar 577/629 none
580 466 372/466/580 غلايات البيض 70 A 0 0 egg-boiler-ar 372/466 none
499 219 219/499 كتب سياسية 70 A 0 0 political-books-ar 219 none
347 329 166/329/347 مكبرات 70 A 0 0 speakers-ar 166/329 none
329 166 166/329 مكبرات وسماعات 70 A 0 0 headphone-and-speakers-ar 166 none
438 328 166/328/438 موسع نطاق 70 A 0 0 range-extender-ar 166/328 none
439 402 250/402/439 موسع نطاق 70 A 0 0 range-extender-ar 250/402 none
519 167 166/167/519 All in One 80 A 0 0 all-in-one-ar 166/167 none
531 170 166/170/531 MSI 80 A 0 0 msi-ar 166/170 none
482 402 250/402/482 آلة لحام الألياف الضوئية 80 A 0 0 fiber-splicing-machine-ar 250/402 none
481 328 166/328/481 آلة لحام الألياف الضوئية 80 A 0 0 fiber-splicing-machine-ar 166/328 none
637 629 577/629/637 العلاجات 80 A 0 0 treatments-ar 577/629 none
552 372 372/552 القهوة والمشروبات 80 A 0 0 coffee-ar 372 none
581 466 372/466/581 ثلاجات صغيرة 80 A 0 0 mini-refrigerator-ar 372/466 none
500 219 219/500 كتب الإثارة 80 A 0 0 thriller-books-ar 219 none
616 577 577/616 ماكياج 80 A 0 0 make-up-ar 577 none
308 250 250/308 ماوس وكيبورد 80 A 0 0 mouse-and-keyboard-ar 250 none
655 466 372/466/655 Ice Maker 90 A 0 0 ice-maker-ar 372/466 none
566 372 372/566 التبريد والتدفئة 90 A 0 0 coolers-and-heaters-ar 372 none
492 424 166/423/424/492 الشحن اللاسلكي والحوامل 90 A 0 0 wireless-charging-and-stands-ar 166/423/424 none
621 577 577/621 العطور 90 A 0 0 perfume-ar 577 none
638 629 577/629/638 العناية ببشرة الرجال 90 A 0 0 mens-skincare-ar 577/629 none
565 402 250/402/565 رابط لاسلكي مخصص 90 A 0 0 point-to-point-ar 250/402 none
587 372 372/587 آيرونينغ 100 A 0 0 ironing-ar 372 none
629 577 577/629 العناية بالبشرة 100 A 0 0 skin-care-ar 577 none
521 0 521 المراقبة والتحكم بالدخول 100 A 0 0 cctv-and-access-control-ar none
520 423 166/423/520 كاميرا ويب 100 A 0 0 webcam-camera-ar 166/423 none
502 219 219/502 كتب رومانسية 100 A 0 0 romance-books-ar 219 none
464 461 372/461/464 ملحقات وفلترات 100 A 0 0 accessories-and-filters-ar 372/461 none
639 577 577/639 العناية بالجسم 110 A 0 0 body-care-ar 577 none
503 219 219/503 كتب المساعدة الذاتية 110 A 0 0 self-help-books-ar 219 none
350 166 166/350 ماوس وكيبورد 110 A 0 0 mouse-and-keyboard-ar 166 none
380 250 250/380 مستلزمات غرفة الاجتماعات 110 A 0 0 meeting-room-essentials-ar 250 none
228 0 228 ميوزيك إنسترومنتس 110 A 0 0 music-instruments-ar none
585 423 166/423/585 واتش باندز 110 A 0 0 watch-bands-ar 166/423 none
351 166 166/351 وحدات الطاقة 120 A 0 0 ups-and-power-units 166 none
537 522 521/522/537 PTZ 120 A 0 0 ptz-ar 521/522 none
650 577 577/650 الأظافر 120 A 0 0 nails-ar 577 none
558 0 558 الألعاب 120 A 0 0 games-and-toys-ar none
586 423 166/423/586 تراكيرز 120 A 0 0 trackers-ar 166/423 none
640 639 577/639/640 رذاذ الجسم 120 A 0 0 body-mists-ar 577/639 none
523 399 166/329/399/523 سماعات المكتب 120 A 0 0 office-headsets-ar 166/329/399 none
400 250 250/400 سماعات الهيدست 120 A 0 0 headsets-ar 250 none
524 399 166/329/399/524 سماعات جيمينغ 120 A 0 0 gaming-headsets-ar 166/329/399 none
543 328 166/328/543 كابلات الشبكة 120 A 0 0 network-cable-ar 166/328 none
504 219 219/504 كتب العلوم 120 A 0 0 science-books-ar 219 none
657 423 166/423/657 Car Phone Holders 130 A 0 0 car-phone-holders-ar 166/423 none
662 577 577/662 Dental Care 130 A 0 0 dental-care-ar 577 none
401 250 250/401 UPS 130 A 0 0 ups-ar 250 none
577 0 577 الجمال والعناية الشخصية 130 A 0 0 beauty-and-self-care-ar none
378 166 166/378 باور بانك 130 A 0 0 power-banks-ar 166 none
564 328 166/328/564 رابط لاسلكي مخصص 130 A 0 0 point-to-point-ar 166/328 none
641 639 577/639/641 غسول الجسم 130 A 0 0 body-washes-ar 577/639 none
507 219 219/507 كتب مانغا 130 A 0 0 mangas-ar 219 none
513 166 166/513 التخزين الخارجي 140 A 0 0 external-storage-ar 166 none
658 0 658 حقيبة 140 A 0 0 bags-ar none
642 639 577/639/642 مرطبات الجسم 140 A 0 0 body-moisturizers-ar 577/639 none
402 250 250/402 معدات الشبكات 140 A 0 0 network-ar 250 none
423 166 166/423 إكسسوارات 150 A 0 0 accessories-ar 166 none
661 0 661 ساعات مادية 150 A 0 0 physical-watches-ar none
458 250 250/458 قرطاسية 150 A 0 0 stationary-ar 250 none
643 639 577/639/643 مزيلات العرق 150 A 0 0 deodorants-ar 577/639 none
553 250 250/553 معدات القهوة 160 A 0 0 coffee-ar 250 none
644 639 577/639/644 مقشرات ومنتجات تقشير البشرة 160 A 0 0 scrubs-and-exfoliants-ar 577/639 none
600 166 166/600 مكونات الكمبيوتر 160 A 0 0 pc-compnents-ar 166 none
664 0 664 نظارات 160 A 0 0 glasses-ar none
645 639 577/639/645 الإسفنج والأدوات 170 A 0 0 sponges-and-tools-ar 577/639 none
646 639 577/639/646 العلاجات 180 A 0 0 treatments-ar 577/639 none
647 639 577/639/647 العناية بالجسم للرجال 190 A 0 0 mens-body-care-ar 577/639 none