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

Glamorous Look Embroidered Jodhpuri Suit

Glamorous Look Embroidered Jodhpuri Suit

Itemcode :JO123
Glamorous look two piece angarakha style designer Jodhpuri suit made in cream polyester fabric. It has jacket embroidered at neck, sleeves cuff, back and at front. At bottom trouser made in same cream color 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. 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 :
832 Times
 
 
(default) 61 queries took 80 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `items`56561
2DESCRIBE `itemslngs`880
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` = 719 AND `lngid` = '1' 111
11select id from itemsettings where id='719'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` = 719 110
13update items set vivedcount=vivedcount+1 where id='719'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` = 719 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` > 719 AND `lngid` = '1' AND `maincategory_id` = 1 AND `category_id` = 4 AND `subcategory_id` = 0 ORDER BY `Item`.`id` asc, `Item`.`itemcode` desc LIMIT 11140
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` < 719 AND `lngid` = '1' AND `maincategory_id` = 1 AND `category_id` = 4 AND `subcategory_id` = 0 ORDER BY `Item`.`id` desc, `Item`.`itemcode` ASC LIMIT 1113
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='719' and lngid='1' order by id desc 000
20DESCRIBE `productsmartshops`220
21SELECT DISTINCT `Productsmartshop`.`colorid` FROM `productsmartshops` AS `Productsmartshop` WHERE `itemid` = 719 110
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='719' and lngid='1' order by id desc 660
24DESCRIBE `itemoccasions`551
25SELECT `Itemoccasion`.`id`, `Itemoccasion`.`xname`, `Itemoccasion`.`removed`, `Itemoccasion`.`lngid`, `Itemoccasion`.`itemid` FROM `itemoccasions` AS `Itemoccasion` WHERE removed='N' and itemid='719' 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='719' 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` = '719' 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='719' and lngid='1' order by id desc 12120
32DESCRIBE `itemmaterials`551
33SELECT `Itemmaterial`.`id`, `Itemmaterial`.`xname`, `Itemmaterial`.`removed`, `Itemmaterial`.`lngid`, `Itemmaterial`.`itemid` FROM `itemmaterials` AS `Itemmaterial` WHERE removed='N' and itemid='719' and lngid='1' order by id desc 000
34DESCRIBE `itemreadymadesizes`551
35SELECT `Itemreadymadesize`.`SizeId`, `Itemreadymadesize`.`sizename` FROM `itemreadymadesizes` AS `Itemreadymadesize` WHERE `ItemId` = 719 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` = 719 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`553
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