1
select `civicrm`.`civicrm_batch`.`id` AS `id`,`civicrm`.`civicrm_batch`.`name` AS `name`,`civicrm`.`civicrm_batch`.`created_id` AS `created_id`,`civicrm`.`civicrm_batch`.`created_date` AS `created_date`,`civicrm`.`civicrm_batch`.`modified_id` AS `modified_id`,`civicrm`.`civicrm_batch`.`modified_date` AS `modified_date`,`civicrm`.`civicrm_batch`.`saved_search_id` AS `saved_search_id`,`civicrm`.`civicrm_batch`.`status_id` AS `status_id`,`civicrm`.`civicrm_batch`.`type_id` AS `type_id`,`civicrm`.`civicrm_batch`.`mode_id` AS `mode_id`,`civicrm`.`civicrm_batch`.`total` AS `total`,`civicrm`.`civicrm_batch`.`item_count` AS `item_count`,`civicrm`.`civicrm_batch`.`payment_instrument_id` AS `payment_instrument_id`,`civicrm`.`civicrm_batch`.`exported_date` AS `exported_date`,`civicrm`.`civicrm_batch`.`data` AS `data`,`civicrm`.`civicrm_batch`.`title_fr_CA` AS `title`,`civicrm`.`civicrm_batch`.`description_fr_CA` AS `description` from `civicrm`.`civicrm_batch`