SELECT 
  * 
FROM 
  cscart_ble_content_images 
WHERE 
  page_id = 1479 
ORDER BY 
  position ASC, 
  image_id DESC

Query time 0.00072

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_ble_content_images.position, cscart_ble_content_images.image_id desc",
        "table": {
          "table_name": "cscart_ble_content_images",
          "access_type": "ALL",
          "rows": 1510,
          "filtered": 100,
          "attached_condition": "cscart_ble_content_images.page_id = 1479"
        }
      }
    }
  }
}

Result

image_id page_id position title src link_url product_id category_id
1045 1479 0 Atomic Topless Double Industrial Guard Sconce 1.jpg /lighting/wall-lights/wall-sconces/atomic-topless-double-industrial-guard-sconce/ 61413 0
1044 1479 2 Bantam Wilcox Deep Bowl Wall Sconce 2.jpg /lighting/wall-lights/wall-sconces/bantam-wilcox-deep-bowl-wall-sconce/ 64728 0
1043 1479 4 Fargo Floor Lamp 3.jpg /lighting/lamps/floor-lamps/fargo-floor-lamp/ 63811 0
1042 1479 6 The Original™ Warehouse Cord Pendant Light 4.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/the-original-warehouse-cord-hung-pendant/ 64684 0
1041 1479 8 Laramie Wall Sconce 5.jpg /lighting/wall-lights/wall-sconces/laramie-wall-sconce/ 61411 0
1040 1479 10 Industrial Static Wall Sconce 6.jpg /lighting/wall-lights/wall-sconces/industrial-static-topless-sconce/ 60484 0
1039 1479 12 Amidships Bulkhead Wall Mount Light 7.jpg /lighting/wall-lights/wall-sconces/amidships-bulkhead-wall-mount-light-fixture/ 30012 0
1038 1479 14 Round Schoolhouse Semi-Flush Mount Light 8.jpg /lighting/ceiling-lights/flush-mount-lights/round-schoolhouse-semi-flush-mount-light/ 64875 0
1037 1479 16 Bowie Wall Sconce 9.jpg /lighting/wall-lights/wall-sconces/bowie-wall-sconce/ 64713 0
1036 1479 18 Outback Gooseneck Light 10.jpg /lighting/wall-lights/gooseneck-lights/outback-gooseneck-light/ 60899 0
1035 1479 20 Downtown Minimalist Wooden Socket Swing Arm Sconce 11.jpg /lighting/wall-lights/swing-arm-sconces/downtown-minimalist-wooden-socket-swing-arm-sconce/ 64946 0
1034 1479 22 The Original™ LED Gooseneck Light 12.jpg /led-lighting/wall-lights/gooseneck-lights/the-original-led-warehouse-gooseneck-light/ 64852 0
1033 1479 24 Outback Stem Pendant Light 13.jpg /lighting/ceiling-lights/stem-mount-pendant-lighting/outback-stem-mount-pendant-light/ 62582 0
1032 1479 26 Esso Wall Sconce 14.jpg /lighting/wall-lights/wall-sconces/esso-wall-sconce/ 64754 0
1031 1479 28 Lovell Task Lamp 15.jpg /lighting/lamps/table-lamps/lovell-task-lamp/ 64853 0
1030 1479 30 The Original™ Gooseneck Light 16.jpg /lighting/wall-lights/gooseneck-lights/the-original-gooseneck-light/ 64682 0
1029 1479 32 Double Market Industrial Guard Sconce 17.jpg /lighting/wall-lights/wall-sconces/double-market-industrial-guard-sconce/ 61416 0
1028 1479 34 Union Gooseneck Light 18.jpg /lighting/wall-lights/gooseneck-lights/union-gooseneck-light/ 64695 0
1027 1479 36 Drum Schoolhouse Flush Mount Light 19.jpg /lighting/ceiling-lights/flush-mount-lights/drum-schoolhouse-flush-mount-light/ 64909 0
1026 1479 38 Sterling Cord Pendant Light 20.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/sterling-pendant-light/ 64742 0
1025 1479 40 The Original™ Retro Desk Lamp 21.jpg /lighting/lamps/table-lamps/the-original-retro-desk-lamp/ 62187 0
1024 1479 42 Downtown Minimalist Wooden Socket Swing Arm Sconce 22.jpg /lighting/wall-lights/swing-arm-sconces/downtown-minimalist-wooden-socket-swing-arm-sconce/ 64946 0
1023 1479 44 Bomber Industrial Guard Post Mount Light 23.jpg /lighting/outdoor-lights/post-top-lights/bomber-industrial-guard-post-mount-light/ 61526 0
1022 1479 46 Cherokee Gooseneck Light 24.jpg /lighting/wall-lights/gooseneck-lights/cherokee-uplight-gooseneck-light/ 62274 0