Mine

SELECT name, governate, type, dateStart, dateEnd, number, value FROM
	stats_entry,
	stats_contracttype,
	registration_governate,
	registration_propertytype
	JOIN stats_contracttype ON stats_entry.contract_id = stats_contracttype.id,
	JOIN registration_governate ON stats_entry.governate_id = registration_governate.id,
	JOIN registration_propertytype ON stats_entry.proptype_id = registration_propertytype.id,
	WHERE week(dateEnd) = 39 and week(dateStart) = 39 ORDER BY value;