• North Shore Story: Reputation Management in Minnesota
    North Shore Story: Reputation Management in Minnesota

    While vacationing with our family on Minnesota's beautiful North Shore of Lake Superior, our car suffered a mishap in a construction zone. A large rock tumbled out of the dump truck in front of us and before we could react or stop, we had driven over it, leaving a 5 inch hole in the oil pan. We immediately pulled over to Split Rock State Park, where I began searching for a tow service. Luckily, I had seen a tow truck assisting someone else at another Minnesota State park two days earlier, and I remembered the name: Blazers Auto Service. Using my smartphone, I ran a search on Google and discovered that:

    • a Blazers does not have a web site.
    • b. There are plenty of online reviews - SOME QUITE NEGATIVE - in various directories (Yahoo Local, Yelp, etc.) with the phone number.

Phone icon for calling web design Call Today:

  • (877) 455-4994 (toll free)
  • (612) 594-4495 (cell)

Concerto Designs Minneapolis Joomla Web Design medallion logo

Show Missing Entries with Mysql 'WHERE NOT EXISTS'

SELECT DISTINCT ( `sul4t_jsn_users`.`id` ), `sul4t_jsn_users`.`firstname`, `sul4t_jsn_users`.`lastname` FROM `sul4t_jsn_users` JOIN `sul4t_newcardsame` ON `sul4t_newcardsame`.`memberName` = `sul4t_jsn_users`.`id` JOIN `sul4t_newcardmultiple` ON `sul4t_newcardmultiple`.`memberName` = `sul4t_jsn_users`.`id` JOIN `sul4t_newcard_sundays2016` ON `sul4t_newcard_sundays2016`.`id` = `sul4t_newcardsame`.`weekEnding2016` AND `sul4t_newcard_sundays2016`.`id` = `sul4t_newcardmultiple`.`weekEndingMultiple2016` WHERE NOT EXISTS ( SELECT `memberName` FROM `sul4t_newcardsame` WHERE `sul4t_newcardsame`.`memberName` = `sul4t_jsn_users`.`id` AND `sul4t_newcardsame`.`weekEnding2016` = '1' AND `sul4t_newcardmultiple`.`memberName` = `sul4t_jsn_users`.`id` AND `sul4t_newcardmultiple`.`weekEndingMultiple2016` = '1') ORDER BY `lastname` ASC

Look for my Joomla & CMS Web design services on Thumbtack. Thumbtack shares my expertise in hosting, email set-up,logo design / revision, content development, CMS customiization, and much more. Check out my listing to learn more!

Alan Smith's VisualCV Badge for Concerto Designs Facebook page