Change currency :
INR Rs.
For Customer service INDIA call +919351288910
  • Shopping Bag is Empty

Classic Look Partywear Mens Tuxedo Suit

Classic Look Partywear Mens Tuxedo Suit

Itemcode :TX176
Classic look partywear mens tuxedo suit made from white color polyester fabric. Sold as a "Suits" with a 6" drop (ie. 42R Long Jacket comes with 36 Waist trouser). All sizes shown are US sizes. Price increases with large size. All Accessories shown are included in the price except shoes and watches. No extra cost for normal size For large size 15% to 25% to extra cost will be charged. Made in India. Dryclean only.
Note
Occasion
Fabric
Select to change Fabric:
 
 
Select to change Color/Fabric:
Price in INR :
Quantity :
 
Get it tailor made / Custom made :
Or
Buy in standard size :
We follow USA sizes. Check Size Chart to avoid errors.
Shipping in india Shipping outside india
Shipping Time :
Normal shipping days :
15 Calendar days
Item weight :
2.00
Viewed :
787 Times
 
 
(default) 61 queries took 1416 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `items`56566
2DESCRIBE `itemslngs`8820
3DESCRIBE `maincategories`15157
4DESCRIBE `addtowishlists`776
5DESCRIBE `sizeavailables`14147
6DESCRIBE `itemsettings`353511
7DESCRIBE `subcategories`232312
8DESCRIBE `companydetails`17177
9SELECT `Companydetail`.`id`, `Companydetail`.`companyname`, `Companydetail`.`contactperson`, `Companydetail`.`add1`, `Companydetail`.`add2`, `Companydetail`.`city`, `Companydetail`.`state`, `Companydetail`.`country`, `Companydetail`.`zip`, `Companydetail`.`phone`, `Companydetail`.`cell`, `Companydetail`.`fax`, `Companydetail`.`email`, `Companydetail`.`web`, `Companydetail`.`prdimaage`, `Companydetail`.`prdpagelink`, `Companydetail`.`exportrefno` FROM `companydetails` AS `Companydetail` WHERE 1 = 1 110
10SELECT `Item`.`id`, `Item`.`maincategory_id`, `Item`.`category_id`, `Item`.`subcategory_id`, `Item`.`itemcode`, `Item`.`itemname`, `Item`.`itemweight`, `Item`.`shippingdays`, `Item`.`transitdays`, `Item`.`vivedcount`, `Item`.`newitem`, `Item`.`hotitem`, `Item`.`spitem`, `Item`.`expsell`, `Item`.`featured`, `Item`.`bestsell`, `Item`.`price`, `Item`.`baseprice`, `Item`.`discount`, `Item`.`basediscount`, `Item`.`lastprice`, `Item`.`baselastprice`, `Item`.`shippingcost`, `Item`.`baseshippingcost`, `Item`.`removed`, `Item`.`gorder`, `Item`.`smalling`, `Item`.`bigimg`, `Item`.`largimg`, `Item`.`measurmentin`, `Item`.`figration`, `Item`.`istand`, `Item`.`servanifeatures`, `Item`.`jacketfeatures`, `Item`.`trouserfeatures`, `Item`.`secondpairtrousers`, `Item`.`indowesternfeatures`, `Item`.`blazerfeatures`, `Item`.`fabricid`, `Item`.`blousefeatures`, `Item`.`blousesleevefeatures`, `Item`.`neckfeatures`, `Item`.`lehengafeatures`, `Item`.`blouseopeningfeatures`, `Item`.`disableblouse`, `Item`.`disablelehenga`, `Item`.`disablejacket`, `Item`.`disabletourser`, `Item`.`disablesharwani`, `Item`.`disableindowestern`, `Item`.`itemtimes`, `Item`.`dissapprove`, `Item`.`disableblazer`, `Item`.`fabrictype`, `Item`.`salwar`, `Item`.`kammez`, `Itemslng`.`item_id`, `Itemslng`.`lngid`, `Itemslng`.`itemname`, `Itemslng`.`itemnote`, `Itemslng`.`itemdesc`, `Itemslng`.`itemterms`, `Itemslng`.`ensuteproperfitdesc`, `Itemslng`.`slug_itemname` FROM `items` AS `Item` LEFT JOIN `itemslngs` AS `Itemslng` ON (`Itemslng`.`item_id` = `Item`.`id`) WHERE `removed` = 'N' AND `dissapprove` = 'Y' AND `Item`.`id` = 610 AND `lngid` = '1' 119
11select id from itemsettings where id='610'117
12SELECT `Itemsetting`.`id`, `Itemsetting`.`sweight`, `Itemsetting`.`sprice`, `Itemsetting`.`sdiscount`, `Itemsetting`.`sshpcost`, `Itemsetting`.`stags`, `Itemsetting`.`scolor`, `Itemsetting`.`smaterial`, `Itemsetting`.`sfabric`, `Itemsetting`.`soccession`, `Itemsetting`.`susetags`, `Itemsetting`.`sredimadesize`, `Itemsetting`.`saccessory`, `Itemsetting`.`srelproduct`, `Itemsetting`.`sshpdays`, `Itemsetting`.`smasermenttag`, `Itemsetting`.`sdiscription`, `Itemsetting`.`snote`, `Itemsetting`.`stermscondition`, `Itemsetting`.`sensureproperfit`, `Itemsetting`.`quantity`, `Itemsetting`.`buystandredsize`, `Itemsetting`.`customsize`, `Itemsetting`.`visitview`, `Itemsetting`.`sendrofriend`, `Itemsetting`.`productenquery`, `Itemsetting`.`wishlist`, `Itemsetting`.`testimonal`, `Itemsetting`.`odob`, `Itemsetting`.`shoppingcart`, `Itemsetting`.`oquantity`, `Itemsetting`.`ofabric`, `Itemsetting`.`ocolor`, `Itemsetting`.`osize`, `Itemsetting`.`oheightin` FROM `itemsettings` AS `Itemsetting` WHERE `id` = 610 115
13update items set vivedcount=vivedcount+1 where id='610'11
14SELECT `Item`.`id`, `Item`.`maincategory_id`, `Item`.`category_id`, `Item`.`subcategory_id`, `Item`.`itemcode`, `Item`.`itemname`, `Item`.`itemweight`, `Item`.`shippingdays`, `Item`.`transitdays`, `Item`.`vivedcount`, `Item`.`newitem`, `Item`.`hotitem`, `Item`.`spitem`, `Item`.`expsell`, `Item`.`featured`, `Item`.`bestsell`, `Item`.`price`, `Item`.`baseprice`, `Item`.`discount`, `Item`.`basediscount`, `Item`.`lastprice`, `Item`.`baselastprice`, `Item`.`shippingcost`, `Item`.`baseshippingcost`, `Item`.`removed`, `Item`.`gorder`, `Item`.`smalling`, `Item`.`bigimg`, `Item`.`largimg`, `Item`.`measurmentin`, `Item`.`figration`, `Item`.`istand`, `Item`.`servanifeatures`, `Item`.`jacketfeatures`, `Item`.`trouserfeatures`, `Item`.`secondpairtrousers`, `Item`.`indowesternfeatures`, `Item`.`blazerfeatures`, `Item`.`fabricid`, `Item`.`blousefeatures`, `Item`.`blousesleevefeatures`, `Item`.`neckfeatures`, `Item`.`lehengafeatures`, `Item`.`blouseopeningfeatures`, `Item`.`disableblouse`, `Item`.`disablelehenga`, `Item`.`disablejacket`, `Item`.`disabletourser`, `Item`.`disablesharwani`, `Item`.`disableindowestern`, `Item`.`itemtimes`, `Item`.`dissapprove`, `Item`.`disableblazer`, `Item`.`fabrictype`, `Item`.`salwar`, `Item`.`kammez`, `Itemslng`.`item_id`, `Itemslng`.`lngid`, `Itemslng`.`itemname`, `Itemslng`.`itemnote`, `Itemslng`.`itemdesc`, `Itemslng`.`itemterms`, `Itemslng`.`ensuteproperfitdesc`, `Itemslng`.`slug_itemname` FROM `items` AS `Item` LEFT JOIN `itemslngs` AS `Itemslng` ON (`Itemslng`.`item_id` = `Item`.`id`) WHERE `removed` = 'N' AND `dissapprove` = 'Y' AND `Item`.`id` = 610 AND `lngid` = '1' 112
15SELECT `Item`.`id`, `Item`.`itemcode`, `Item`.`itemname`, `Item`.`smalling`, `Item`.`lastprice`, `Itemslng`.`slug_itemname` FROM `items` AS `Item` LEFT JOIN `itemslngs` AS `Itemslng` ON (`Itemslng`.`item_id` = `Item`.`id`) WHERE `Item`.`category_id` = 27 AND `Item`.`removed` = 'N' AND `Item`.`dissapprove` = 'Y' 49049050
16SELECT DISTINCT `Item`.`id`, `Item`.`itemname`, `Item`.`fabricid`, `Itemslng`.`slug_itemname` FROM `items` AS `Item` LEFT JOIN `itemslngs` AS `Itemslng` ON (`Itemslng`.`item_id` = `Item`.`id`) WHERE `removed` = 'N' AND `dissapprove` = 'Y' AND `Item`.`id` > 610 AND `lngid` = '1' AND `maincategory_id` = 6 AND `category_id` = 27 AND `subcategory_id` = 0 ORDER BY `Item`.`id` asc, `Item`.`itemcode` desc LIMIT 111175
17SELECT DISTINCT `Item`.`id`, `Item`.`itemname`, `Itemslng`.`slug_itemname` FROM `items` AS `Item` LEFT JOIN `itemslngs` AS `Itemslng` ON (`Itemslng`.`item_id` = `Item`.`id`) WHERE `removed` = 'N' AND `dissapprove` = 'Y' AND `Item`.`id` < 610 AND `lngid` = '1' AND `maincategory_id` = 6 AND `category_id` = 27 AND `subcategory_id` = 0 ORDER BY `Item`.`id` desc, `Item`.`itemcode` ASC LIMIT 11134
18DESCRIBE `itemcolors`991
19SELECT `Itemcolor`.`colorimg`, `Itemcolor`.`xname`, `Itemcolor`.`id`, `Itemcolor`.`code`, `Itemcolor`.`removed`, `Itemcolor`.`itemid`, `Itemcolor`.`colorsmall`, `Itemcolor`.`colortiny`, `Itemcolor`.`lngid` FROM `itemcolors` AS `Itemcolor` WHERE removed='N' and itemid='610' and lngid='1' order by id desc 002
20DESCRIBE `productsmartshops`221
21SELECT DISTINCT `Productsmartshop`.`colorid` FROM `productsmartshops` AS `Productsmartshop` WHERE `itemid` = 610 115
22DESCRIBE `itemfebrics`7712
23SELECT `Itemfebric`.`febprice`, `Itemfebric`.`basefebprice`, `Itemfebric`.`xname`, `Itemfebric`.`id`, `Itemfebric`.`itemid`, `Itemfebric`.`removed`, `Itemfebric`.`lngid` FROM `itemfebrics` AS `Itemfebric` WHERE removed='N' and itemid='610' and lngid='1' order by id desc 110
24DESCRIBE `itemoccasions`551
25SELECT `Itemoccasion`.`id`, `Itemoccasion`.`xname`, `Itemoccasion`.`removed`, `Itemoccasion`.`lngid`, `Itemoccasion`.`itemid` FROM `itemoccasions` AS `Itemoccasion` WHERE removed='N' and itemid='610' and lngid='1' order by id desc 551
26DESCRIBE `itemspecialtags`554
27SELECT `Itemspecialtag`.`xname`, `Itemspecialtag`.`id`, `Itemspecialtag`.`lngid`, `Itemspecialtag`.`removed`, `Itemspecialtag`.`itemid` FROM `itemspecialtags` AS `Itemspecialtag` WHERE removed='N' and itemid='610' and lngid='1' order by id desc 000
28DESCRIBE `accessories`881
29SELECT `Accessory`.`id`, `Accessory`.`accrcode`, `Accessory`.`defaultqty`, `Accessory`.`inputdefprice`, `Accessory`.`defprice`, `Accessory`.`spicalacc` FROM `accessories` AS `Accessory` INNER JOIN productassries as Productassry ON Productassry.assr_id = Accessory.id WHERE `Productassry`.`item_id` = '610' 007
30DESCRIBE `itemsmeasurmenttags`883
31SELECT `Itemsmeasurmenttag`.`xname`, `Itemsmeasurmenttag`.`mtagdesc`, `Itemsmeasurmenttag`.`id`, `Itemsmeasurmenttag`.`mesimage`, `Itemsmeasurmenttag`.`lngid`, `Itemsmeasurmenttag`.`removed`, `Itemsmeasurmenttag`.`itemid`, `Itemsmeasurmenttag`.`gorder` FROM `itemsmeasurmenttags` AS `Itemsmeasurmenttag` WHERE removed='N' and itemid='610' and lngid='1' order by id desc 12121009
32DESCRIBE `itemmaterials`551
33SELECT `Itemmaterial`.`id`, `Itemmaterial`.`xname`, `Itemmaterial`.`removed`, `Itemmaterial`.`lngid`, `Itemmaterial`.`itemid` FROM `itemmaterials` AS `Itemmaterial` WHERE removed='N' and itemid='610' and lngid='1' order by id desc 001
34DESCRIBE `itemreadymadesizes`551
35SELECT `Itemreadymadesize`.`SizeId`, `Itemreadymadesize`.`sizename` FROM `itemreadymadesizes` AS `Itemreadymadesize` WHERE `ItemId` = 610 52521
36DESCRIBE `shippingitems`771
37SELECT `Shippingitem`.`ItemId`, `Shippingitem`.`ShipingId`, `Shippingitem`.`shpingdays`, `Shippingitem`.`shipingstr`, `Shippingitem`.`expshipping`, `Shippingitem`.`expprice`, `Shippingitem`.`strname` FROM `shippingitems` AS `Shippingitem` WHERE `ItemId` = 610 881
38SELECT `Maincategory`.`id`, `Maincategory`.`maincatcode`, `Maincategory`.`maincatNamecode`, `Maincategory`.`removed`, `Maincategory`.`keywords`, `Maincategory`.`titledes`, `Maincategory`.`metades`, `Maincategory`.`maincatimg`, `Maincategory`.`childcatexist`, `Maincategory`.`maincatid`, `Maincategory`.`lngid`, `Maincategory`.`maincatname`, `Maincategory`.`maincatdesc`, `Maincategory`.`slug_maincatname`, `Maincategory`.`gorder` FROM `maincategories` AS `Maincategory` WHERE `lngid` = 1 AND `removed` = 'N' ORDER BY `id` ASC 770
39DESCRIBE `currencies`551
40SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`symbol`, `Currency`.`curr_val`, `Currency`.`in_usd` FROM `currencies` AS `Currency` WHERE 1 = 1 990
41SELECT `Maincategory`.`id`, `Maincategory`.`maincatcode`, `Maincategory`.`maincatNamecode`, `Maincategory`.`removed`, `Maincategory`.`keywords`, `Maincategory`.`titledes`, `Maincategory`.`metades`, `Maincategory`.`maincatimg`, `Maincategory`.`childcatexist`, `Maincategory`.`maincatid`, `Maincategory`.`lngid`, `Maincategory`.`maincatname`, `Maincategory`.`maincatdesc`, `Maincategory`.`slug_maincatname`, `Maincategory`.`gorder` FROM `maincategories` AS `Maincategory` WHERE `lngid` = 1 AND `removed` = 'N' ORDER BY `gorder` ASC LIMIT 7770
42DESCRIBE `categories`20201
43SELECT `Category`.`id`, `Category`.`childcatcode`, `Category`.`keywords`, `Category`.`titledes`, `Category`.`metades`, `Category`.`maincatid`, `Category`.`removed`, `Category`.`chcatimage`, `Category`.`subcatexist`, `Category`.`childcatid`, `Category`.`lngid`, `Category`.`lngid2`, `Category`.`childcatname`, `Category`.`slug_childcatname`, `Category`.`childcatdesc`, `Category`.`maincatcode`, `Category`.`maincatname`, `Category`.`slug_maincatname`, `Category`.`childcatcodeName`, `Category`.`maincatcodeName` FROM `categories` AS `Category` WHERE `lngid` = 1 AND `lngid2` = 1 AND `removed` = 'N' AND `maincatid` = 1 770
44SELECT `Category`.`id`, `Category`.`childcatcode`, `Category`.`keywords`, `Category`.`titledes`, `Category`.`metades`, `Category`.`maincatid`, `Category`.`removed`, `Category`.`chcatimage`, `Category`.`subcatexist`, `Category`.`childcatid`, `Category`.`lngid`, `Category`.`lngid2`, `Category`.`childcatname`, `Category`.`slug_childcatname`, `Category`.`childcatdesc`, `Category`.`maincatcode`, `Category`.`maincatname`, `Category`.`slug_maincatname`, `Category`.`childcatcodeName`, `Category`.`maincatcodeName` FROM `categories` AS `Category` WHERE `lngid` = 1 AND `lngid2` = 1 AND `removed` = 'N' AND `maincatid` = 3 440
45SELECT `Category`.`id`, `Category`.`childcatcode`, `Category`.`keywords`, `Category`.`titledes`, `Category`.`metades`, `Category`.`maincatid`, `Category`.`removed`, `Category`.`chcatimage`, `Category`.`subcatexist`, `Category`.`childcatid`, `Category`.`lngid`, `Category`.`lngid2`, `Category`.`childcatname`, `Category`.`slug_childcatname`, `Category`.`childcatdesc`, `Category`.`maincatcode`, `Category`.`maincatname`, `Category`.`slug_maincatname`, `Category`.`childcatcodeName`, `Category`.`maincatcodeName` FROM `categories` AS `Category` WHERE `lngid` = 1 AND `lngid2` = 1 AND `removed` = 'N' AND `maincatid` = 4 660
46SELECT `Category`.`id`, `Category`.`childcatcode`, `Category`.`keywords`, `Category`.`titledes`, `Category`.`metades`, `Category`.`maincatid`, `Category`.`removed`, `Category`.`chcatimage`, `Category`.`subcatexist`, `Category`.`childcatid`, `Category`.`lngid`, `Category`.`lngid2`, `Category`.`childcatname`, `Category`.`slug_childcatname`, `Category`.`childcatdesc`, `Category`.`maincatcode`, `Category`.`maincatname`, `Category`.`slug_maincatname`, `Category`.`childcatcodeName`, `Category`.`maincatcodeName` FROM `categories` AS `Category` WHERE `lngid` = 1 AND `lngid2` = 1 AND `removed` = 'N' AND `maincatid` = 5 550
47SELECT `Subcategory`.`maincatid`, `Subcategory`.`maincatcode`, `Subcategory`.`maincatname`, `Subcategory`.`slug_maincatname`, `Subcategory`.`childcatexist`, `Subcategory`.`childcatid`, `Subcategory`.`childcatcode`, `Subcategory`.`childcatname`, `Subcategory`.`subcatexist`, `Subcategory`.`slug_childcatname`, `Subcategory`.`subcatimage`, `Subcategory`.`keywords`, `Subcategory`.`metades`, `Subcategory`.`titledes`, `Subcategory`.`id`, `Subcategory`.`subcatcode`, `Subcategory`.`subcatname`, `Subcategory`.`subcatcoment`, `Subcategory`.`lngid`, `Subcategory`.`slug_subcatname`, `Subcategory`.`lngid2`, `Subcategory`.`lngid3`, `Subcategory`.`removed` FROM `subcategories` AS `Subcategory` WHERE `lngid` = 1 AND `lngid3` = 1 AND `lngid2` = 1 AND `removed` = 'N' AND `childcatid` = 54 220
48SELECT `Category`.`id`, `Category`.`childcatcode`, `Category`.`keywords`, `Category`.`titledes`, `Category`.`metades`, `Category`.`maincatid`, `Category`.`removed`, `Category`.`chcatimage`, `Category`.`subcatexist`, `Category`.`childcatid`, `Category`.`lngid`, `Category`.`lngid2`, `Category`.`childcatname`, `Category`.`slug_childcatname`, `Category`.`childcatdesc`, `Category`.`maincatcode`, `Category`.`maincatname`, `Category`.`slug_maincatname`, `Category`.`childcatcodeName`, `Category`.`maincatcodeName` FROM `categories` AS `Category` WHERE `lngid` = 1 AND `lngid2` = 1 AND `removed` = 'N' AND `maincatid` = 6 440
49SELECT `Subcategory`.`maincatid`, `Subcategory`.`maincatcode`, `Subcategory`.`maincatname`, `Subcategory`.`slug_maincatname`, `Subcategory`.`childcatexist`, `Subcategory`.`childcatid`, `Subcategory`.`childcatcode`, `Subcategory`.`childcatname`, `Subcategory`.`subcatexist`, `Subcategory`.`slug_childcatname`, `Subcategory`.`subcatimage`, `Subcategory`.`keywords`, `Subcategory`.`metades`, `Subcategory`.`titledes`, `Subcategory`.`id`, `Subcategory`.`subcatcode`, `Subcategory`.`subcatname`, `Subcategory`.`subcatcoment`, `Subcategory`.`lngid`, `Subcategory`.`slug_subcatname`, `Subcategory`.`lngid2`, `Subcategory`.`lngid3`, `Subcategory`.`removed` FROM `subcategories` AS `Subcategory` WHERE `lngid` = 1 AND `lngid3` = 1 AND `lngid2` = 1 AND `removed` = 'N' AND `childcatid` = 26 550
50SELECT `Category`.`id`, `Category`.`childcatcode`, `Category`.`keywords`, `Category`.`titledes`, `Category`.`metades`, `Category`.`maincatid`, `Category`.`removed`, `Category`.`chcatimage`, `Category`.`subcatexist`, `Category`.`childcatid`, `Category`.`lngid`, `Category`.`lngid2`, `Category`.`childcatname`, `Category`.`slug_childcatname`, `Category`.`childcatdesc`, `Category`.`maincatcode`, `Category`.`maincatname`, `Category`.`slug_maincatname`, `Category`.`childcatcodeName`, `Category`.`maincatcodeName` FROM `categories` AS `Category` WHERE `lngid` = 1 AND `lngid2` = 1 AND `removed` = 'N' AND `maincatid` = 7 220
51SELECT `Category`.`id`, `Category`.`childcatcode`, `Category`.`keywords`, `Category`.`titledes`, `Category`.`metades`, `Category`.`maincatid`, `Category`.`removed`, `Category`.`chcatimage`, `Category`.`subcatexist`, `Category`.`childcatid`, `Category`.`lngid`, `Category`.`lngid2`, `Category`.`childcatname`, `Category`.`slug_childcatname`, `Category`.`childcatdesc`, `Category`.`maincatcode`, `Category`.`maincatname`, `Category`.`slug_maincatname`, `Category`.`childcatcodeName`, `Category`.`maincatcodeName` FROM `categories` AS `Category` WHERE `lngid` = 1 AND `lngid2` = 1 AND `removed` = 'N' AND `maincatid` = 8 13130
52SELECT `Subcategory`.`maincatid`, `Subcategory`.`maincatcode`, `Subcategory`.`maincatname`, `Subcategory`.`slug_maincatname`, `Subcategory`.`childcatexist`, `Subcategory`.`childcatid`, `Subcategory`.`childcatcode`, `Subcategory`.`childcatname`, `Subcategory`.`subcatexist`, `Subcategory`.`slug_childcatname`, `Subcategory`.`subcatimage`, `Subcategory`.`keywords`, `Subcategory`.`metades`, `Subcategory`.`titledes`, `Subcategory`.`id`, `Subcategory`.`subcatcode`, `Subcategory`.`subcatname`, `Subcategory`.`subcatcoment`, `Subcategory`.`lngid`, `Subcategory`.`slug_subcatname`, `Subcategory`.`lngid2`, `Subcategory`.`lngid3`, `Subcategory`.`removed` FROM `subcategories` AS `Subcategory` WHERE `lngid` = 1 AND `lngid3` = 1 AND `lngid2` = 1 AND `removed` = 'N' AND `childcatid` = 32 220
53DESCRIBE `backgroundimages`991
54SELECT `Backgroundimage`.`id`, `Backgroundimage`.`imagetype`, `Backgroundimage`.`image`, `Backgroundimage`.`removed`, `Backgroundimage`.`url`, `Backgroundimage`.`matter`, `Backgroundimage`.`mapname`, `Backgroundimage`.`url1`, `Backgroundimage`.`url2` FROM `backgroundimages` AS `Backgroundimage` WHERE `removed` = 'N' AND `id` = 2 110
55DESCRIBE `custompages`551
56DESCRIBE `custompagelngs`880
57SELECT `Custompage`.`id`, `Custompage`.`pagename`, `Custompage`.`engpagecaption`, `Custompage`.`removed`, `Custompage`.`groupid`, `Custompagelng`.`custompage_id`, `Custompagelng`.`lngid`, `Custompagelng`.`pagecaption`, `Custompagelng`.`pagemetter`, `Custompagelng`.`slug_name`, `Custompagelng`.`keywords`, `Custompagelng`.`titledes`, `Custompagelng`.`metades` FROM `custompages` AS `Custompage` LEFT JOIN `custompagelngs` AS `Custompagelng` ON (`Custompagelng`.`custompage_id` = `Custompage`.`id`) WHERE `removed` = 'N' AND `lngid` = '1' AND `groupid` = 5 ORDER BY `pagecaption` ASC 000
58SELECT `Custompage`.`id`, `Custompage`.`pagename`, `Custompage`.`engpagecaption`, `Custompage`.`removed`, `Custompage`.`groupid`, `Custompagelng`.`custompage_id`, `Custompagelng`.`lngid`, `Custompagelng`.`pagecaption`, `Custompagelng`.`pagemetter`, `Custompagelng`.`slug_name`, `Custompagelng`.`keywords`, `Custompagelng`.`titledes`, `Custompagelng`.`metades` FROM `custompages` AS `Custompage` LEFT JOIN `custompagelngs` AS `Custompagelng` ON (`Custompagelng`.`custompage_id` = `Custompage`.`id`) WHERE `removed` = 'N' AND `lngid` = '1' AND `groupid` = 3 ORDER BY `pagecaption` ASC 330
59SELECT `Custompage`.`id`, `Custompage`.`pagename`, `Custompage`.`engpagecaption`, `Custompage`.`removed`, `Custompage`.`groupid`, `Custompagelng`.`custompage_id`, `Custompagelng`.`lngid`, `Custompagelng`.`pagecaption`, `Custompagelng`.`pagemetter`, `Custompagelng`.`slug_name`, `Custompagelng`.`keywords`, `Custompagelng`.`titledes`, `Custompagelng`.`metades` FROM `custompages` AS `Custompage` LEFT JOIN `custompagelngs` AS `Custompagelng` ON (`Custompagelng`.`custompage_id` = `Custompage`.`id`) WHERE `removed` = 'N' AND `lngid` = '1' AND `groupid` = 1 ORDER BY `pagecaption` ASC 660
60SELECT `Custompage`.`id`, `Custompage`.`pagename`, `Custompage`.`engpagecaption`, `Custompage`.`removed`, `Custompage`.`groupid`, `Custompagelng`.`custompage_id`, `Custompagelng`.`lngid`, `Custompagelng`.`pagecaption`, `Custompagelng`.`pagemetter`, `Custompagelng`.`slug_name`, `Custompagelng`.`keywords`, `Custompagelng`.`titledes`, `Custompagelng`.`metades` FROM `custompages` AS `Custompage` LEFT JOIN `custompagelngs` AS `Custompagelng` ON (`Custompagelng`.`custompage_id` = `Custompage`.`id`) WHERE `removed` = 'N' AND `lngid` = '1' AND `groupid` = 2 ORDER BY `pagecaption` ASC 990
61SELECT `Custompage`.`id`, `Custompage`.`pagename`, `Custompage`.`engpagecaption`, `Custompage`.`removed`, `Custompage`.`groupid`, `Custompagelng`.`custompage_id`, `Custompagelng`.`lngid`, `Custompagelng`.`pagecaption`, `Custompagelng`.`pagemetter`, `Custompagelng`.`slug_name`, `Custompagelng`.`keywords`, `Custompagelng`.`titledes`, `Custompagelng`.`metades` FROM `custompages` AS `Custompage` LEFT JOIN `custompagelngs` AS `Custompagelng` ON (`Custompagelng`.`custompage_id` = `Custompage`.`id`) WHERE `removed` = 'N' AND `lngid` = '1' AND `groupid` = 4 ORDER BY `pagecaption` ASC 000