SELECT o0_.id                AS id_0,
       o0_.entity            AS entity_1,
       o0_.create_date       AS create_date_2,
       Max(o1_.publish_date) AS sclr_3
FROM   object o0_
       INNER JOIN object__share o1_
               ON ( o1_.object_related_id = o0_.id
                    AND o1_.deleted = 0 )
        JOIN (
            SELECT
                __u.id
            FROM
                user __u
            JOIN
                object__like __ob
            ON
                __ob.object_related_id = __u.object_id
            WHERE
                __ob.user_id = 2
            UNION
                SELECT 2 as _id

        ) _f
        ON
            _f.id = o1_.user_id

       LEFT JOIN post p4_
              ON ( p4_.object_id = o0_.id
                   AND
       o0_.entity = 'Tattool\\Bundle\\ZZZBundle\\Entity\\Post'
                   AND p4_.deleted = 0 )
       LEFT JOIN booking b5_
              ON ( b5_.object_id = o0_.id
                   AND
       o0_.entity = 'XXX\\Bundle\\BookingBundle\\Entity\\Booking'
                   AND b5_.deleted = 0 )
WHERE

        o0_.entity IN (
               'Tattool\\Bundle\\TatlineBundle\\Entity\\Post',
                             'Tattool\\Bundle\\BookingBundle\\Entity\\Booking' )
       AND o1_.publish_date < '2016-06-30 23:14:20'
       AND ( p4_.deleted = 0
              OR b5_.deleted = 0 )
       AND Coalesce(p4_.user_id, b5_.user_id) NOT IN ( 0 )
GROUP  BY o0_.id
ORDER  BY sclr_3 DESC
LIMIT  100 offset 0;