Use sum() in place of count() Try below: SELECT ccc_news . * , SUM(if(ccc_news_comments.id = ‘approved’, 1, 0)) AS comments FROM ccc_news LEFT JOIN ccc_news_comments ON ccc_news_comments.news_id = ccc_news.news_id WHERE `ccc_news`.`category` = ‘news_layer2’ AND `ccc_news`.`status` = ‘Active’ GROUP BY ccc_news.news_id ORDER BY ccc_news.set_order ASC LIMIT 20
Put your values into an array, and check if your item is in the array: if ([1, 2, 3, 4].includes(test.type)) { // Do something } If a browser you support doesn’t have the Array#includes method, you can use this polyfill. Short explanation of the ~ tilde shortcut: Update: Since we now have the includes method, … Read more
As the comments mentioned, Go doesn’t support ternary one liners. The shortest form I can think of is this: var c int if c = b; a > b { c = a } But please don’t do that, it’s not worth it and will only confuse people who read your code.
Your syntax is incorrect. You can’t use ELSE IF. It appears that you don’t really need it anyway. Simply use multiple IF statements: IF %F%==1 IF %C%==1 ( ::copying the file c to d copy “%sourceFile%” “%destinationFile%” ) IF %F%==1 IF %C%==0 ( ::moving the file c to d move “%sourceFile%” “%destinationFile%” ) IF %F%==0 … Read more
Thymeleaf has an equivalent to <c:choose> and <c:when>: the th:switch and th:case attributes introduced in Thymeleaf 2.0. They work as you’d expect, using * for the default case: <div th:switch=”${user.role}”> <p th:case=”‘admin'”>User is an administrator</p> <p th:case=”#{roles.manager}”>User is a manager</p> <p th:case=”*”>User is some other thing</p> </div> See this for a quick explanation of syntax … Read more
You could use np.where. If cond is a boolean array, and A and B are arrays, then C = np.where(cond, A, B) defines C to be equal to A where cond is True, and B where cond is False. import numpy as np import pandas as pd a = [[’10’, ‘1.2’, ‘4.2’], [’15’, ’70’, ‘0.03’], … Read more
Update for Swift 3: The following will work in Swift 3: if let latitudeDouble = latitude as? Double, let longitudeDouble = longitude as? Double { // latitudeDouble and longitudeDouble are non-optional in here } Just be sure to remember that if one of the attempted optional bindings fail, the code inside the if-let block won’t … Read more
The problem with the first version is that if you go back and add a second statement to the if or else clauses without remembering to add the curly braces, your code will break in unexpected and amusing ways. Maintainability-wise, it’s always smarter to use the second form. EDIT: Ned points this out in the … Read more
You’re asking a question about numeric comparisons, so regular expressions really have nothing to do with the issue. You don’t need “multiple if” statements to do it, either: if (x >= 0.001 && x <= 0.009) { // something } You could write yourself a “between()” function: function between(x, min, max) { return x >= … Read more
The answer below was written years ago and updated over time. As of C# 7, you can use pattern matching: if (animal is Dog dog) { // Use dog here } Note that dog is still in scope after the if statement, but isn’t definitely assigned. No, there isn’t. It’s more idiomatic to write this … Read more