Форум пользователей MySQL

SELECT SQL_CALC_FOUND_ROWS o.id AS id, o.name AS name, o.type_id AS type_id, o.is_locked AS is_locked, o.owner_id AS owner_id, o.guid AS guid, t.guid AS type_guid
FROM cms3_object_types t, cms3_objects o
LEFT JOIN cms3_object_content oc_235_lj ON oc_235_lj.obj_id = o.id
AND oc_235_lj.field_id =  '235'
LEFT JOIN cms3_object_content oc_230_lj ON oc_230_lj.obj_id = o.id
AND oc_230_lj.field_id =  '230'
WHERE o.type_id
IN ( 79 )
AND t.id = o.type_id
AND (
oc_230_lj.rel_val IS NOT NULL
)
AND (
o.name !=  'dummy'
OR o.name IS NULL
)
ORDER BY oc_235_lj.int_val DESC
LIMIT 0 , 20