Skip to content

Instantly share code, notes, and snippets.

View AngryLionAman's full-sized avatar
💭
Just working on project inquiryhere.com, if you want see me visit website.

Aman Kumar AngryLionAman

💭
Just working on project inquiryhere.com, if you want see me visit website.
View GitHub Profile
@AngryLionAman
AngryLionAman / How meta title and desc generated
Last active October 30, 2019 03:37
This is dynamic website so every link automatic generate the meta title and meta description
<c:if test="${questionId ne null}">
<c:catch var="ex">
<c:forEach var="h_seo" items="${SEO.getTitleAndDescripiton(questionId)}">
<title><c:out value="${h_seo.questionTitle}"/>- inquiryhere.com</title>
<meta property="og:title" content="<c:out value="${h_seo.questionTitle}"/>" />
<c:if test="${not empty h_seo.questionDescription and h_seo.questionDescription ne null}">
<meta property="og:description" content="<c:out value="${h_seo.questionDescription}"/>"/>
<meta property="description" content="<c:out value="${h_seo.questionDescription}"/>"/>
</c:if>
<c:if test="${empty h_seo.questionDescription or h_seo.questionDescription eq null}">
mysql> select t.unique_id, t.topic_name,count(distinct user_or_followers_id)as totalFollowers from topic t left join topic_followers_detail tf on tf.topic_id - t.unique_id group by 1 limit 20;
+-----------+--------------------------+----------------+
| unique_id | topic_name | totalFollowers |
+-----------+--------------------------+----------------+
| 255 | Engineering | 53 |
| 256 | decision making | 58 |
| 257 | career decision | 55 |
| 258 | rahul gandhi | 57 |
| 259 | politician | 58 |
| 260 | congress party | 58 |