Workep Scrap

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT P.title, P.Tags, P.ViewCount,P.Score,P.AnswerCount,P.CreationDate
FROM Posts P
WHERE
(P.Tags LIKE '%backend%') OR
(P.Tags LIKE '%frontend%') OR
(P.Tags LIKE '% bug %') OR
(P.Tags LIKE '% api %') OR
(P.Tags LIKE '% ux %') OR
(P.Tags LIKE '% ui %') OR
(P.Tags LIKE '%mobile%') OR
(P.Tags LIKE '%web%') OR
(P.Tags LIKE '% performance %') OR
(P.Tags LIKE '% deploy %') OR
(P.Tags LIKE '% docs %') OR
(P.Tags LIKE '% tests %') OR
(P.Tags LIKE '% security %') OR
(P.Tags LIKE '% qa %') AND
P.CreationDate > '2019-06-01'


ORDER by year(P.CreationDate)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results