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

Emperor Look Wedding Suit

Emperor Look Wedding Suit

Itemcode :JO240
Emperor look groom wedding jodhpuri suit made in burgundy color linen fabric. It has bottom as black trouser. 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. Accessories shoes and watches 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
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.
Accessories
Quantity
Price in INR
   Matching Nehru cotton shirt
3037.5
 
Shipping in india Shipping outside india
Shipping Time :
Normal shipping days :
21 Calendar days
Item weight :
2.00
Viewed :
11506 Times
 
 
(default) 61 queries took 895 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` = 6747 AND `lngid` = '1' 111
11select id from itemsettings where id='6747'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` = 6747 110
13update items set vivedcount=vivedcount+1 where id='6747'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` = 6747 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` = 4 AND `Item`.`removed` = 'N' AND `Item`.`dissapprove` = 'Y' 31131112
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` > 6747 AND `lngid` = '1' AND `maincategory_id` = 1 AND `category_id` = 4 AND `subcategory_id` = 0 ORDER BY `Item`.`id` asc, `Item`.`itemcode` desc LIMIT 11123
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` < 6747 AND `lngid` = '1' AND `maincategory_id` = 1 AND `category_id` = 4 AND `subcategory_id` = 0 ORDER BY `Item`.`id` desc, `Item`.`itemcode` ASC LIMIT 11122
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='6747' and lngid='1' order by id desc 000
20DESCRIBE `productsmartshops`221
21SELECT DISTINCT `Productsmartshop`.`colorid` FROM `productsmartshops` AS `Productsmartshop` WHERE `itemid` = 6747 111
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='6747' 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='6747' and lngid='1' order by id desc 550
26DESCRIBE `itemspecialtags`551
27SELECT `Itemspecialtag`.`xname`, `Itemspecialtag`.`id`, `Itemspecialtag`.`lngid`, `Itemspecialtag`.`removed`, `Itemspecialtag`.`itemid` FROM `itemspecialtags` AS `Itemspecialtag` WHERE removed='N' and itemid='6747' and lngid='1' order by id desc 000
28DESCRIBE `accessories`880
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` = '6747' 110
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='6747' and lngid='1' order by id desc 1212777
32DESCRIBE `itemmaterials`552
33SELECT `Itemmaterial`.`id`, `Itemmaterial`.`xname`, `Itemmaterial`.`removed`, `Itemmaterial`.`lngid`, `Itemmaterial`.`itemid` FROM `itemmaterials` AS `Itemmaterial` WHERE removed='N' and itemid='6747' and lngid='1' order by id desc 001
34DESCRIBE `itemreadymadesizes`558
35SELECT `Itemreadymadesize`.`SizeId`, `Itemreadymadesize`.`sizename` FROM `itemreadymadesizes` AS `Itemreadymadesize` WHERE `ItemId` = 6747 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` = 6747 551
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`555
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`20203
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 773
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 442
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 552
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 442
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 552
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`554
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 002
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 664
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