SELECT * FROM villa_data INNER JOIN villa_details ON villa_data.villaRef=villa_details.villaRef INNER JOIN villa_prices_granular ON villa_prices_granular.pricingRef=villa_data.pricingRef INNER JOIN villa_suppliers ON villa_suppliers.supplierID=villa_data.supplierID WHERE capacity >= 1 AND villa_data.nearestTown LIKE '%san jose%' AND periodStart <= '20-june-1900' AND periodEnd >= '20-june-1900' AND supplierLive <> 0 AND villa_data.onSale = 1 AND villa_data.supplierID <> 'ESS' AND villa_data.supplierID <> 'SECRET' ORDER BY supplierPosition,priceIndicator,bedrooms,capacity