$q = db_select('node', 'n')
    ->fields('n', array('nid', 'title'))
    ->condition('n.type', 'product')
    ->condition('n.status', 1);

  // get file mp3
  $q->join('field_data_field_mp3', 'mp3', 'n.nid = mp3.entity_id');
  $q->join('file_managed', 'f', 'mp3.field_mp3_fid = f.fid');
  $q->addField('f', 'uri', 'mp3_url');

  // join get bpm
  $q->join('field_data_field_bpm', 'bpm', 'n.nid = bpm.entity_id');
  $q->addField('bpm', 'field_bpm_value', 'bpm');

  // basic product
  $q->leftJoin('field_data_field_product_basic', 'basic',
    'basic.entity_id = n.nid');

  $q->leftJoin('field_data_commerce_price', 'basic_price',
    "basic_price.entity_id = basic.field_product_basic_product_id");
  $q->addField('basic_price', 'commerce_price_amount', 'basic_amount');
  $q->addField('basic_price', 'commerce_price_currency_code',
    'basic_currency_code');


  //standard
  $q->leftJoin('field_data_field_product_standard', 'standard',
    'standard.entity_id = n.nid');


  $q->leftJoin('field_data_commerce_price', 'standard_price',
    "standard_price.entity_id = standard.field_product_standard_product_id");
  $q->addField('standard_price', 'commerce_price_amount', 'standard_amount');
  $q->addField('standard_price', 'commerce_price_currency_code',
    'standard_currency_code');


  //premium
  $q->leftJoin('field_data_field_product_premium', 'premium',
    'premium.entity_id = n.nid');

  $q->leftJoin('field_data_commerce_price', 'premium_price',
    "premium_price.entity_id = premium.field_product_premium_product_id");
  $q->addField('premium_price', 'commerce_price_amount', 'premium_amount');
  $q->addField('premium_price', 'commerce_price_currency_code',
    'premium_currency_code');


  //exclusive
  $q->leftJoin('field_data_field_product_exclusive', 'exclusive',
    'exclusive.entity_id = n.nid');


  $q->leftJoin('field_data_commerce_price', 'exclusive_price',
    "exclusive_price.entity_id = exclusive.field_product_exclusive_product_id");
  $q->addField('exclusive_price', 'commerce_price_amount', 'exclusive_amount');
  $q->addField('exclusive_price', 'commerce_price_currency_code',
    'exclusive_currency_code');


  $q->range($offset, $limit);

  $result = $q->execute();