Problemas con sentencia ORDER BY + UNION

[Libras]

creo que tu error va de que no se pueden ordernar los datos de los queries que forman parte de una sentencia union, prueba con esto:

Código MySQL:

INSERT INTO email_queues (queueid, queuetype, ownerid, recipient, processed) 
 
select * from(
    SELECT DISTINCT 13, 'send', 1, subscribers.subscriberid, 0 
    FROM email_list_subscribers AS subscribers 
    JOIN email_lists AS lists ON lists.listid = subscribers.listid AND lists.listid IN (1) 
        WHERE subscribers.listid IN (1) 
            AND (    
                    (
                        subscribers.subscriberid IN (
                                                        SELECT d.subscriberid AS subscriberid 
                                                        FROM email_subscribers_data d 
                                                        WHERE d.fieldid = 15 AND d.DATA < 51
                                                    ) 
                    ) 
                ) 
            AND (subscribers.unsubscribed=0 AND subscribers.bounced=0)
    
    UNION 
 
    SELECT DISTINCT 13, 'send', 1, subscribers.subscriberid, 0 
    FROM email_list_subscribers AS subscribers 
    JOIN email_lists AS lists ON lists.listid = subscribers.listid AND lists.listid IN (1) 
        WHERE subscribers.listid IN (1) 
            AND (
                    (
                        subscribers.subscriberid IN (
                                                        SELECT d.subscriberid AS subscriberid 
                                                        FROM email_subscribers_data d 
                                                        WHERE d.fieldid = 16 AND d.DATA < 4
                                                    )
                    ) 
                )
            AND (subscribers.unsubscribed=0 AND subscribers.bounced=0)
    ) as subconsulta
    ORDER BY subscribedate ASC 
    LIMIT 1000000000