Australia's No.1 Private and Commercial Parking Website

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 (2043,2042,2043,2017,2016,2015,2008,2006,2050,1450,1441,1440,1435,1430,2038,2037,2018,2007,2044,2048,1445,2040,2033,2021,2010,2009,2049,2052,2204,1476,1475,1466,1465,1363,1300,2041,2039,2032,2020,2014,2013,2012,2011,2005,2004,2001,2000,2051,2056,2058,2130,2203,2890,2891,1460,1429,1428,1427,1426,1425,1424,1423,1422,1420,1419,1416,1401,1391,1340,1335,1334,1333,1332,1331,1330,1329,1328,1327,1326,1325,1324,1323,1322,1321,1320,1319,1318,1317,1316,1315,1314,1313,1312,1311,1299,1298,1297,1296,1295,1294,1293,1292,1291,1250,1249,1248,1247,1246,1245,1244,1243,1242,1241,1240,1239,1238,1237,1236,1235,1234,1233,1232,1231,1230,1229,1228,1227,1226,1225,1224,1223,1222,1221,1220,1219,1218,1217,1216,1215,1214,1213,1212,1211,1210,1209,1208,1207,1205,1203,1202,1201,1199,1198,1197,1196,1195,1194,1193,1192,1191,1190,1189,1188,1187,1186,1185,1184,1183,1182,1181,1180,1179,1178,1177,1176,1175,1174,1173,1172,1171,1170,1169,1168,1167,1166,1165,1164,1163,1162,1161,1160,1159,1158,1157,1156,1155,1154,1153,1152,1151,1150,1149,1148,1147,1146,1145,1144,1143,1142,1141,1140,1139,1138,1137,1136,1135,1134,1133,1132,1131,1130,1129,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1110,1109,1108,1107,1106,1105,1104,1103,1102,1101,1100,1046,1045,1044,1043,1042,1041,1040,1039,1038,1037,1036,1035,1034,1033,1032,1031,1030,1029,1028,1027,1026,1025,1024,1023,1022,1021,1020,1010,1009,1008,1007,1006,1005,1004,1003,1002,1001,2031,2028,2027,2025,2022,2019,1801,1800,2045,2131,2205,1455,1360,1355,1350) 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 'NSW'ORDER BY highlightAdvertPosition DESC