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;