SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=81andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=81andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=90andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=90andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=1294andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=1294andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=89andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=89andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=86andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=86andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=1323andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=1323andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=356andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=356andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=1157andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=1157andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=88andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=88andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=1156andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=1156andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=93andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=93andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=92andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=92andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=357andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=357andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=87andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=87andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=?andk.active=1andk.show_category=1UNION ALL
(
SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=?andc1.active=1andc2.show_category=1
)
ORDER BYcategory_name
SELECTk.idAScategory_id,k.category_name,k.category_name_seo,k.category_name_aim,k.category_imageFROMkategorijekWHEREk.parent_category_id=386andk.active=1andk.show_category=1UNION ALL
(SELECTc1.category_id,c2.category_name,c2.category_name_seo,c2.category_name_aim,c2.category_imageFROMkategorije_vezec1,kategorijec2WHEREc1.category_id=c2.idandc1.parent_category_id=386andc1.active=1andc2.show_category=1)
ORDER BYcategory_name;