I trying to create a filter output of images by joining five tables. I need the five tables joined because of my where statements. My sql is the following: SELECT `files`.`id` AS `id`, `files`.`name` AS `name`, `files`.`size` AS `size`, `files`.`type`…
1st query; both tables contain all categories_ids SELECT * FROM categories c, categories_description cd WHERE c.categories_id = cd.categories_id ORDER BY sort_order, cd.categories_name 2nd query; this table maybe hold a categories_id SELECT count(*) AS total FROM products_to_categories WHERE categories_id = "'+…