SELECT tsc.Id, min(spc.sDate)
FROM TEST.`Services` tsc,
(
    select /*+ SUBQUERY(MATERIALIZATION) */ ss.SERVICE_ID , spp.plan_id, spp.ChangesStartTime, spp.changeDate
    from (
        select sp.ChangesStartTime, sp.changeDate, -1 as plan_id, sp.ServiceCode
            from DICT.Price sp
            where sp.PriceChangeId > ?
            and sp.PlanCode = ''
        union
        select sp.ChangesStartTime, sp.changeDate, tp.plan_id as plan_id, sp.ServiceCode
            from DICT.Price sp
            join DICT.Plan btp on btp.CODE = sp.PlanCode
            join DICT.Plan tp on tp.BASIC_PLAN_ID = btp.PLAN_ID
            where sp.PriceChangeId > ?
            and sp.PlanCode != ''
            and sp.BaseTariffPlan = 1
        union
        select sp.ChangesStartTime, sp.changeDate, tp.plan_id as plan_id, sp.ServiceCode
            from DICT.Price sp
            join DICT.Plan tp on tp.CODE = sp.PlanCode
            where sp.PriceChangeId > ?
            and sp.PlanCode != ''
        ) spp
    join DICT.Service_f ss on ss.SERVICE_CODE = spp.ServiceCode
) spc
where tsc.serviceId = spc.service_id
and tsc.plnId = if(spc.plan_id = -1, tsc.plnId, spc.plan_id)
and tsc.serviceDateFrom > GREATEST(spc.ChangesStartTime, spc.changeDate)
group by tsc.Id;

Lock wait timeout exceeded; try restarting transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback;

CREATE INDEX PriceChangeId ON DICT.Price (PriceChangeId) USING BTREE;

select * from DICT.Price sp where sp.PriceChangeId > 53000 ;