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

Occasional Jodhpuri Suit

Occasional Jodhpuri Suit

Itemcode :JO288
Occasional jodhpuri suit made in beige color jute fabric. It has bottom as black polyester 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. All Accessories shown are included in the price except shoes and shirts. 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 :
15 Calendar days
Item weight :
2.00
Viewed :
590 Times
 
 
(default) 61 queries took 662 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `items`56561
2DESCRIBE `itemslngs`880
3DESCRIBE `maincategories`15151
4DESCRIBE `addtowishlists`770
5DESCRIBE `sizeavailables`14141
6DESCRIBE `itemsettings`35351
7DESCRIBE `subcategories`23231
8DESCRIBE `companydetails`17170
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` = 9578 AND `lngid` = '1' 111
11select id from itemsettings where id='9578'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` = 9578 110
13update items set vivedcount=vivedcount+1 where id='9578'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` = 9578 AND `lngid` = '1' 110
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' 49049012
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` > 9578 AND `lngid` = '1' AND `maincategory_id` = 6 AND `category_id` = 27 AND `subcategory_id` = 0 ORDER BY `Item`.`id` asc, `Item`.`itemcode` desc LIMIT 11113
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` < 9578 AND `lngid` = '1' AND `maincategory_id` = 6 AND `category_id` = 27 AND `subcategory_id` = 0 ORDER BY `Item`.`id` desc, `Item`.`itemcode` ASC LIMIT 11129
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='9578' and lngid='1' order by id desc 001
20DESCRIBE `productsmartshops`220
21SELECT DISTINCT `Productsmartshop`.`colorid` FROM `productsmartshops` AS `Productsmartshop` WHERE `itemid` = 9578 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='9578' 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='9578' 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='9578' 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` = '9578' 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='9578' and lngid='1' order by id desc 1212583
32DESCRIBE `itemmaterials`551
33SELECT `Itemmaterial`.`id`, `Itemmaterial`.`xname`, `Itemmaterial`.`removed`, `Itemmaterial`.`lngid`, `Itemmaterial`.`itemid` FROM `itemmaterials` AS `Itemmaterial` WHERE removed='N' and itemid='9578' and lngid='1' order by id desc 001
34DESCRIBE `itemreadymadesizes`551
35SELECT `Itemreadymadesize`.`SizeId`, `Itemreadymadesize`.`sizename` FROM `itemreadymadesizes` AS `Itemreadymadesize` WHERE `ItemId` = 9578 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` = 9578 331
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`20202
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`881
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