string(127) "
SELECT p.id as id
FROM #__ksenmart_products AS p
WHERE p.published=1 AND (p.parent_id=0)
GROUP BY p.id
ORDER BY p.ordering asc"

Каталог

6 582
5 167
5 167
FDM Quark Braz. Wh. Rett 80x160/ФДМК Браз. Ва. Рет 80Х160 Артикул:610010002957 Atlas Concorde Rus
5 167
10 309
FDM Quark Braz. Wh. 120x278/ФДМК Браз. Ва. 120Х278 Артикул:600180000054 Atlas Concorde Rus
8 241
10 309
6 497
6 497
6 497
Infinity Amazing Pearl 60х120 Артикул:OC0000185 Ocean Ceramic INDIA NEW
2 990
Infinity Esplandor Ice 60х120 Артикул:OC0000184 Ocean Ceramic INDIA NEW
2 990
Feanza Metal 60х120 Артикул:OC0000175 Ocean Ceramic INDIA NEW
2 990
Violin Ivory 60х120 Артикул:OC0000189 Ocean Ceramic INDIA NEW
2 990
Violin Mocha 60х120 Артикул:OC0000190 Ocean Ceramic INDIA NEW
2 990
Carbonio Silver 60х120 Артикул:OC0000186 Ocean Ceramic INDIA NEW
3 290
Millenium Dark Grey 60х120, 20мм Артикул:IRN000065 Ocean Ceramic IRAN
5 300 4 950
Millenium Black 60х60, 20мм Артикул:IRN000054 Ocean Ceramic IRAN
4 590 4 450
Millenium Black 60х120, 20мм Артикул:IRN000064 Ocean Ceramic IRAN
5 300 4 950
Carbonio White 60х120 Артикул:OC0000187 Ocean Ceramic INDIA NEW
3 290
Carbonio Bisque 60х120 Артикул:OC0000188 Ocean Ceramic INDIA NEW
3 290
Carbonio Nero 60х120 Артикул:OC0000191 Ocean Ceramic INDIA NEW
3 290
Element Castona Tan 60х120 Артикул:OC0000182 Ocean Ceramic INDIA NEW
3 090
Element Castona Gris 60х120 Артикул:OC0000181 Ocean Ceramic INDIA NEW
3 090
Oxide Copper 60х120 Артикул:OC0000180 Ocean Ceramic INDIA NEW
2 790
Oxide Vega 60х120 Артикул:OC0000179 Ocean Ceramic INDIA NEW
2 790
Oxide Cobalt 60х120 Артикул:OC0000178 Ocean Ceramic INDIA NEW
2 790
Trixxon Fern 60х120 Артикул:OC0000149 Ocean Ceramic INDIA NEW
2 790 2 890
Breccia Bianco Rock 60х120 Артикул:OC0000177 Ocean Ceramic INDIA NEW
2 990
Breccia Bianco 60х120 Артикул:OC0000176 Ocean Ceramic INDIA NEW
2 790