SELECT p.id, p.extId, p.title, p.statement,p.options,p.cDate,p.priority,p.options,p.meta,(CONCAT_WS(CHAR(22 USING UTF8), at.name, at.cDate) ) AS `attachment` ,( SELECT COUNT(`id`) FROM `comment` WHERE `module` ='product' AND `itemId` = p.id AND `visibility` = 1 ) AS `comment` ,(SELECT CONCAT_WS(',',SUM(r.like),SUM(r.dislike)) FROM rating r WHERE r.itemId = p.id AND r.module = 'product' ) AS `rate` FROM article p LEFT JOIN item_attachment ia ON ia.itemId = p.id AND ia.source = 'product' AND ia.flag='default' LEFT JOIN attachment at ON at.id = ia.attachmentId WHERE p.extId = '180' AND p.type = 'product' AND p.drafted = 0 AND p.deleted = 0 AND p.visibility = 1 AND p.lang = 'en' GROUP BY p.id ORDER BY `priority` ASC LIMIT 0, 20 چیتا
flash en
Online chat 1
online mix
Attracting representatives
جذب نمایندگان

چیتا

چیتا
صفحه 1 از 2 | تعداد نتایج : 30 | 1 - 20
برو به صفحه :
تعداد در صفحه:
Cubism Cubism 0 0 0
rafael rafael 0 0 0
daya daya 0 0 0
Royal Royal 0 0 0
Arisa Arisa
Arisa
0 0 0
Rafael Rafael
Rafael
0 0 0
Adrina Adrina
Adrina
0 0 0
Kenzo Kenzo
Kenzo
0 0 0
Shideh Shideh
Shideh
0 0 0
Silver Silver
Silver
0 0 0
Jasmin Jasmin
Jasmin
0 0 0
Lalique Lalique
Lalique
0 0 0
Hermes Hermes
Hermes
0 0 0
صفحه اول < صفحه قبلی 1 2 صفحه بعدی > صفحه آخر
صفحه 1 از 2 | تعداد نتایج : 30 | 1 - 20
See Also
Cartier Cartier
Cartier

0 0 0
Nice Nice
Nice

0 0 0
Galexy Galexy
Galexy

0 0 0
Dantel Dantel
Dantel

0 0 0
Maxim Maxim
Maxim

0 0 0
Lancome Lancome
Lancome

0 0 0
Design Design
Design

0 0 0
Gucci Gucci
Gucci

0 0 0
Valentino Valentino
Valentino

0 0 0
Onix Onix
Onix

0 0 0
Vbgzr

CE en
All rights reserved by ceramnegar company
Design | Host : WebSepanta