select 
 
 c.nombre as cname,
 concat(l.municipio,', ',l.federativa) as place,

 l.direccion as paddr,
 l.observacion as pobs,
 l.municipio as city,
 t.precio as cost,
 t.spay as spay,
 case t.promo_estado when 1 then coalesce(t.promocion,"") else "" end as promo,
 c.descripcion as cdescription,
 c.temario as csubjects,
 c.servicios as cservices,
 l.nombre as pname,
 day(t.fecha_inicio) as dini,
 day(t.fecha_fin) as dend,
 month(t.fecha_inicio) as mini,
 month(t.fecha_fin) as mend

from curso_tienda as t
 inner join curso_lugar as l on t.lugar_id=l.id
 inner join curso as c on t.curso_id=c.id
 where t.estado=1
 and t.id = ?
;