SELECT p.* FROM property p INNER JOIN customer c ON p.customerid = c.customerid AND c.archived IS NULL AND c.isDisabled = 0 WHERE LISTINGSTATUS = 'L'AND (p.expirydate IS NULL or p.expirydate > now()) AND highlightAdvertPosition = 0 AND p.ADDRESSPOSTCODE IN (2444,2529,2580,2601,3032,3152,3207,4000,4001,4002,4006,4007,4029,4053,4101,4106,4114,4169,4214,4350,4500,4700,4870,5000,6000,6015,9000,9001,9002,9003,9005,9007,9008,9009,9010,9013,9015,9016,9017,9018,9019,9020,9021,9022,9023,2610,8873,9003,4106,5000,5887,6820,200,9019,6001,6843,6015,1930,4363,5800,4000,9005,5001,5888,6827,9020,6003,6844,1929,4364,5810,299,4001,9007,5005,5900,6830,9021,6845,2529,4365,5839,298,4002,9008,5901,6831,9022,4214,6846,2580,3207,4053,5880,297,3152,4003,9009,5902,6832,9023,6847,2600,4500,5881,296,4004,9010,4114,5903,6837,6848,2589,5882,6905,295,9013,5904,6838,6849,2601,5883,6800,294,9015,5920,6839,3032,6850,9000,4700,5884,6803,293,9016,5942,6840,6865,9001,4711,5885,6809,291,9017,5950,6841,2444,4350,2608,9002,4870,5886,6817,221,9018,6000,6842,4353,6004,3039,6892,8007,8071,3040,8386,6900,2612,8008,3031,8100,3001,8388,6901,8009,4108,8101,4059,3000,8390,6902,8010,5006,3050,8102,5067,6005,8393,6903,8045,8103,4064,6006,8001,8394,4169,8051,8107,6007,8396,8060,4005,5031,3010,8108,8003,8399,6906,8061,4006,4117,3008,8111,5071,8004,8066,8120,8005,4075,8069,3005,8205,4101,6050,6872,8006,6929,8070,8383,6931,5061,4107,5063,3133,5065,6090,6019,6100,4215,6910,4054,3011,3015,5069,6151,6944,4066,3055,4171,3179,5033,6945,3180,5034,6951,3006,4072,3206,5035,6979,3034,6922,8865,3205,4131,6010,4102,6051,3150,4030,4132,9464,6052,6932,3019,4121,3013,4060,3051,4037,4112,5007,3012,3016,5068,3052,6904,4065,4011,4501,4031,6008,4068,4067,2602,4119,4012,5081,6016,8500,6915,4010,4127,4013,5082,4073,4029,3004,4172,3141,3002,4103,3135,3065,4051,4152,6017,3041,4104,4032,6060,6937,3053,6018,3044,4120,4035,3132,4111,6938,4151,6939,6103,3153,5008,6940,4217,6916,3054,8002,4170,4055,3155,4116,3003,9726,5070,6917,4502,4009,9728,6014,6918,3056,8507,4105,6913,4007,3033,9729,6921,2603,8557,8538,5037,2528,5083) UNION SELECT p.* FROM property p INNER JOIN customer c ON p.customerid = c.customerid AND c.archived IS NULL WHERE p.listingStatus IN ('L')AND c.isDisabled = 0 AND highlightAdvertPosition > 0 AND (p.expirydate IS NULL or p.expirydate > now())AND p.addressstate RLIKE 'ACT|NSW|VIC|QLD|SA|WA'ORDER BY highlightAdvertPosition DESC