import sys
import pymysql.cursors
from datetime import timezone

entity_id = sys.argv[1]

mysql_host = '192.168.1.200'
mysql_user = 'hass'
mysql_pass = 'MySuperAwesomePassword'
mysql_db   = 'hassio_db'

def utc_to_local(utc_dt):
    return utc_dt.replace(tzinfo=timezone.utc).astimezone(tz=None)

db = pymysql.connect (host=mysql_host, user=mysql_user, passwd=mysql_pass, db=m$
cursor = db.cursor(pymysql.cursors.DictCursor)

sql = """SELECT state,last_changed FROM states WHERE entity_id = '%s'
         ORDER BY created DESC LIMIT 100""" % (entity_id)

cursor.execute(sql)
result = cursor.fetchall()
db.close()

for idx, row in enumerate(result):
    state_act = row['state']
    date_act = row['last_changed']
    if idx == 0:
        state_last = state_act
        date_last = date_act
    if state_last != state_act:
        real_last_changed = date_last
        break
    else:
        state_last = state_act
        date_last = date_act

print(utc_to_local(real_last_changed).strftime('%Y-%m-%d %H:%M:%S'))