But worked with IN and it don't made the search correctly.
When I click in filter tag it shows me all products with tags selected, and
not the products with the combined tags.
Example:
Product 1 - tags: mom - child - birthday
Product 2 - tags: mom - adult - party
Product 3 - tags: mom - child - party
If I select the tags mom and child, it shows me all products, when should
show me only products 1 and 3.
Em segunda-feira, 9 de março de 2015 18:37:11 UTC-3, José Lorenzo escreveu:
>
> If you execute the SQL above you will always get 0 results.
>
> I think that what cake does by default (using IN) is exactly the thing you
> want, based on what you described (your hesitance on using UNION queries to
> get all results)
>
> On Monday, March 9, 2015 at 8:54:09 PM UTC+1, michel martins wrote:
>>
>> I need for all products that have tag_id = array item
>>
>> SELECT * FROM produtos AS Produtos LEFT JOIN tags_produtos as
>> TagsProdutos ON Produtos.id = TagsProdutos.produto_id WHERE
>> TagsProdutos.tag_id = 730 AND TagsProdutos.tag_id = 731 AND
>> TagsProdutos.tag_id = 735
>>
>> I have doubts whether I do the sql above or use UNION between multiple
>> queries.
>>
>> Table PRODUTOS
>> ID - PRODUTO
>>
>> Table TAGS_PRODUTOS
>> ID - PRODUTO_ID - TAG_ID
>>
>> Table TAGS
>> ID - NAME
>>
>> $tags = array('0'=>'730', '1'=>'731', '2'=>'735')
>>
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
