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 (1208,1236,1237,1238,1239,2000,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1291,1292,1293,1294,1295,1296,1297,1298,1299,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1391,1401,1416,1419,1420,1422,1423,1424,1425,1426,1427,1428,1429,2000,2001,2004,2005,2012,2013,2014,2051,2056,2058,2890,2891,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,1300,1335,1340,2007,2009,2010,2011,1565,2008,2016,2027,2037,2041,2061,1350,1360,1363,1440,1441,1450,1646,2006,2017,2021,2025,2028,2038,2039,2050,2055,2059,2060,2089,1355,1430,1435,1585,1590,1648,2015,2022,2023,2040,2042,2043,2048,2065,2090,2091,1445,1465,1466,1470,2018,2029,2033,2047,2049,2052,2062,2088) 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