Views 2 Pager disapppaers for CCk mutiple image fields

Hi,

We were trying to create a combined view of 2 content types.
When we are not grouping multiple values pager disappears. Here is the query which is getting run for this view.

SELECT node.nid AS nid,
node_data_field_embed_model_photos.field_embed_model_photos_embed AS node_data_field_embed_model_photos_field_embed_model_photos_embed,
node_data_field_embed_model_photos.field_embed_model_photos_value AS node_data_field_embed_model_photos_field_embed_model_photos_value,
node_data_field_embed_model_photos.field_embed_model_photos_provider AS node_data_field_embed_model_photos_field_embed_model_photos_provider,
node_data_field_embed_model_photos.field_embed_model_photos_data AS node_data_field_embed_model_photos_field_embed_model_photos_data,
node_data_field_embed_model_photos.delta AS node_data_field_embed_model_photos_delta,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_model_photos.field_model_photos_fid AS node_data_field_model_photos_field_model_photos_fid,
node_data_field_model_photos.field_model_photos_list AS node_data_field_model_photos_field_model_photos_list,
node_data_field_model_photos.field_model_photos_data AS node_data_field_model_photos_field_model_photos_data,
node_data_field_model_photos.delta AS node_data_field_model_photos_delta,
node.title AS node_title
FROM node node
LEFT JOIN votingapi_cache votingapi_cache_node ON node.nid = votingapi_cache_node.content_id AND votingapi_cache_node.content_type = 'node'
LEFT JOIN content_field_embed_model_photos node_data_field_embed_model_photos ON node.vid = node_data_field_embed_model_photos.vid
LEFT JOIN content_field_model_photos node_data_field_model_photos ON node.vid = node_data_field_model_photos.vid
WHERE node.type in ('embedded_model_portfolio', 'model_portfolio')

we have tried really hard to find this problem and found it grouping mutilpe values for the image field makes pager appear.

Could you please suggest whats wrong.
Thank you in advance