Warning: mysqli::query(): (HY000/1194): Table 'oc_product_attribute' is marked as crashed and should be repaired in /var/www/sportmir/data/www/sportmir.club/system/storage/modification/system/library/db/mysqli.php on line 26Notice: Error: Table 'oc_product_attribute' is marked as crashed and should be repaired Error No: 1194
SELECT
`a`.`attribute_id`,
REPLACE(REPLACE(TRIM(pa.text), '
', ''), '
', '') AS `txt`,
`ad`.`name`,
`ad`.`mf_tooltip` AS `tooltip`,
`agd`.`name` AS `gname`,
`agd`.`attribute_group_id`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `pts`
ON
`p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN
`oc_product_attribute` AS `pa`
ON
`p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 1
INNER JOIN
`oc_attribute` AS `a`
ON
`a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN
`oc_attribute_description` AS `ad`
ON
`ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 1
INNER JOIN
`oc_attribute_group` AS `ag`
ON
`ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN
`oc_attribute_group_description` AS `agd`
ON
`agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 1
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` IN(170)
GROUP BY
`txt`, `pa`.`attribute_id`
HAVING
`txt` != ''
ORDER BY
`txt`
in /var/www/sportmir/data/www/sportmir.club/system/storage/modification/system/library/db/mysqli.php on line 48Ракетки для настольного тенниса - 4 страница
