Total Products are : 10
Total Products on Page are : 10

SQL QUERY:
select `p`.*, `pd`.*, `pm`.* from `product` as `p` inner join `product_description` as `pd` on `pd`.`product_id` = `p`.`product_id` inner join `product_option_images` as `pm` on `pm`.`product_id` = `p`.`product_id` inner join `options_value` as `ov` on `ov`.`option_val_id` = `pm`.`option_1` inner join `product_to_category` as `pc` on `pc`.`product_id` = `p`.`product_id` where `pc`.`category_id` = 4 and `p`.`status` = 1 and `p`.`price` != 0 group by `pd`.`name`

For Girls : `pc`.`category_id` = 29
For Boys : `pc`.`category_id` = 27
For Men : `pc`.`category_id` = 4
For Women : `pc`.`category_id` = 1