com.google.code.gson_1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Islam Meta

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

SELECT
  c.Id AS CommentId,
  c.PostId AS PostId,
  c.Text AS CommentText,
  c.CreationDate,
  p.Title AS PostTitle,
  p.Body AS PostBody,
  CASE
    WHEN c.Text LIKE '%completeness%' OR c.Text LIKE '%functionality%' OR c.Text LIKE '%accurate%'
         OR c.Text LIKE '%exact%' OR c.Text LIKE '%perfect%' OR c.Text LIKE '%precise%' OR c.Text LIKE '%proper%'
         OR c.Text LIKE '%exactness%' OR c.Text LIKE '%accuracy%' OR c.Text LIKE '%clarity%' OR c.Text LIKE '%correctness%'
         OR c.Text LIKE '%perfection%' OR c.Text LIKE '%nicety%' OR c.Text LIKE '%unnecessary steps%' OR c.Text LIKE '%fulness%'
         OR c.Text LIKE '%wholeness%' OR c.Text LIKE '%absoluteness%' THEN 'Functional Suitability'
    WHEN c.Text LIKE '%reliable%' OR c.Text LIKE '%fault tolerant%' OR c.Text LIKE '%recoverability%' OR c.Text LIKE '%availability%' THEN 'Reliability'
    WHEN c.Text LIKE '%response time%' OR c.Text LIKE '%responsiveness%' OR c.Text LIKE '%throughput%' OR c.Text LIKE '%latency%'
         OR c.Text LIKE '%scalability%' OR c.Text LIKE '%reaction time%' OR c.Text LIKE '%latency period%' OR c.Text LIKE '%time interval%'
         OR c.Text LIKE '%interval%' OR c.Text LIKE '%processing time%' OR c.Text LIKE '%battery%' OR c.Text LIKE '%battery drainage%'
         OR c.Text LIKE '%memory usage%' OR c.Text LIKE '%CPU cycle%' OR c.Text LIKE '%storage%' OR c.Text LIKE '%capacity%'
         OR c.Text LIKE '%communication bandwidth%' THEN 'Performance'
    WHEN c.Text LIKE '%user-friendly%' OR c.Text LIKE '%ease of use%' OR c.Text LIKE '%easy to understand%' OR c.Text LIKE '%accessible%'
         OR c.Text LIKE '%appealing%' OR c.Text LIKE '%aesthetical appealing%' OR c.Text LIKE '%guidelines%' OR c.Text LIKE '%instruction%'
         OR c.Text LIKE '%direction%' OR c.Text LIKE '%suggestion%' OR c.Text LIKE '%advice%' OR c.Text LIKE '%easy to remember steps%'
         OR c.Text LIKE '%controllability%' OR c.Text LIKE '%error protection%' OR c.Text LIKE '%ability%' OR c.Text LIKE '%secure%'
         OR c.Text LIKE '%correct%' OR c.Text LIKE '%use of color%' OR c.Text LIKE '%graphical design%' THEN 'Usability'
    WHEN c.Text LIKE '%immunity%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%integrity%' OR c.Text LIKE '%accountability%' OR c.Text LIKE '%authenticating%' THEN 'Security'
    WHEN c.Text LIKE '%similarity%' OR c.Text LIKE '%agreement%' OR c.Text LIKE '%fellow feeling%' THEN 'Compatibility'
    WHEN c.Text LIKE '%screen fields%' OR c.Text LIKE '%tables%' OR c.Text LIKE '%transaction volumes%' OR c.Text LIKE '%report formats%'
         OR c.Text LIKE '%installed by an end user%' OR c.Text LIKE '%compactness%' OR c.Text LIKE '%convenience%' OR c.Text LIKE '%handiness%'
         OR c.Text LIKE '%lightness%' OR c.Text LIKE '%replaceability%' THEN 'Portability'
    WHEN c.Text LIKE '%friendly%' OR c.Text LIKE '%wonderful%' OR c.Text LIKE '%reliable%' OR c.Text LIKE '%delightful%' OR c.Text LIKE '%first-class%'
         OR c.Text LIKE '%first-rate%' OR c.Text LIKE '%super%' OR c.Text LIKE '%fantastic%' OR c.Text LIKE '%incredible%' OR c.Text LIKE '%heavenly%'
         OR c.Text LIKE '%fabulous%' OR c.Text LIKE '%fab%' OR c.Text LIKE '%fantabulous%' OR c.Text LIKE '%awesome%' OR c.Text LIKE '%mind-blowing%'
         OR c.Text LIKE '%sparkling%' OR c.Text LIKE '%brilliant%' OR c.Text LIKE '%capital%' OR c.Text LIKE '%champion%' OR c.Text LIKE '%extremely good%'
         OR c.Text LIKE '%contentment%' OR c.Text LIKE '%gratification%' OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%joy%' OR c.Text LIKE '%enjoyment%'
         OR c.Text LIKE '%functionality%' OR c.Text LIKE '%fitness%' OR c.Text LIKE '%adequacy%' OR c.Text LIKE '%neatness%' OR c.Text LIKE '%convenience%'
         OR c.Text LIKE '%utility%' OR c.Text LIKE '%use%' OR c.Text LIKE '%value%' OR c.Text LIKE '%worth%' OR c.Text LIKE '%merit%' OR c.Text LIKE '%success%'
         OR c.Text LIKE '%benefits%' OR c.Text LIKE '%advantages%' OR c.Text LIKE '%helpfulness%' OR c.Text LIKE '%good avail%' OR c.Text LIKE '%help%'
         OR c.Text LIKE '%assistance%' OR c.Text LIKE '%confident%' OR c.Text LIKE '%believe%' OR c.Text LIKE '%faith%' OR c.Text LIKE '%safe%' OR c.Text LIKE '%assurance%'
         OR c.Text LIKE '%reliance%' OR c.Text LIKE '%safekeeping%' OR c.Text LIKE '%protection%' OR c.Text LIKE '%care%' OR c.Text LIKE '%guardianship%'
         OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%relief%' OR c.Text LIKE '%trust%' OR c.Text LIKE '%secure%' OR c.Text LIKE '%quality%' THEN 'Satisfaction'
    WHEN c.Text LIKE '%waste%' OR c.Text LIKE '%miss%' OR c.Text LIKE '%problem%' OR c.Text LIKE '%wrong%' OR c.Text LIKE '%accuracy%'
         OR c.Text LIKE '%completeness%' OR c.Text LIKE '%precision%' OR c.Text LIKE '%exactness%' OR c.Text LIKE '%validity%' OR c.Text LIKE '%authority%'
         OR c.Text LIKE '%reliability%' OR c.Text LIKE '%perfection%' OR c.Text LIKE '%faithfulness%' OR c.Text LIKE '%closeness%' OR c.Text LIKE '%truth%'
         OR c.Text LIKE '%truthfulness%' OR c.Text LIKE '%authenticity%' OR c.Text LIKE '%realism%' OR c.Text LIKE '%fairness%' OR c.Text LIKE '%rigour%' THEN 'Effectiveness'
    WHEN c.Text LIKE '%defense%' OR c.Text LIKE '%shielding%' OR c.Text LIKE '%shelter%' OR c.Text LIKE '%preservation%' OR c.Text LIKE '%conservation%'
         OR c.Text LIKE '%safe keeping%' OR c.Text LIKE '%safeguard%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%support%' OR c.Text LIKE '%providence%'
         OR c.Text LIKE '%dependability%' THEN 'Freedom of Risk'
    WHEN c.Text LIKE '%slow%' OR c.Text LIKE '%limit%' OR c.Text LIKE '%fast%' OR c.Text LIKE '%lock%' OR c.Text LIKE '%unhurried%'
         OR c.Text LIKE '%leisurely%' OR c.Text LIKE '%moderate%' OR c.Text LIKE '%deliberate%' OR c.Text LIKE '%steady%' OR c.Text LIKE '%slow moving%'
         OR c.Text LIKE '%time to complete a task%' THEN 'Efficiency'
    ELSE 'Other'
  END AS Aspect
