[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]
You can also share your opinion about this product
To submit a review, please sign in to your account first.
0.0Average rating☆☆☆☆☆0 reviews
No reviews yet.
Write a Review
Please share your opinions based on hands-on experience and practical use, with careful attention to technical details. Avoid bias toward any specific product—clearly state both the advantages and disadvantages.nRespect other users and individuals. Messages containing offensive content or inappropriate language will be removed.
×
Questions And Answers
You can also ask your own question about this product
To submit a question, please sign in to your account first.
Please only ask questions related to this product. If you wish to submit feedback, complaints, or suggestions, kindly use the Contact Us page or reach out to the store by phone.