select * from ((select agatti_lists.id, agatti_lists.u_name, agatti_lists.cat_table,agatti_lists.items, agatti_lists.name,agatti_visiters.username from agatti_lists, agatti_visiters where agatti_lists.active <> 0 and agatti_lists.id in (select agatti_list_features.list_id from agatti_list_features where agatti_list_features.active=1 and object_id=28 and object_type="p" group by agatti_list_features.list_id)) UNION (select agatti_lists.id, agatti_lists.u_name, agatti_lists.cat_table,agatti_lists.items, agatti_lists.name,agatti_visiters.username from agatti_lists, agatti_visiters where concat(",", agatti_lists.items, ",") like "%,28,%" and (cat_table="agatti_people" or cat_table="agatti_cast") and agatti_lists.active<>0 and agatti_visiters.confirmed=1 and agatti_visiters.id=agatti_lists.user_id and agatti_lists.active <> 0 order by agatti_lists.date_created desc)) as lol group by lol.id limit 0, 24