FROM
  Comments c
INNER JOIN
  Posts p ON c.PostId = p.Id
WHERE
(p.Tags LIKE '%gson%' OR p.Tags LIKE '%google%')
  AND p.CreationDate >= '2023-01-01'
  AND (
    c.Text LIKE '%completeness%' OR c.Text LIKE '%functionality%' OR c.Text LIKE '%accurate%'
    OR c.Text LIKE '%exact%' OR c.Text LIKE '%perfect%' OR c.Text LIKE '%precise%' OR c.Text LIKE '%proper%'
    OR c.Text LIKE '%exactness%' OR c.Text LIKE '%accuracy%' OR c.Text LIKE '%clarity%' OR c.Text LIKE '%correctness%'
    OR c.Text LIKE '%perfection%' OR c.Text LIKE '%nicety%' OR c.Text LIKE '%unnecessary steps%' OR c.Text LIKE '%fulness%'
    OR c.Text LIKE '%wholeness%' OR c.Text LIKE '%absoluteness%' OR c.Text LIKE '%reliable%' OR c.Text LIKE '%fault tolerant%'
    OR c.Text LIKE '%recoverability%' OR c.Text LIKE '%availability%' OR c.Text LIKE '%response time%' OR c.Text LIKE '%responsiveness%'
    OR c.Text LIKE '%throughput%' OR c.Text LIKE '%latency%' OR c.Text LIKE '%scalability%' OR c.Text LIKE '%reaction time%'
    OR c.Text LIKE '%latency period%' OR c.Text LIKE '%time interval%' OR c.Text LIKE '%interval%' OR c.Text LIKE '%processing time%'
    OR c.Text LIKE '%battery%' OR c.Text LIKE '%battery drainage%' OR c.Text LIKE '%memory usage%' OR c.Text LIKE '%CPU cycle%'
    OR c.Text LIKE '%storage%' OR c.Text LIKE '%capacity%' OR c.Text LIKE '%communication bandwidth%' OR c.Text LIKE '%user-friendly%'
    OR c.Text LIKE '%ease of use%' OR c.Text LIKE '%easy to understand%' OR c.Text LIKE '%accessible%' OR c.Text LIKE '%appealing%'
    OR c.Text LIKE '%aesthetical appealing%' OR c.Text LIKE '%guidelines%' OR c.Text LIKE '%instruction%' OR c.Text LIKE '%direction%'
    OR c.Text LIKE '%suggestion%' OR c.Text LIKE '%advice%' OR c.Text LIKE '%easy to remember steps%' OR c.Text LIKE '%controllability%'
    OR c.Text LIKE '%error protection%' OR c.Text LIKE '%ability%' OR c.Text LIKE '%secure%' OR c.Text LIKE '%correct%' OR c.Text LIKE '%use of color%'
    OR c.Text LIKE '%graphical design%' OR c.Text LIKE '%immunity%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%integrity%' OR c.Text LIKE '%accountability%'
    OR c.Text LIKE '%authenticating%' OR c.Text LIKE '%similarity%' OR c.Text LIKE '%agreement%' OR c.Text LIKE '%fellow feeling%' OR c.Text LIKE '%screen fields%'
    OR c.Text LIKE '%tables%' OR c.Text LIKE '%transaction volumes%' OR c.Text LIKE '%report formats%' OR c.Text LIKE '%installed by an end user%'
    OR c.Text LIKE '%compactness%' OR c.Text LIKE '%convenience%' OR c.Text LIKE '%handiness%' OR c.Text LIKE '%lightness%' OR c.Text LIKE '%replaceability%'
    OR c.Text LIKE '%friendly%' OR c.Text LIKE '%wonderful%' OR c.Text LIKE '%reliable%' OR c.Text LIKE '%delightful%' OR c.Text LIKE '%first-class%'
    OR c.Text LIKE '%first-rate%' OR c.Text LIKE '%super%' OR c.Text LIKE '%fantastic%' OR c.Text LIKE '%incredible%' OR c.Text LIKE '%heavenly%'
    OR c.Text LIKE '%fabulous%' OR c.Text LIKE '%fab%' OR c.Text LIKE '%fantabulous%' OR c.Text LIKE '%awesome%' OR c.Text LIKE '%mind-blowing%'
    OR c.Text LIKE '%sparkling%' OR c.Text LIKE '%brilliant%' OR c.Text LIKE '%capital%' OR c.Text LIKE '%champion%' OR c.Text LIKE '%extremely good%'
    OR c.Text LIKE '%contentment%' OR c.Text LIKE '%gratification%' OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%joy%' OR c.Text LIKE '%enjoyment%'
    OR c.Text LIKE '%functionality%' OR c.Text LIKE '%fitness%' OR c.Text LIKE '%adequacy%' OR c.Text LIKE '%neatness%' OR c.Text LIKE '%convenience%'
    OR c.Text LIKE '%utility%' OR c.Text LIKE '%use%' OR c.Text LIKE '%value%' OR c.Text LIKE '%worth%' OR c.Text LIKE '%merit%' OR c.Text LIKE '%success%'
    OR c.Text LIKE '%benefits%' OR c.Text LIKE '%advantages%' OR c.Text LIKE '%helpfulness%' OR c.Text LIKE '%good avail%' OR c.Text LIKE '%help%'
    OR c.Text LIKE '%assistance%' OR c.Text LIKE '%confident%' OR c.Text LIKE '%believe%' OR c.Text LIKE '%faith%' OR c.Text LIKE '%safe%'
    OR c.Text LIKE '%assurance%' OR c.Text LIKE '%reliance%' OR c.Text LIKE '%safekeeping%' OR c.Text LIKE '%protection%' OR c.Text LIKE '%care%'
    OR c.Text LIKE '%guardianship%' OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%relief%' OR c.Text LIKE '%trust%' OR c.Text LIKE '%secure%'
    OR c.Text LIKE '%quality%' OR c.Text LIKE '%waste%' OR c.Text LIKE '%miss%' OR c.Text LIKE '%problem%' OR c.Text LIKE '%wrong%' OR c.Text LIKE '%accuracy%'
    OR c.Text LIKE '%completeness%' OR c.Text LIKE '%precision%' OR c.Text LIKE '%exactness%' OR c.Text LIKE '%validity%' OR c.Text LIKE '%authority%'
    OR c.Text LIKE '%reliability%' OR c.Text LIKE '%perfection%' OR c.Text LIKE '%faithfulness%' OR c.Text LIKE '%closeness%' OR c.Text LIKE '%truth%'
    OR c.Text LIKE '%truthfulness%' OR c.Text LIKE '%authenticity%' OR c.Text LIKE '%realism%' OR c.Text LIKE '%fairness%' OR c.Text LIKE '%rigour%'
    OR c.Text LIKE '%defense%' OR c.Text LIKE '%shielding%' OR c.Text LIKE '%shelter%' OR c.Text LIKE '%preservation%' OR c.Text LIKE '%conservation%'
    OR c.Text LIKE '%safe keeping%' OR c.Text LIKE '%safeguard%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%support%' OR c.Text LIKE '%providence%'
    OR c.Text LIKE '%dependability%' OR c.Text LIKE '%slow%' OR c.Text LIKE '%limit%' OR c.Text LIKE '%fast%' OR c.Text LIKE '%lock%' OR c.Text LIKE '%unhurried%'
    OR c.Text LIKE '%leisurely%' OR c.Text LIKE '%moderate%' OR c.Text LIKE '%deliberate%' OR c.Text LIKE '%steady%' OR c.Text LIKE '%slow moving%'
    OR c.Text LIKE '%time to complete a task%'
  )
ORDER BY
  c.CreationDate DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results