How to call limited data items per page?
$doors_nids = db_select('node', 'n')

-&gt;condition('n.type', 'vivarium_door')

-&gt;fields('n', array('nid'))

-&gt;orderBy('n.title', 'ASC')

-&gt;extend('PagerDefault')-&gt;limit(10)

-&gt;execute()

-&gt;fetchCol();


Hopes this will helps you.