mysql> SELECT plant.plant_id, plant.plant_name, plant.plant_species, plant.plant_blooms, inventory.inventory_retail, inventory.inventory_cost, inventory.inventory_stock FROM plant, inventory WHERE plant.plant_id = inventory.plant_id AND grower_id = 7 AND inventory.plant_id NOT IN (SELECT plant_id FROM inventory WHERE grower_id = 7 LIMIT 0) LIMIT 25;
ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
mysql> SELECT plant.plant_id, plant.plant_name, plant.plant_species, plant.plant_blooms, inventory.inventory_retail, inventory.inventory_cost, inventory.inventory_stock FROM plant, inventory WHERE plant.plant_id = inventory.plant_id AND grower_id = 7 AND inventory.plant_id NOT IN (SELECT plant_id FROM inventory WHERE grower_id = 7 LIMIT 25) LIMIT 25;
ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
mysql> SELECT plant.plant_id, plant.plant_name, plant.plant_species, plant.plant_blooms, inventory.inventory_retail, inventory.inventory_cost, inventory.inventory_stock FROM plant, inventory WHERE plant.plant_id = inventory.plant_id AND grower_id = 7 AND inventory.plant_id NOT IN (SELECT plant_id FROM inventory WHERE grower_id = 7 LIMIT 0) LIMIT 25;
ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
mysql> SELECT version();+-----------+| version() |
+-----------+
| 5.0.24a   |
+-----------+
1 row in set (0.02 sec)

mysql>