select p.id, p.author, p.name_EN, ppv.value_EN, ppv.property_id, p.image_id, p.short_description_EN, p.price_level1, p.price_level2, p.price_level3, p.price_level4, p.price_level5, p.price_level6
from products p, products_programmes pp
left join products_properties_values ppv on (p.id=ppv.product_id)
where p.is_active=1 and p.programme_id=12 and pp.id=p.programme_id order by name_EN asc