select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '0' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '135' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '34' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '137' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '36' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '35' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '37' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '82' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '106' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '107' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '83' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '98' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '158' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '159' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '99' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '100' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '145' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '146' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '95' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '167' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '168' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '43' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '44' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '51' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '113' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '114' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '115' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '27' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '122' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '123' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '28' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '85' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '132' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '133' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '86' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '31' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '138' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '139' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '172' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '173' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '111' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '112' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '153' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '154' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '84' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '104' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '136' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '105' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '119' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '118' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '32' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '124' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '78' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '79' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '25' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '26' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '52' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '53' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '162' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '163' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '29' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '30' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '120' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '121' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '56' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '57' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '184' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '185' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '58' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '59' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '49' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '50' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '71' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '72' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '16' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '97' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '22' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '116' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '186' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '117' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '180' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '181' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '75' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '76' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '77' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '160' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '161' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '178' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '66' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '179' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '17' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '68' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '190' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '69' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '67' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '143' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '144' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '38' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '41' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '45' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '46' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '80' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '81' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '73' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '74' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '182' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '169' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '170' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '187' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '189' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '188' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '54' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '55' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '89' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '90' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '91' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '93' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '92' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '101' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '103' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '102' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '47' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '48' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '166' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '165' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '23' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '24' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '147' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '157' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '94' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '171' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '110' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '156' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '70' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '62' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '109' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '174' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '151' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '96' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '61' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '134' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '127' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '108' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '63' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '128' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '175' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '64' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '65' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '125' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '148' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '126' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '129' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '183' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '130' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '131' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '155' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '164' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '152' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '149' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '150' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '20' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '21' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '87' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '88' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '142' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '176' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '177' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_nameselect c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '40' and c.categories_id = cd.categories_id and c.categories_status != 0 and cd.language_id = '2' order by sort_order, cd.categories_name