Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder

With code above its working completely fine only problem i am getting this Notice: when debug mode is on. And i shouldn’t have any notices.

Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder.

Is there any suggestion? I know removing prepare( would take away the problem. But i want to keep the query prepared if you think its not necessary please explain.

Also adding %s, %d for first query, is good. But what for 2nd Query where i have 3 values?

Thanks in advance for reply.