{
  "query": "SELECT id, title, address, photoUrl, createdAt FROM jobPins ORDER BY title, createdAt;",
  "command": "mysql --batch --raw --column-names --default-character-set=utf8mb4 --host gateway02.us-east-1.prod.aws.tidbcloud.com --port 4000 --user 2rByp4xzgEkuDbw.cceb60ce5c35 --database PjmhyWX59sLWBPx3zx6jpM --execute SELECT id, title, address, photoUrl, createdAt FROM jobPins ORDER BY title, createdAt;",
  "rows": [
    {
      "id": "60017",
      "title": "Bathtub Installation",
      "address": "4805 1st Pl, Lubbock, TX 79416",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/8tv0d0y1c5t.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60013",
      "title": "Bathtub Installation",
      "address": "4805 1st",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/j2k6xeteqn.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60012",
      "title": "Bathtub Installation",
      "address": "10812 Homestead ave",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/fw6rufksn6.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60018",
      "title": "Bathtub Installation",
      "address": "10812 Homestead Avenue, Lubbock, TX 79424",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/jjrcg4wmdmh.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60006",
      "title": "Hose Bib Replacement",
      "address": "5707 Ave Q South Drive",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/kjlghtyinaq.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60014",
      "title": "P-Trap Replacement",
      "address": "5301 County Road 7675",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/s8rvujb5u2.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "30004",
      "title": "Pending Job",
      "address": "789 Pending St, Lubbock, TX 79401",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/PjmhyWX59sLWBPx3zx6jpM/job-pins/1-1765210361516.jpg",
      "createdAt": "2025-12-08 16:12:41"
    },
    {
      "id": "60003",
      "title": "Sewer Line Repair",
      "address": "513 32nd Street Lubbock, TX 79404",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/4dp4dwa9mgu.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60002",
      "title": "Sewer Line Replacement",
      "address": "4614 30th Street Lubbock, TX 79410",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/q6pttolz5y.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60023",
      "title": "Tankless Water Heater for Pool House",
      "address": "7712 La Salle Avenue, Lubbock, TX 79424",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/t9rizvn3hwp.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60011",
      "title": "Tankless Water Heater in Fountain Hills",
      "address": "10812 Homestead ave",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/ywrfqww8wd.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60022",
      "title": "Tankless Water Heater Installation",
      "address": "3710 134th Street, Lubbock, TX 79423",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/cx6h2er2abr.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60008",
      "title": "Tankless Water Heater Installation (Navien)",
      "address": "3710 134th St",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/ajn2f131lep.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60007",
      "title": "Tankless Water Heater Installation (Noritz)",
      "address": "7712 la sa",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/hjou61rihfc.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "1",
      "title": "Test Water Heater Installation",
      "address": "123 Test St, Lubbock, TX 79401",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/PjmhyWX59sLWBPx3zx6jpM/job-pins/1-1765209304179.jpg",
      "createdAt": "2025-12-08 15:55:04"
    },
    {
      "id": "30003",
      "title": "Test Water Heater Installation",
      "address": "123 Test St, Lubbock, TX 79401",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/PjmhyWX59sLWBPx3zx6jpM/job-pins/1-1765210361201.jpg",
      "createdAt": "2025-12-08 16:12:41"
    },
    {
      "id": "60015",
      "title": "Water Conditioner Installation",
      "address": "7025 99",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/tps6yo25qs7.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60005",
      "title": "Water Heater Installation",
      "address": "4302 42nd Street Lubbock, TX 79413",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/9azsqpso6xf.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60004",
      "title": "Water Heater Installation",
      "address": "2516 Kent Street Lubbock, TX 79415",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/kfiltedx19q.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60016",
      "title": "Water Heater Installation (Rheem)",
      "address": "7025 99th",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/sx46zcofrnl.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60021",
      "title": "Water Heater Installation at Mulligan's",
      "address": "4505 Milwaukee Avenue, Lubbock, TX 79407",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/120wszc3p5bf.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60009",
      "title": "Water Heater Installation at Mulligan's Golf Bar",
      "address": "4505 milwaukee",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/1scqpsuhrdc.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60019",
      "title": "Water Heater Installation in Fountain Hills",
      "address": "10812 Homestead Avenue, Lubbock, TX 79424",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/cg0x0ztqxyb.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60010",
      "title": "Water Heater Installation in Levelland",
      "address": "1101 Poplar Street Leve",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/bl7e3jiyrof.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60020",
      "title": "Water Heater Installation in Levelland",
      "address": "1101 Poplar Street Levelland, TX 79336",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/qg24xfjo6q.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    },
    {
      "id": "60001",
      "title": "Water Line Repair",
      "address": "7027 Quaker Avenue Lubbock, TX 79424",
      "photoUrl": "https://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/id5in4ltel9.jpeg",
      "createdAt": "2025-12-08 17:08:14"
    }
  ],
  "messages": [],
  "stdout": "id\ttitle\taddress\tphotoUrl\tcreatedAt\n60017\tBathtub Installation\t4805 1st Pl, Lubbock, TX 79416\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/8tv0d0y1c5t.jpeg\t2025-12-08 17:08:14\n60013\tBathtub Installation\t4805 1st\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/j2k6xeteqn.jpeg\t2025-12-08 17:08:14\n60012\tBathtub Installation\t10812 Homestead ave\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/fw6rufksn6.jpeg\t2025-12-08 17:08:14\n60018\tBathtub Installation\t10812 Homestead Avenue, Lubbock, TX 79424\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/jjrcg4wmdmh.jpeg\t2025-12-08 17:08:14\n60006\tHose Bib Replacement\t5707 Ave Q South Drive\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/kjlghtyinaq.jpeg\t2025-12-08 17:08:14\n60014\tP-Trap Replacement\t5301 County Road 7675\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/s8rvujb5u2.jpeg\t2025-12-08 17:08:14\n30004\tPending Job\t789 Pending St, Lubbock, TX 79401\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/PjmhyWX59sLWBPx3zx6jpM/job-pins/1-1765210361516.jpg\t2025-12-08 16:12:41\n60003\tSewer Line Repair\t513 32nd Street Lubbock, TX 79404\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/4dp4dwa9mgu.jpeg\t2025-12-08 17:08:14\n60002\tSewer Line Replacement\t4614 30th Street Lubbock, TX 79410\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/q6pttolz5y.jpeg\t2025-12-08 17:08:14\n60023\tTankless Water Heater for Pool House\t7712 La Salle Avenue, Lubbock, TX 79424\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/t9rizvn3hwp.jpeg\t2025-12-08 17:08:14\n60011\tTankless Water Heater in Fountain Hills\t10812 Homestead ave\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/ywrfqww8wd.jpeg\t2025-12-08 17:08:14\n60022\tTankless Water Heater Installation\t3710 134th Street, Lubbock, TX 79423\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/cx6h2er2abr.jpeg\t2025-12-08 17:08:14\n60008\tTankless Water Heater Installation (Navien)\t3710 134th St\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/ajn2f131lep.jpeg\t2025-12-08 17:08:14\n60007\tTankless Water Heater Installation (Noritz)\t7712 la sa\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/hjou61rihfc.jpeg\t2025-12-08 17:08:14\n1\tTest Water Heater Installation\t123 Test St, Lubbock, TX 79401\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/PjmhyWX59sLWBPx3zx6jpM/job-pins/1-1765209304179.jpg\t2025-12-08 15:55:04\n30003\tTest Water Heater Installation\t123 Test St, Lubbock, TX 79401\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/PjmhyWX59sLWBPx3zx6jpM/job-pins/1-1765210361201.jpg\t2025-12-08 16:12:41\n60015\tWater Conditioner Installation\t7025 99\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/tps6yo25qs7.jpeg\t2025-12-08 17:08:14\n60005\tWater Heater Installation\t4302 42nd Street Lubbock, TX 79413\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/9azsqpso6xf.jpeg\t2025-12-08 17:08:14\n60004\tWater Heater Installation\t2516 Kent Street Lubbock, TX 79415\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/kfiltedx19q.jpeg\t2025-12-08 17:08:14\n60016\tWater Heater Installation (Rheem)\t7025 99th\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/sx46zcofrnl.jpeg\t2025-12-08 17:08:14\n60021\tWater Heater Installation at Mulligan's\t4505 Milwaukee Avenue, Lubbock, TX 79407\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/120wszc3p5bf.jpeg\t2025-12-08 17:08:14\n60009\tWater Heater Installation at Mulligan's Golf Bar\t4505 milwaukee\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/1scqpsuhrdc.jpeg\t2025-12-08 17:08:14\n60019\tWater Heater Installation in Fountain Hills\t10812 Homestead Avenue, Lubbock, TX 79424\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/cg0x0ztqxyb.jpeg\t2025-12-08 17:08:14\n60010\tWater Heater Installation in Levelland\t1101 Poplar Street Leve\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/bl7e3jiyrof.jpeg\t2025-12-08 17:08:14\n60020\tWater Heater Installation in Levelland\t1101 Poplar Street Levelland, TX 79336\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/1/qg24xfjo6q.jpeg\t2025-12-08 17:08:14\n60001\tWater Line Repair\t7027 Quaker Avenue Lubbock, TX 79424\thttps://d2xsxph8kpxj0f.cloudfront.net/310519663093425184/3RqvaFPpvksurqc96Eprzn/data-pins/720013/id5in4ltel9.jpeg\t2025-12-08 17:08:14\n",
  "stderr": "",
  "execution_time_ms": 55
}