A Database Error Occurred
Error Number: 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 'GROUP BY cam_id ORDER BY nb_tof_model DESC LIMIT 0 , 6' at line 1
SELECT cam_id, brand_name,brand_name_clean, cam_model, prop_images, count( foto_id ) AS nb_tof_model FROM photo RIGHT JOIN camera ON fotex_model_id = cam_id RIGHT JOIN n_item_index ON cam_id = item_oldid RIGHT JOIN n_item_props ON prop = item_id RIGHT JOIN brand ON cam_brand = brand_id WHERE foto_flag =1 AND cam_flag=1 AND item_type=2 AND cam_brand = GROUP BY cam_id ORDER BY nb_tof_model DESC LIMIT 0 , 6
Filename: /homepages/12/d314043625/htdocs/pxthngV2/models/mod_camera.php
Line Number: 99