Post Free Ad Sign Up
SELECT concat(b1.catg1,'~~',b1.url_iyp) AS l2_catg, b1.slno as l2_slno, tci.img_name_home, tci.img_name_home_width_height FROM category_tbl b1 LEFT JOIN tbl_category_image tci ON tci.final_catg_slno = b1.slno WHERE b1.slno IN (66159,79528,63665,140606,68473,63692,353941,360394,67332,355894,355145,66960,355301,332457,14171,88161,355079,356215,282274,87988,66680,182516,66162,78213,356969,172697,342190,68461,67221,355219,66160,353964,357702,336709,14170,364415,336014,63867,61992,303882,14158,64081,71795,66166,86680,358631,64189,358703,346671,77782,304819,355155,355975,355200,322040,346670,156189,91277,325417,331265,361446,67110,179102,67001,93165,360395,356103,100522,330186,74422,316957,340276,279515,69892,62620,341680,69875,93380,348525,13649,243880,14305,357317,67134,357886,13305,71154,316170,77634,144101,355799,64944,71134,159647,144623,355805,62274,281330,331476,136912) && b1.wide_range_catg=0 && final_catg='Y' ORDER BY FIELD(b1.slno, 66159,79528,63665,140606,68473,63692,353941,360394,67332,355894,355145,66960,355301,332457,14171,88161,355079,356215,282274,87988,66680,182516,66162,78213,356969,172697,342190,68461,67221,355219,66160,353964,357702,336709,14170,364415,336014,63867,61992,303882,14158,64081,71795,66166,86680,358631,64189,358703,346671,77782,304819,355155,355975,355200,322040,346670,156189,91277,325417,331265,361446,67110,179102,67001,93165,360395,356103,100522,330186,74422,316957,340276,279515,69892,62620,341680,69875,93380,348525,13649,243880,14305,357317,67134,357886,13305,71154,316170,77634,144101,355799,64944,71134,159647,144623,355805,62274,281330,331476,136912) LIMIT 40SELECT concat(b1.catg1,'~~',b1.url_iyp) AS l2_catg, b1.slno as l2_slno, tci.img_name_home, tci.img_name_home_width_height FROM category_tbl b1 LEFT JOIN tbl_category_image tci ON tci.final_catg_slno = b1.slno WHERE b1.slno IN (356079,351438,173930,304728,354019,354382,66054,323511,337913,351437,239272,354379,273738,65196,355218,149774,358463,357516,320877,193616,354394,13619,331886,323891,234033,76675,349960,357198,63871,358539,358464,357860,348977,337629,354386,354290,351085,13316,332317,351296,99708,116276,135397,358533,324451,62112,69438,323887,350433,358318,76615,137164,275567,350924,64099,166193,62697,78647,212981,348978,71157,218361,317275,326703,367255,77002,283956,311300,354381,67168,330570,358189,315229,329758,331062,358439,336538,351439,365617,69249,72861,230252,328880,356041,365664,72361,256575,321950,324959,327128,328849,349845,350666,358190,13915,65749,151648,246780,263150,314819) && b1.wide_range_catg=0 && final_catg='Y' ORDER BY FIELD(b1.slno, 62697,63871,66054,323511,351437,354019,354371,358190) DESC, FIELD(b1.slno, 356079,351438,173930,304728,354019,354382,66054,323511,337913,351437,239272,354379,273738,65196,355218,149774,358463,357516,320877,193616,354394,13619,331886,323891,234033,76675,349960,357198,63871,358539,358464,357860,348977,337629,354386,354290,351085,13316,332317,351296,99708,116276,135397,358533,324451,62112,69438,323887,350433,358318,76615,137164,275567,350924,64099,166193,62697,78647,212981,348978,71157,218361,317275,326703,367255,77002,283956,311300,354381,67168,330570,358189,315229,329758,331062,358439,336538,351439,365617,69249,72861,230252,328880,356041,365664,72361,256575,321950,324959,327128,328849,349845,350666,358190,13915,65749,151648,246780,263150,314819) LIMIT 40

Copper Jugs Dealers in Madurai

(3 products available)
  • Premium
    1500 Ml Copper Water Jug +1

    1500 Ml Copper Water Jug

    600 / Piece
    • MOQ10 Piece
    • Country of OriginIndia
    • Number Of FlowerWater Jugs
    • Capacity1500 Ml
    • FeatureLeakage Proof, Good Quality, Fine Finish
    • ApplicationStoring Water
    • ShapeRound
    • MaterialCopper
    • Availability180 gm
    ...more
    www

    Chandran Metal

    Lakshmipuram, Madurai
    GST 2 yrs
  • Copper Jug

    Copper Jug

    725 / Piece
    • MaterialCopper
    • FinishingPolished
    • Usage/ApplicationHome
    • BrandSri Vinayaga Metals
    • Capacity2 L
    • PatternPlain
    ...more

    Sri Vinayaga Metals

    Madurai
    4 yrs
  • Copper Jug

    Copper Jug

    450 / Piece
    • MOQ1 Piece
    • MaterialCopper
    • FinishingPolished
    • Country of OriginMade in India
    • Usage/ApplicationHome
    • Capacity1.2 Liter
    ...more

    Sri Mahalakshmi Metals

    Madurai
    6 yrs

GENERAL LINK

Top Cities (India)

Madurai Localities

top