Women

select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='195' and t2.catparent_id='196' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='195' and t2.catparent_id='197' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='195' and t2.catparent_id='223' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='195' and t2.catparent_id='217' ORDER BY t1.prdtcat_name ASC BACK TO TOP

Men

select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='236' and t2.catparent_id='237' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='236' and t2.catparent_id='248' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='236' and t2.catparent_id='258' ORDER BY t1.prdtcat_name ASC BACK TO TOP

Kids

select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='516' and t2.catparent_id='517' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='516' and t2.catparent_id='528' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='516' and t2.catparent_id='555' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='516' and t2.catparent_id='540' ORDER BY t1.prdtcat_name ASC BACK TO TOP

Sports & Leisure

select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='360' and t2.catparent_id='390' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='360' and t2.catparent_id='422' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='360' and t2.catparent_id='361' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='360' and t2.catparent_id='411' ORDER BY t1.prdtcat_name ASC BACK TO TOP

Technology

select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='318' and t2.catparent_id='330' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='318' and t2.catparent_id='633' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='318' and t2.catparent_id='631' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='318' and t2.catparent_id='319' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='318' and t2.catparent_id='348' ORDER BY t1.prdtcat_name ASC BACK TO TOP

Holiday & Travel

select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='500' and t2.catparent_id='506' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='500' and t2.catparent_id='501' ORDER BY t1.prdtcat_name ASC BACK TO TOP

Home & Garden

select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='276' and t2.catparent_id='280' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='276' and t2.catparent_id='294' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='276' and t2.catparent_id='277' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='276' and t2.catparent_id='304' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='276' and t2.catparent_id='285' ORDER BY t1.prdtcat_name ASC BACK TO TOP

Health & Beauty

select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='433' and t2.catparent_id='449' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='433' and t2.catparent_id='468' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='433' and t2.catparent_id='434' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='433' and t2.catparent_id='442' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='433' and t2.catparent_id='492' ORDER BY t1.prdtcat_name ASC BACK TO TOP

Online Services

select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='567' and t2.catparent_id='568' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='567' and t2.catparent_id='654' ORDER BY t1.prdtcat_name ASC BACK TO TOP

Gifts & Occasions

select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='643' and t2.catparent_id='662' ORDER BY t1.prdtcat_name ASC select SQL_CALC_FOUND_ROWS DISTINCT t1.prdtcat_id, t1.prdtcat_name , (SELECT count(cp.prdt_id) as product_count FROM sl_product as cp JOIN sl_onlinestores str ON str.store_id=cp.store_id and str.disable_store=0 JOIN sl_prdtcategory ctp ON ctp.prdtcat_id=cp.cat_id WHERE cp.deleted=0 and cp.subcat_id=t1.prdtcat_id) as product_count , t1.prdtcat_description, t2.topparent_id FROM sl_prdtcategory t1 LEFT JOIN sl_prdtcategory_level t2 ON ( t1.prdtcat_id = t2.prdtcat_id ) WHERE t2.catlevel_id IS NOT NULL and t2.topparent_id='643' and t2.catparent_id='644' ORDER BY t1.prdtcat_name ASC BACK TO TOP