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

Query time 0.00052

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 = 1481"
        }
      }
    }
  }
}

Result

image_id page_id position title src link_url product_id category_id
985 1481 0 The Originalâ„¢ LED Gooseneck Light 1.jpg /led-lighting/wall-lights/gooseneck-lights/the-original-led-warehouse-gooseneck-light/ 64852 0
984 1481 2 Downtown Minimalist Cord Pendant Light 2.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/downtown-minimalist-cord-pendant/ 61937 0
983 1481 4 Sinclair Swing Arm Wall Sconce 3.jpg /lighting/wall-lights/swing-arm-sconces/sinclair-swing-arm-sconce/ 64274 0
982 1481 6 Alto Wooden Cylinder Cord Pendant Light 4.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/alto-wooden-cylinder-pendant-light/ 65548 0
981 1481 8 Kao Drum Schoolhouse Flush Mount Light 5.jpg /drum-schoolhouse-collection-drm/kao-drum-schoolhouse-flush-mount-light/ 65532 0
980 1481 10 Bubble Stem Pendant Light 6.jpg /lighting/ceiling-lights/stem-mount-pendant-lighting/bubble-stem-mount-pendant/ 64352 0
979 1481 12 The Originalâ„¢ LED Stem Pendant Light 7.jpg /led-lighting/ceiling-lights/stem-mount-pendant-lighting/the-original-led-stem-mount-pendant-light/ 64917 0
978 1481 14 Streamline Industrial Guard Wall Sconce 8.jpg /lighting/wall-lights/wall-sconces/streamline-industrial-guard-sconce/ 61390 0
977 1481 16 Aero Gooseneck Light 9.jpg /lighting/wall-lights/gooseneck-lights/aero-gooseneck-light/ 64734 0
976 1481 18 Downtown Minimalist Double Wall Sconce 10.jpg /lighting/wall-lights/wall-sconces/downtown-minimalist-double-sconce/ 63510 0
975 1481 20 Marathon Cord Pendant Light 11.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/marathon-pendant-light/ 64764 0
974 1481 22 Kao Wall Sconce 12.jpg /lighting/wall-lights/wall-sconces/kao-wall-sconce/ 62975 0
973 1481 24 Primary 3-Light Schoolhouse Vanity Light 13.jpg /lighting/wall-lights/vanity-lights/primary-3-light-schoolhouse-vanity-light/ 61621 0
972 1481 26 The Originalâ„¢ Single Post Mount Light 14.jpg /lighting/outdoor-lights/post-mount-lights/the-original-single-post-mount-light/ 64078 0
971 1481 28 Austin Wall Sconce 15.jpg /lighting/wall-lights/wall-sconces/austin-wall-sconce/ 60906 0
970 1481 30 Bubble Stem Pendant Light 16.jpg /lighting/ceiling-lights/stem-mount-pendant-lighting/bubble-stem-mount-pendant/ 64352 0
969 1481 32 Sterling LED Gooseneck Light 17.jpg /led-lighting/outdoor-lights/wall-mounted-lights/sterling-led-gooseneck-light/ 64994 0
968 1481 34 Canal Cord Pendant Light 18.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/canal-pendant-light/ 61684 0