Home > Dahua IPC-HDBW1320E POE 3MP IR Network Mini Dome Camera(Replace IPC-HDBW4300E)

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')order by products_quantity desc' at line 1

select count(distinct p.products_id) as total from ((products p) , products_description pd) left join specials s on p.products_id = s.products_id, 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 '%dahua%' or p.products_model like '%dahua%' or pd.products_head_keywords_tag like '%dahua%' ) and (pd.products_name like '%ipc-hdbw1320e%' or p.products_model like '%ipc-hdbw1320e%' or pd.products_head_keywords_tag like '%ipc-hdbw1320e%' ) and (pd.products_name like '%poe%' or p.products_model like '%poe%' or pd.products_head_keywords_tag like '%poe%' ) and (pd.products_name like '%3mp%' or p.products_model like '%3mp%' or pd.products_head_keywords_tag like '%3mp%' ) and (pd.products_name like '%ir%' or p.products_model like '%ir%' or pd.products_head_keywords_tag like '%ir%' ) and (pd.products_name like '%network%' or p.products_model like '%network%' or pd.products_head_keywords_tag like '%network%' ) and (pd.products_name like '%mini%' or p.products_model like '%mini%' or pd.products_head_keywords_tag like '%mini%' ) and (pd.products_name like '%dome%' or p.products_model like '%dome%' or pd.products_head_keywords_tag like '%dome%' ) and (pd.products_name like '%camera(replace%' or p.products_model like '%camera(replace%' or pd.products_head_keywords_tag like '%camera(replace%' ) and (pd.products_name like '%ipc-hdbw4300e%' or p.products_model like '%ipc-hdbw4300e%' or pd.products_head_keywords_tag like '%ipc-hdbw4300e%' ) ) )order by products_quantity desc

[TEP STOP]