SELECT
node.title AS node_title,
node.nid AS nid,
node.created AS node_created
FROM
{node} node
WHERE
(( (node.status = '1') AND (node.type IN ('article')) ))
ORDER BY
node_created DESC
LIMIT 10 OFFSET 0
will be useful when making a [BaaS](https://en.wikipedia.org/wiki/Mobile_backend_as_a_service) like:
* https://backendless.com/platform/backend-as-a-service/
* https://www.devart.com/dbforge/oracle/studio/