select prod_id,company_price, prod_name, friendly_name, prod_cat_name, products.cat_id, prod_maincat_name,brand_name, sku, image_path, prod_shipping_cost, products.date_added, price, avail_status , products.sort_order , prod_desc, upper(products.is_active) is_active, upper(products.is_featured) is_featured, pc.prod_cat_friendly_name , prod_maincat_friendly_name, product_rating, product_rating_count, product_dimention_units , default_qty, products.quantity_in_stock, is_offer, offer_discount_percent, offer_start_date, offer_end_date, if ( products.offer_start_date <= now() , if( products.offer_end_date >= now() , 1, 0 ) , 0 ) is_valid_offer, is_offer_active, get_prod_mrp( prod_id ) prod_mrp from product_categories pc, product_maincategories pmc , products left join product_brands pb on products.brand_id = pb.brand_id where products.cat_id = pc.prod_cat_id and avail_status = 1 and upper(products.is_active) = 'Y' and pc.pc_maincat_id = pmc.prod_maincat_id and pc.is_active = 'Y' and price > 0 and pmc.prod_maincat_is_active = 'Y' AND ( pc.prod_cat_friendly_name = 'hydrart' or pc.prod_cat_name = 'hydrart' ) AND ( pc.prod_cat_friendly_name = 'hydrart' or pc.prod_cat_name = 'hydrart' ) and pmc.prod_maincat_friendly_name = 'exhibitions' order by prod_subcat_id, cat_id, main_cat_id
1a

1a

Rs. 9,350.00
Aeonian continuing forever

Aeonian Continuing Forever

Rs. 9,650.00
2A

2a

Rs. 7,800.00
Phlegethon stream of fire

Phlegethon Stream Of Fire

Rs. 9,850.00
20

20

Rs. 7,600.00
Bebak bold

Bebak Bold

Rs. 8,850.00
22

22

Rs. 8,100.00
Vad unregulated

Vad Unregulated

Rs. 9,550.00
apricity

Apricity

Rs. 12,450.00
Dern secret or hidden

Dern Secret Or Hidden

Rs. 11,500.00
photo 7

Photo 7

Rs. 7,450.00
Croquis sketch

Croquis Sketch

Rs. 7,800.00
photo 8

Photo 8

Rs. 7,950.00
Tulua rising

Tulua Rising

Rs. 7,650.00
photo9

Photo9

Rs. 7,100.00
photo10

Photo10

Rs. 7,700.00
photo11

Photo11

Rs. 8,350.00
order-13

Order-13

Rs. 8,800.00
order-14

Order-14

Rs. 8,350.00
order-15

Order-15

Rs. 9,450.00
order-17

Order-17

Rs. 7,700.00
order-19

Order-19

Rs. 8,700.00