CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- $psql1 = "SELECT *
- FROM node
- LEFT OUTER JOIN field_data_title ON node.nid = field_data_title.nid
- LEFT OUTER JOIN field_data_category ON node.nid = field_data_category.nid
- LEFT OUTER JOIN field_data_body ON node.nid = field_data_body.nid
- LEFT OUTER JOIN field_data_video ON node.nid = field_data_video.nid
- WHERE node.type='1'
- ORDER BY node.nid DESC";