xCRUDYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BETWEEN 0 AND 0 AND geoCountry = 'spain' AND geoCity IN ( 'Alhaurin Golf','Aloha' at line 1

SELECT _dspListingTypeSub, count( _dspListingTypeSub ) FROM qres_app_lst_listing WHERE  BETWEEN 0 AND 0 AND geoCountry = 'spain' AND geoCity IN ( 'Alhaurin Golf','Aloha','Altos de los Monteros','Arroyo de la Miel','Artola','Atalaya','Bahia de Marbella','Bel Air','Benahavís','Benalmadena','Benalmadena Costa','Benalmadena Pueblo','Cabopino','Calahonda','Calanova Golf','Calypso','Campo Mijas','Cancelada','Carib Playa','Cerros del Aguila','Costabella','Diana Park','El Chaparral','El Coto','El Faro','El Paraiso','El Rosario','Elviria','Estepona','Fuengirola','Guadalmina Alta','Guadalmina Baja','Hacienda Las Chapas','Istan','La Cala','La Cala de Mijas','La Cala Golf','La Cala Hills','La Heredia','La Mairena','La Quinta','Las Chapas','Las Lagunas','Los Boliches','Los Monteros','Los Pacos','Marbella','Marbesa','Mijas','Mijas Costa','Mijas Golf','Miraflores','Nagüeles','New Golden Mile','Nueva Andalucía','Ojén','Puerto Banús','Puerto de Cabopino','Reserva de Marbella','Río Real','Riviera del Sol','Santa Clara','The Golden Mile','Torreblanca','Torrenueva','Valtocado' ) GROUP by _dspListingTypeSub