CREATE TABLE IF NOT EXISTS `oc_product` (
  `product_id` int NOT NULL,
  `model` varchar(64) NOT NULL,
  `sku` varchar(64) NOT NULL,
  `upc` varchar(12) NOT NULL,
  `ean` varchar(14) NOT NULL,
  `jan` varchar(13) NOT NULL,
  `isbn` varchar(17) NOT NULL,
  `mpn` varchar(64) NOT NULL,
  `location` varchar(128) NOT NULL,
  `quantity` int NOT NULL DEFAULT '0',
  `stock_status_id` int NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `manufacturer_id` int NOT NULL,
  `shipping` tinyint(1) NOT NULL DEFAULT '1',
  `price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `points` int NOT NULL DEFAULT '0',
  `tax_class_id` int NOT NULL,
  `date_available` date NOT NULL DEFAULT '1990-09-02',
  `weight` decimal(15,3) NOT NULL DEFAULT '0.000',
  `weight_class_id` int NOT NULL DEFAULT '0',
  `length` decimal(15,8) NOT NULL DEFAULT '0.00000000',
  `width` decimal(15,8) NOT NULL DEFAULT '0.00000000',
  `height` decimal(15,8) NOT NULL DEFAULT '0.00000000',
  `length_class_id` int NOT NULL DEFAULT '0',
  `subtract` tinyint(1) NOT NULL DEFAULT '1',
  `measure` varchar(64) DEFAULT NULL,
  `inlay` varchar(255) DEFAULT NULL,
  `minimum` int NOT NULL DEFAULT '1',
  `sort_order` int NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `viewed` int NOT NULL DEFAULT '0',
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `noindex` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`product_id`),
  KEY `manufacturer_id` (`manufacturer_id`),
  KEY `model` (`model`),
  KEY `image_price_quantity_status` (`image`,`price`,`quantity`,`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

CREATE TABLE IF NOT EXISTS `oc_attribute` (
  `attribute_id` int NOT NULL AUTO_INCREMENT,
  `attribute_group_id` int NOT NULL,
  `name` varchar(32) NOT NULL,
  `value` varchar(32) NOT NULL,
  `sort_order` int NOT NULL,
  PRIMARY KEY (`attribute_id`),
  KEY `attribute_id_name_value` (`attribute_id`,`name`,`value`)
) ENGINE=InnoDB AUTO_INCREMENT=383 DEFAULT CHARSET=utf8mb3;

CREATE TABLE IF NOT EXISTS `oc_product_attribute` (
  `product_id` int NOT NULL,
  `attribute_id` int NOT NULL,
  `language_id` int NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`product_id`,`attribute_id`,`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

SELECT DISTINCT
    a.attribute_id attribute_id,
    a.name,
    a.value
FROM
    oc_product AS p
LEFT JOIN
    oc_product_attribute AS pa
ON
    (p.product_id = pa.product_id)
LEFT JOIN
    oc_attribute AS a
ON
    (
        pa.attribute_id = a.attribute_id
    )
WHERE
     p.image IS NOT NULL AND p.price > 0 AND p.quantity > 0 AND p.status > 0  

1	SIMPLE	p		range	image_price_quantity_status	image_price_quantity_status	768		20678	3.70	Using where; Using index; Using temporary	
1	SIMPLE	pa		ref	PRIMARY	PRIMARY	4	dev_shop.p.product_id	5	100.00	Using index	
1	SIMPLE	a		eq_ref	PRIMARY,attribute_id_name_value	PRIMARY	4	dev_shop.pa.attribute_id	1	100.00