|
| Products meeting the search criteria |
 |
|
 |
1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%high%' or pd.products_subname like '%high%' or p.products_ref like '%high%' or p.products_ref2 like '%high%' or p.products_model like '%high%' or m.manufacturers_name like '%high%') and (pd.products_name like '%balance%' or pd.products_subname like '%balance%' or p.products_ref like '%balance%' or p.products_ref2 like '%balance%' or p.products_model like '%balance%' or m.manufacturers_name like '%balance%') and (pd.products_name like '%fullz,%' or pd.products_subname like '%fullz,%' or p.products_ref like '%fullz,%' or p.products_ref2 like '%fullz,%' or p.products_model like '%fullz,%' or m.manufacturers_name like '%fullz,%') and (pd.products_name like '%【%' or pd.products_subname like '%【%' or p.products_ref like '%【%' or p.products_ref2 like '%【%' or p.products_model like '%【%' or m.manufacturers_name like '%【%') and (pd.products_name like '%visit%' or pd.products_subname like '%visit%' or p.products_ref like '%visit%' or p.products_ref2 like '%visit%' or p.products_model like '%visit%' or m.manufacturers_name like '%visit%') and (pd.products_name like '%amsiga.com%' or pd.products_subname like '%amsiga.com%' or p.products_ref like '%amsiga.com%' or p.products_ref2 like '%amsiga.com%' or p.products_model like '%amsiga.com%' or m.manufacturers_name like '%amsiga.com%') and (pd.products_name like '%】%' or pd.products_subname like '%】%' or p.products_ref like '%】%' or p.products_ref2 like '%】%' or p.products_model like '%】%' or m.manufacturers_name like '%】%') and (pd.products_name like '%ojm3t5p,%' or pd.products_subname like '%ojm3t5p,%' or p.products_ref like '%ojm3t5p,%' or p.products_ref2 like '%ojm3t5p,%' or p.products_model like '%ojm3t5p,%' or m.manufacturers_name like '%ojm3t5p,%') and (pd.products_name like '%buy%' or pd.products_subname like '%buy%' or p.products_ref like '%buy%' or p.products_ref2 like '%buy%' or p.products_model like '%buy%' or m.manufacturers_name like '%buy%') and (pd.products_name like '%cvv2,%' or pd.products_subname like '%cvv2,%' or p.products_ref like '%cvv2,%' or p.products_ref2 like '%cvv2,%' or p.products_model like '%cvv2,%' or m.manufacturers_name like '%cvv2,%') and (pd.products_name like '%business%' or pd.products_subname like '%business%' or p.products_ref like '%business%' or p.products_ref2 like '%business%' or p.products_model like '%business%' or m.manufacturers_name like '%business%') and (pd.products_name like '%fullz,%' or pd.products_subname like '%fullz,%' or p.products_ref like '%fullz,%' or p.products_ref2 like '%fullz,%' or p.products_model like '%fullz,%' or m.manufacturers_name like '%fullz,%') and (pd.products_name like '%ubl%' or pd.products_subname like '%ubl%' or p.products_ref like '%ubl%' or p.products_ref2 like '%ubl%' or p.products_model like '%ubl%' or m.manufacturers_name like '%ubl%') and (pd.products_name like '%cvv%' or pd.products_subname like '%cvv%' or p.products_ref like '%cvv%' or p.products_ref2 like '%cvv%' or p.products_model like '%cvv%' or m.manufacturers_name like '%cvv%') and (pd.products_name like '%number%' or pd.products_subname like '%number%' or p.products_ref like '%number%' or p.products_ref2 like '%number%' or p.products_model like '%number%' or m.manufacturers_name like '%number%') and (pd.products_name like '%fp01%' or pd.products_subname like '%fp01%' or p.products_ref like '%fp01%' or p.products_ref2 like '%fp01%' or p.products_model like '%fp01%' or m.manufacturers_name like '%fp01%') )
[TEP STOP]
| |
