[85 lines collapsed] AND b.id_shop = ' . (int)$idShop . ' ) WHERE a.id_shop = ' . (int)$idShop . ' AND b.id_product IS NULL OR seo_score = 0 AND (b.id_product IS NULL OR IFNULL(b.seo_score, 0) = 0) LIMIT ' . (int)$limit ); break; [1 line collapsed] $datas = Db::getInstance()->executeS("SELECT b.key_phrase, b.minor_key_phrase, a.id_category as `id`, a.id_lang as id_lang, a.name as name, a.meta_title, a.meta_description, a.description, '' as description_short, a.link_rewrite FROM `" . _DB_PREFIX_ . 'category_lang` a LEFT JOIN `' . _DB_PREFIX_ . 'bs_seo_category` b ON (a.id_category = b.id_category AND a.id_lang = b.id_lang) WHERE b.id_category IS NULL OR b.seo_score = 0 LIMIT ' . (int) $limit); WHERE b.id_category IS NULL OR IFNULL(b.seo_score, 0) = 0 LIMIT ' . (int) $limit); break; case 'cms': $datas = Db::getInstance()->executeS("SELECT b.key_phrase, b.minor_key_phrase, a.id_cms as `id`, a.id_lang as id_lang, a.meta_title as `name`, a.head_seo_title as meta_title, a.meta_description, a.content as description, '' as description_short, a.link_rewrite FROM `" . _DB_PREFIX_ . 'cms_lang` a LEFT JOIN `' . _DB_PREFIX_ . 'bs_seo_cms` b ON (a.id_cms = b.id_cms AND a.id_lang = b.id_lang) WHERE b.id_cms IS NULL OR b.seo_score = 0 LIMIT ' . (int) $limit); WHERE b.id_cms IS NULL OR IFNULL(b.seo_score, 0) = 0 LIMIT ' . (int) $limit); break; case 'cms_category': $datas = Db::getInstance()->executeS("SELECT b.key_phrase, b.minor_key_phrase, a.id_cms_category as `id`, a.id_lang as id_lang, a.name, a.meta_title, a.meta_description, a.description, '' as description_short, a.link_rewrite FROM `" . _DB_PREFIX_ . 'cms_category_lang` a LEFT JOIN `' . _DB_PREFIX_ . 'bs_seo_cms_category` b ON (a.id_cms_category = b.id_cms_category AND a.id_lang = b.id_lang) WHERE b.id_cms_category IS NULL OR b.seo_score = 0 LIMIT ' . (int) $limit); WHERE b.id_cms_category IS NULL OR IFNULL(b.seo_score, 0) = 0 LIMIT ' . (int) $limit); break; case 'manufacturer': $datas = Db::getInstance()->executeS('SELECT b.key_phrase, b.minor_key_phrase, a.id_manufacturer as `id`, a.id_lang as id_lang, m.name, a.meta_title, a.meta_description, a.description, a.short_description as description_short, COALESCE(mu.link_rewrite, \'\') as link_rewrite [1 line collapsed] LEFT JOIN `' . _DB_PREFIX_ . 'manufacturer` m ON m.id_manufacturer = a.id_manufacturer LEFT JOIN `' . _DB_PREFIX_ . 'bs_seo_manufacturer` b ON (a.id_manufacturer = b.id_manufacturer AND a.id_lang = b.id_lang) LEFT JOIN `' . _DB_PREFIX_ . 'bs_seo_manufacturer_url` mu ON mu.id_manufacturer = a.id_manufacturer WHERE b.id_manufacturer IS NULL OR b.seo_score = 0 LIMIT ' . (int) $limit); WHERE b.id_manufacturer IS NULL OR IFNULL(b.seo_score, 0) = 0 LIMIT ' . (int) $limit); break; case 'supplier': $datas = Db::getInstance()->executeS("SELECT b.key_phrase, b.minor_key_phrase, a.id_supplier as `id`, a.id_lang as id_lang, s.name, a.meta_title, a.meta_description, a.description, '' as description_short, COALESCE(su.link_rewrite, '') as link_rewrite [1 line collapsed] LEFT JOIN `' . _DB_PREFIX_ . 'supplier` s ON a.id_supplier = s.id_supplier LEFT JOIN `' . _DB_PREFIX_ . 'bs_seo_supplier` b ON (a.id_supplier = b.id_supplier AND a.id_lang = b.id_lang) LEFT JOIN `' . _DB_PREFIX_ . 'bs_seo_supplier_url` su ON su.id_supplier = a.id_supplier WHERE b.id_supplier IS NULL OR b.seo_score = 0 LIMIT ' . (int) $limit); WHERE b.id_supplier IS NULL OR IFNULL(b.seo_score, 0) = 0 LIMIT ' . (int) $limit); break; case 'meta': $datas = Db::getInstance()->executeS("SELECT b.key_phrase, b.minor_key_phrase, a.id_meta as `id`, a.id_lang as id_lang, a.title as `name`, '' as meta_title, '' as meta_description, a.description, '' as description_short, a.url_rewrite as link_rewrite FROM `" . _DB_PREFIX_ . 'meta_lang` a LEFT JOIN `' . _DB_PREFIX_ . 'bs_seo_meta` b ON (a.id_meta = b.id_meta AND a.id_lang = b.id_lang) WHERE b.id_meta IS NULL OR b.seo_score = 0 LIMIT ' . (int) $limit); WHERE b.id_meta IS NULL OR IFNULL(b.seo_score, 0) = 0 LIMIT ' . (int) $limit); break; case 'stblog': $idShop = self::getContextShopId(); [959 lines collapsed]
به دلیل نوسانات نرخ ارز، ممکن است قیمتهای درجشده در سایت با تغییر همراه باشند. ما متعهدیم بهترین تجربه خرید را برای شما فراهم کنیم؛ بنابراین لطفاً پیش از ثبت سفارش، برای دریافت قیمت نهایی با واحد فروش تماس حاصل فرمایید.
لطفا ابتدا وارد شوید.
ورود به سیستم