0 0 0 1 2 3
0 0 0 4 5 6
0 0 0 7 8 9
0 10

1 2 3
4 5 6
7 8 9
10

import sys
import tkinter as tk
from tkinter import ttk
from tkinter import messagebox


class Panel(ttk.Frame):
    """Clase genérica para mostrar un Frame con un cierto título y
    tamaño dados, centrado en la pantalla"""

    def __init__(self, master, titulo="Sin título", ancho=360, alto=180):
        super().__init__()
        self.master: tk.Tk = master
        self.siguiente = (
            lambda: None
        )  # Valor por defecto no útil. El programa principal debe asignar otro
        self.titulo = titulo

SELECT dev.id,dev.name,dev.uniqueid
FROM `tc_devices` dev
WHERE length(dev.uniqueid) = 10 AND dev.id = 34
ORDER BY dev.id ASC

SELECT *
FROM `tc_positions`
WHERE deviceid = 34
    AND servertime NOT BETWEEN DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 10 DAY), '%Y-%m-%d') AND CURDATE()

SELECT *
FROM tc_devices dev
INNER JOIN tc_positions pos ON dev.id = pos.deviceid
WHERE LENGTH(dev.uniqueid) = 10
	AND pos.servertime NOT BETWEEN DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 10 DAY),'%Y-%m-%d')
    AND CURDATE()

SELECT *
FROM tc_devices dev
INNER JOIN tc_positions pos ON dev.id = pos.deviceid
WHERE dev.id = 34
	AND LENGTH(dev.uniqueid) = 10
	AND pos.servertime NOT BETWEEN DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 10 DAY),'%Y-%m-%d')
    AND CURDATE()

DELETE FROM tc_positions pos
INNER JOIN tc_devices dev ON pos.deviceid = dev.id
WHERE dev.id = 34
	AND LENGTH(dev.uniqueid) = 10
	AND pos.servertime NOT BETWEEN DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 10 DAY),'%Y-%m-%d')
    AND CURDATE()

DELETE FROM tc_positions pos
WHERE pos.deviceid  IN (select id from tc_devices where LENGTH(dev.uniqueid) = 10)
	AND pos.servertime NOT BETWEEN DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 10 DAY),'%Y-%m-%d')
    AND CURDATE()

DELETE FROM tc_positions pos
WHERE pos.deviceid  IN (select id from tc_devices where LENGTH(dev.uniqueid) = 10)
	AND pos.servertime < DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 10 DAY),'%Y-%m-%d')

#1064 - Algo está equivocado en su sintax cerca 'pos
WHERE pos.deviceid IN (SELECT id FROM tc_devices dev WHERE dev.id = 34 AND ' en la linea 8

DELETE FROM tc_positions pos
WHERE pos.deviceid IN (SELECT id FROM tc_devices dev WHERE LENGTH(dev.uniqueid) = 10)
	AND pos.servertime < DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 10 DAY),'%Y-%m-%d')

// save data value

localStorage.setItem("name", "John");

// retrieve data value

var name = localStorage.getItem("name");