About new life nursery inc

We're proud of our featured plants.
SELECT p.plant_id, p.botanical_name, p.plant_library_id, p.common_name, p.featured, IF(p.description != '', p.description, main.description) AS description, IF(p.image !='', p.image, (SELECT pai_image.image FROM mbolin_master_availability.plant_availability_image AS pai_image WHERE pai_image.plant_id=p.plant_id AND p.client_id=36 ORDER BY pai_image.id LIMIT 1)) AS image FROM plant_featured_list AS pfl LEFT JOIN mbolin_master_availability.plant AS p USING(plant_id) LEFT JOIN mbolin_master_availability.plant_featured AS pf ON(pf.id=pfl.plant_featured_id) LEFT JOIN mbolin_master_plantdb.plant AS main ON(main.plant_id=p.plant_library_id) WHERE pf.client_id=36 AND pf.title='Featured Plants' ORDER BY pfl.id ASCSELECT command denied to user 'newlifen_upload'@'localhost' for table 'plant_availability_image'