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

Traditional White Groom Sherwani

Traditional White Groom Sherwani

Itemcode :SH421R
Traditional white groom designer sherwani made from white color brocade fabric. Hand embroidered as shown. It has bottom as chudidar pyjama made from dupion silk fabric in white color. Sold as a "Sherwani-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 not included in the price. 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
Price in INR :
Quantity :
 
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 :
2 Calender days
Item weight :
2.00
Viewed :
923 Times
 
 
(default) 61 queries took 674 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `items`56561
2DESCRIBE `itemslngs`881
3DESCRIBE `maincategories`15151
4DESCRIBE `addtowishlists`771
5DESCRIBE `sizeavailables`14141
6DESCRIBE `itemsettings`35351
7DESCRIBE `subcategories`23231
8DESCRIBE `companydetails`17171
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` = 9845 AND `lngid` = '1' 111
11select id from itemsettings where id='9845'110
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` = 9845 110
13update items set vivedcount=vivedcount+1 where id='9845'10
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` = 9845 AND `lngid` = '1' 111
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` = 57 AND `Item`.`removed` = 'N' AND `Item`.`dissapprove` = 'Y' 24924911
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` > 9845 AND `lngid` = '1' AND `maincategory_id` = 1 AND `category_id` = 57 AND `subcategory_id` = 0 ORDER BY `Item`.`id` asc, `Item`.`itemcode` desc LIMIT 11111
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` < 9845 AND `lngid` = '1' AND `maincategory_id` = 1 AND `category_id` = 57 AND `subcategory_id` = 0 ORDER BY `Item`.`id` desc, `Item`.`itemcode` ASC LIMIT 11136
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='9845' and lngid='1' order by id desc 001
20DESCRIBE `productsmartshops`221
21SELECT DISTINCT `Productsmartshop`.`colorid` FROM `productsmartshops` AS `Productsmartshop` WHERE `itemid` = 9845 112
22DESCRIBE `itemfebrics`771
23SELECT `Itemfebric`.`febprice`, `Itemfebric`.`basefebprice`, `Itemfebric`.`xname`, `Itemfebric`.`id`, `Itemfebric`.`itemid`, `Itemfebric`.`removed`, `Itemfebric`.`lngid` FROM `itemfebrics` AS `Itemfebric` WHERE removed='N' and itemid='9845' 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='9845' and lngid='1' order by id desc 441
26DESCRIBE `itemspecialtags`551
27SELECT `Itemspecialtag`.`xname`, `Itemspecialtag`.`id`, `Itemspecialtag`.`lngid`, `Itemspecialtag`.`removed`, `Itemspecialtag`.`itemid` FROM `itemspecialtags` AS `Itemspecialtag` WHERE removed='N' and itemid='9845' 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` = '9845' 001
30DESCRIBE `itemsmeasurmenttags`881
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='9845' and lngid='1' order by id desc 00585
32DESCRIBE `itemmaterials`551
33SELECT `Itemmaterial`.`id`, `Itemmaterial`.`xname`, `Itemmaterial`.`removed`, `Itemmaterial`.`lngid`, `Itemmaterial`.`itemid` FROM `itemmaterials` AS `Itemmaterial` WHERE removed='N' and itemid='9845' and lngid='1' order by id desc 001
34DESCRIBE `itemreadymadesizes`551
35SELECT `Itemreadymadesize`.`SizeId`, `Itemreadymadesize`.`sizename` FROM `itemreadymadesizes` AS `Itemreadymadesize` WHERE `ItemId` = 9845 221
36DESCRIBE `shippingitems`771
37SELECT `Shippingitem`.`ItemId`, `Shippingitem`.`ShipingId`, `Shippingitem`.`shpingdays`, `Shippingitem`.`shipingstr`, `Shippingitem`.`expshipping`, `Shippingitem`.`expprice`, `Shippingitem`.`strname` FROM `shippingitems` AS `Shippingitem` WHERE `ItemId` = 9845 111
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`550
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