SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 150000 AND (`props-main`.`City` LIKE '%fresno%' OR `props-main`.`City` LIKE '%clovis%') AND (((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Duplex' OR `props-main`.`PropertySubtype2` = 'Duplex' OR `props-main`.`PropertySubtype3` = 'Duplex' OR `NumberUnits` = 2)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Triplex' OR `props-main`.`PropertySubtype2` = 'Triplex' OR `props-main`.`PropertySubtype3` = 'Triplex' OR `NumberUnits` = 3)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Four Plex' OR `props-main`.`PropertySubtype2` = 'Four Plex' OR `props-main`.`PropertySubtype3` = 'Four Plex' OR `props-main`.`PropertySubtype1` = 'Fourplex' OR `props-main`.`PropertySubtype2` = 'Fourplex' OR `props-main`.`PropertySubtype3` = 'Fourplex' OR `NumberUnits` = 4)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = '11 Units & More' OR `props-main`.`PropertySubtype2` = '11 Units & More' OR `props-main`.`PropertySubtype3` = '11 Units & More' OR `props-main`.`PropertySubtype1` = '5 or More Units' OR `props-main`.`PropertySubtype2` = '5 or More Units' OR `props-main`.`PropertySubtype3` = '5 or More Units' OR `props-main`.`PropertySubtype1` = '5 to 10 Units' OR `props-main`.`PropertySubtype2` = '5 to 10 Units' OR `props-main`.`PropertySubtype3` = '5 to 10 Units' OR `props-main`.`PropertySubtype1` = 'Apartments' OR `props-main`.`PropertySubtype2` = 'Apartments' OR `props-main`.`PropertySubtype3` = 'Apartments' OR `NumberUnits` >= 5))) AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-10' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();

B: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 150000 AND (`props-main`.`City` LIKE '%fresno%' OR `props-main`.`City` LIKE '%clovis%') AND (((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Duplex' OR `props-main`.`PropertySubtype2` = 'Duplex' OR `props-main`.`PropertySubtype3` = 'Duplex' OR `NumberUnits` = 2)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Triplex' OR `props-main`.`PropertySubtype2` = 'Triplex' OR `props-main`.`PropertySubtype3` = 'Triplex' OR `NumberUnits` = 3)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = 'Four Plex' OR `props-main`.`PropertySubtype2` = 'Four Plex' OR `props-main`.`PropertySubtype3` = 'Four Plex' OR `props-main`.`PropertySubtype1` = 'Fourplex' OR `props-main`.`PropertySubtype2` = 'Fourplex' OR `props-main`.`PropertySubtype3` = 'Fourplex' OR `NumberUnits` = 4)) OR ((`props-main`.`PropertyType` = 'Income Property' OR `props-main`.`PropertyType` = 'Multi Family' OR `props-main`.`PropertyType` = 'Multi-Family') AND ( `props-main`.`PropertySubtype1` = '11 Units & More' OR `props-main`.`PropertySubtype2` = '11 Units & More' OR `props-main`.`PropertySubtype3` = '11 Units & More' OR `props-main`.`PropertySubtype1` = '5 or More Units' OR `props-main`.`PropertySubtype2` = '5 or More Units' OR `props-main`.`PropertySubtype3` = '5 or More Units' OR `props-main`.`PropertySubtype1` = '5 to 10 Units' OR `props-main`.`PropertySubtype2` = '5 to 10 Units' OR `props-main`.`PropertySubtype3` = '5 to 10 Units' OR `props-main`.`PropertySubtype1` = 'Apartments' OR `props-main`.`PropertySubtype2` = 'Apartments' OR `props-main`.`PropertySubtype3` = 'Apartments' OR `NumberUnits` >= 5))) AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-10' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();