SELECT
client_bid_cap_data_id,
bid_cap_org_id organizations_id,
bank_buyout,
old_photo_black_volume,
interest_rate, rate_factor,
(CASE commision WHEN 'Yes' THEN 'Y' WHEN 'No' THEN 'N' WHEN '0' THEN 'N' ELSE NULL END) commission,
escrow,
server,
survey_date,
annual_black_volume,
annual_color_volume,
average_ss_black_cpc,
average_ss_color_cpc,
(CASE WHEN created_date = '0000-00-00 00:00:00' THEN NOW() ELSE created_date END) created_date,
1271 created_by,
(CASE WHEN modified_date = '0000-00-00 00:00:00' THEN NOW() ELSE modified_date END) modified_date,
1271 modified_by

FROM client_bid_cap_data;