php – WordPress permalink, show a product catagory page on a normal WP page

I’m not sure if I’m having a bad brain day but I am going round in circles with something I know is so simple. As a note, I am pretty new to developing in WordPress so apologies if it genuinely is something so simple.

Essentially I am needing to have a page (example.com/gear) show the exact same page as the category page for gear (example.com/product_catagory/gear).

Is there a way for the permalink to show the product category page without changing the permalink? Would it be better practice to use something like is_page( ‘gear’ ); and then create a partial to show category products? Or is there something so much simpler than I can look into using?

I am not wanting to change the permalinks for product_catagoy I just want a new page to show a product category page (gear).

Thanks for your help

Eric

mysql 5.7 – Getting catagory title total number of questions and answers order by number of questions

I have three tables. Which is in at this fiddle,
http://sqlfiddle.com/#!9/46dfd6

Which is like this?.

CREATE TABLE `user_answers` (
  `id` int(250) NOT NULL,
  `question_id` varchar(250) NOT NULL,
  `user_id` int(250) NOT NULL,
  `answer` text NOT NULL,
  `date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `user_questions` (
  `id` varchar(250) NOT NULL,
  `user_id` int(250) NOT NULL,
  `note_id` int(250) NOT NULL,
  `title` text NOT NULL,
  `question` text NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `material_univarcity_list` (
  `id` int(100) NOT NULL,
  `name` varchar(50) NOT NULL,
  `about` mediumtext NOT NULL,
  `date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

I want to get a resultant table which has count – Name(Name is from material_univarcity_list) Total number of questions to that particular name. Here id of material_univarcity_list table is the note_id of user_questions and I want total number of answers to that particular catagory here question_id is the id of user_questions. How can I do this?

My expected result is like

no|catagory        |number_of_questions |number_of_answers
 1|DBMS 5th sem ISE|            2       | 3

How can i do this?

product name with brand, first level, second level and third level catagory list

Hi I want to get list of all the sku along with its brand and its first level ,second and third level category…
eg

fashion, topwear, jacket, denim, blue jacket(name), levis.