Table 'pixilink_mlsr.mlsr_listings' doesn't existSELECT mlsr_listings.*,
            (SELECT CONCAT(file.directory, file.name) AS imageloc
                      FROM pixilink_mlsr.listing_file 
                      JOIN pixilink_mlsr.file ON (listing_file.file_id = file.id)
                      WHERE listing_file.listing_id = mlsr_listings.id ORDER BY file.id ASC LIMIT 1) AS imageLoc 
            from mlsr_listings where listingid = 'R2564785'