Skip to content

How obtain a list of posts by category?

I have a MySQL table that associates articles with categories. Table “posts_categories”: postId – catId 178 4 177 4 176 4 175 4 174 4 171 4 170 4 169 4 168 4 167 4 166 4 165 4 164 4 163 4 …

Slow sql statement when using variables

I have the following SQL statement running against a MariaDB 10.1.26 with ~2.000 rows with instant results. When I use the following statement with variables for the datetime fields, the execution takes ~5.5 seconds. The more data rows I have, the longer it takes to execute the statement. Seems like the varia…

sql group by – curse and blessing

I have 3 tables for a meal calculation. Now I like to find a meal by ingredient: Which give me a list like: Also I like to find meal by price like: Which give me a list like: Now let me build a query like Which gives me a list like: Because (i.price / i.minamount * r.quanitity) for this meal

Laravel Eloquent version of “NOT IN” SQL

Just need the Eloquent ORM format of this query.. giving a headache for a while. Answer You Can Try this. First you Can Select all Player IDs. $player_ids = TeamRequest::select(‘player_id’)->get(); Then you can find Players Player::whereNotIn(‘user_id’, $player_ids)->get();