SELECT `i`.`name` AS `ingredient`, `ri`.`amount`, `u`.`name` AS `units`,
`ri`.`amount` * `g`.`weight` AS `grams`
FROM `recipe_ingredients` AS `ri`
JOIN `ingredients` AS `i` ON `i`.`id` = `ri`.`ingredient_id`
JOIN `units` AS `u` ON `u`.`id` = `ri`.`units_id`
LEFT JOIN `gram_per_unit` AS `g`
ON `g`.`ingredient_id` = `i`.`ingredient_id`
AND `g`.`units_id` = `i`.`units_id`
WHERE `ri`.`recipe_id` = :recipeId<source_ip>209.85.208.199</source_ip>
...
<dkim>fail</dkim>
<spf>fail</spf>
dig txt _dmarc.adlab.ee
_dmarc.adlab.ee. 300 IN TXT "v=DMARC1; p=reject; aspf=s; adkim=r; pct=100; sp=reject; rua=mailto:info@adlab.ee"dig txt adlab.ee
adlab.ee. 300 IN TXT "v=spf1 redirect=_spf.yandex.net"SELECT ...
FROM `orders` AS `o`
LEFT JOIN `users` AS `u`
ON `u`.`id` = `o`.`user_id`
LEFT JOIN (
SELECT `order_id`, MAX(`updated_at`) AS `updated_at`
FROM `order_status`
GROUP BY `order_id`
) AS `ls`
ON `ls`.`order_id` = `o`.`id`
LEFT JOIN `order_status` AS `os`
ON `os`.`order_id` = `o`.`id` AND `os`.`updated_at` = `ls`.`updated_at`
LEFT JOIN `statuses` AS `s`
ON `s`.`id` = `os`.`status_id`