SELECT COUNT(rewards.REWARD_ID) as reward, merchants.*, cities.ID, cities.url, locations.CITY_ID, categories.PCAT_ID FROM merchants LEFT JOIN rewards ON merchants.MERCH_ID = rewards.MERCH_ID JOIN merchant_categories ON merchants.MERCH_ID = merchant_categories.MERCH_ID JOIN categories ON merchant_categories.CAT_ID = categories.CAT_ID JOIN locations ON merchants.MERCH_ID = locations.MERCH_ID JOIN cities ON locations.CITY_ID = cities.ID WHERE 1 AND cities.url = "el-paso-tx" AND LIKE "P%" AND merchants.status = "1" GROUP BY merchants.MERCH_ID ORDER BY ASC LIMIT -10, 10

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-10, 10' at line 1

No results under“P”