x.id,
x.vendor_id,
x.place_id,
x.status,
x.g_place_id,
x.place_name,
x.place_address,
x.g_data,


y.id,
y.vendor_id,
y.promotion_type,
y.title,
y.pic,
y.venue,
y.timeframe,
y.desc,
y.quantity_limt,
y.quantity,
y.status,
y.impression_count  ,
y.view_count,
y.save_count,
y.redemption_count,
y.promotion_id,
y.hpy_hr_start,
y.hpy_hr_end,
y.startdate,
y.enddate,
y.repeat,
y.frequency,
y.eve_day,
y.eve_week,
y.eve_month,
y.eve_year

WHERE
                            dpc.g_place_id=dsc.place_id

dp.id = dt.promotion_id
                        AND
                        dt.enddate between CURDATE() and dt.enddate