select
a.id,
a.product_id,
group_concat(b.option_name separator ' ') as name,
concat('storage/model/', c.row_value) as row_value,
e.name as product_name,
a.row_status
from cmr_model a
left join cmr_model_option b on a.id = b.model_id
left join cmr_model_image c on a.id = c.parent_id and is_cover = 1
left join cmr_product e on a.product_id = e.group_id
where a.row_status in (1, 4)
and b.lang_id = 'la'
and e.lang_id = 'la'
and (b.property_key = 'name' or b.property_key = 'topic') and a.product_id = 1 group by a.id
order by a.update_date desc