Query not working

i want to execute this queries…
image
After that
i use one more execute query…
“insert into wa_ranking_all (key_id, product_name, product_id, date_time, date_of_rank, time, rank, page)
SELECT key_id, product_name, product_id, date_time, date_of_rank,
tm,rnk,page
FROM
(SELECT key_id, product_name, product_id, date_time, date_of_rank,
replace(time,‘:’,‘’) as tm,page,
@rnk := IF(@current_key = key_id, @rnk + 1, 1) AS rnk,
@current_key := key_id
FROM wa_temp_ranking_all
ORDER BY key_id
) ranked
WHERE rnk <= 100 and product_id in (‘XXXXXXXXX’,‘XXXXXYYYY’);”

if i run the above two query on by one in mysql 5.6 it working fine. but in ui path it runs but does not got the appropriate result.
how can i solve it?