Answer the question
In order to leave comments, you need to log in
Why does Safari think the style attribute has no properties?
The same code (in which I even specially copied all the background properties for each modifier, thinking that it would work in safari) works in chrome and does not work in safari
What needs to be done to make it work in Safari?
Answer the question
In order to leave comments, you need to log in
If any of these authors
If all three then
SELECT `p1`.`post_id`
FROM `posts` AS `p1`
JOIN `posts` AS `p2`
ON `p2`.`post_id` = `p1`.`post_id` AND `p2`.`author_id` = :id2
JOIN `posts` AS `p3`
ON `p3`.`post_id` = `p1`.`post_id` AND `p3`.`author_id` = :id3
WHERE `p1`.`author_id` = :id1
You can try like this:
select a.* from posts a
inner join (
select *, count (*) as cnt from post_author
where author_id in (1,2,3)
group by podt_id
having cnt = 3
) b on a.id = b.post_id
SELECT * FROM post p
WHERE p.id IN (SELECT post_id FROM post_author WHERE author_id IN (1,2,3))
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question