select X
FROM ulud_usage_data AS data
         INNER JOIN uluh_usage_header AS header ON data.ulud_headerid = header.uluh_id
         INNER JOIN (SELECT DISTINCT (ulud_u_advertiserid) AS advertiser_id
                     FROM ulud_usage_data d
                              inner join uluh_usage_header h on d.ulud_headerid = h.uluh_id
                     WHERE ulud_id > "X"
                       and h.uluh_status = 0
                     LIMIT 0,1) AS uudai on uudai.advertiser_id = data.ulud_u_advertiserid