My Story

SELECT * FROM `lpdotcom`.`props-main` WHERE ((`props-main`.`MLNumber` LIKE '%93702%' OR `props-main`.`StreetNumber` LIKE '%93702%' OR `props-main`.`StreetName` LIKE '%93702%' OR `props-main`.`City` LIKE '%93702%' OR `props-main`.`ZipCode` LIKE '%93702%') OR (`props-main`.`MLNumber` LIKE '%93704%' OR `props-main`.`StreetNumber` LIKE '%93704%' OR `props-main`.`StreetName` LIKE '%93704%' OR `props-main`.`City` LIKE '%93704%' OR `props-main`.`ZipCode` LIKE '%93704%') OR (`props-main`.`MLNumber` LIKE '%93711%' OR `props-main`.`StreetNumber` LIKE '%93711%' OR `props-main`.`StreetName` LIKE '%93711%' OR `props-main`.`City` LIKE '%93711%' OR `props-main`.`ZipCode` LIKE '%93711%') OR (`props-main`.`MLNumber` LIKE '%93619%' OR `props-main`.`StreetNumber` LIKE '%93619%' OR `props-main`.`StreetName` LIKE '%93619%' OR `props-main`.`City` LIKE '%93619%' OR `props-main`.`ZipCode` LIKE '%93619%') OR (`props-main`.`MLNumber` LIKE '%93612%' OR `props-main`.`StreetNumber` LIKE '%93612%' OR `props-main`.`StreetName` LIKE '%93612%' OR `props-main`.`City` LIKE '%93612%' OR `props-main`.`ZipCode` LIKE '%93612%') OR (`props-main`.`MLNumber` LIKE '%93611%' OR `props-main`.`StreetNumber` LIKE '%93611%' OR `props-main`.`StreetName` LIKE '%93611%' OR `props-main`.`City` LIKE '%93611%' OR `props-main`.`ZipCode` LIKE '%93611%')) AND (`props-main`.`City` LIKE '%Fresno%' OR `props-main`.`City` LIKE '%Clovis%') AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-03' 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();

D: SELECT * FROM `lpdotcom`.`props-main` WHERE ((`props-main`.`MLNumber` LIKE '%93702%' OR `props-main`.`StreetNumber` LIKE '%93702%' OR `props-main`.`StreetName` LIKE '%93702%' OR `props-main`.`City` LIKE '%93702%' OR `props-main`.`ZipCode` LIKE '%93702%') OR (`props-main`.`MLNumber` LIKE '%93704%' OR `props-main`.`StreetNumber` LIKE '%93704%' OR `props-main`.`StreetName` LIKE '%93704%' OR `props-main`.`City` LIKE '%93704%' OR `props-main`.`ZipCode` LIKE '%93704%') OR (`props-main`.`MLNumber` LIKE '%93711%' OR `props-main`.`StreetNumber` LIKE '%93711%' OR `props-main`.`StreetName` LIKE '%93711%' OR `props-main`.`City` LIKE '%93711%' OR `props-main`.`ZipCode` LIKE '%93711%') OR (`props-main`.`MLNumber` LIKE '%93619%' OR `props-main`.`StreetNumber` LIKE '%93619%' OR `props-main`.`StreetName` LIKE '%93619%' OR `props-main`.`City` LIKE '%93619%' OR `props-main`.`ZipCode` LIKE '%93619%') OR (`props-main`.`MLNumber` LIKE '%93612%' OR `props-main`.`StreetNumber` LIKE '%93612%' OR `props-main`.`StreetName` LIKE '%93612%' OR `props-main`.`City` LIKE '%93612%' OR `props-main`.`ZipCode` LIKE '%93612%') OR (`props-main`.`MLNumber` LIKE '%93611%' OR `props-main`.`StreetNumber` LIKE '%93611%' OR `props-main`.`StreetName` LIKE '%93611%' OR `props-main`.`City` LIKE '%93611%' OR `props-main`.`ZipCode` LIKE '%93611%')) AND (`props-main`.`City` LIKE '%Fresno%' OR `props-main`.`City` LIKE '%Clovis%') AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-03' 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();