Chair

SELECT DISTINCT p.*,pd.name,pd.description,p.image,v2.price, v2.cost, v2.compare_price, (v2.compare_price - v2.price) as discount, (100-((100 * v2.price)/v2.compare_price)) as percentage, m.name manufacturer, d.name designer FROM oc_product p LEFT JOIN oc_product_description pd ON p.product_id = pd.product_id JOIN (SELECT v.product_id, MIN(v.price) AS minPrice FROM oc_variants v GROUP BY v.product_id ) v1 ON p.product_id = v1.product_id JOIN oc_variants v2 ON v1.product_id = v2.product_id and v1.minPrice = v2.price AND v2.price > 0 AND v2.compare_price > 0 LEFT JOIN oc_designer d ON d.designer_id = p.designer_id LEFT JOIN oc_manufacturer m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN oc_product_type pt ON p.product_type_id = pt.product_type_id LEFT JOIN oc_currency c ON c.currency_id = p.currency_id WHERE pt.name = 'SANDALYE' AND pd.tag LIKE '%İÇ%' AND v2.quantity > 0

array (
  0 => 
  array (
    'condition' => 'type',
    'condition_type' => 'equals',
    'value' => 'SANDALYE',
  ),
  1 => 
  array (
    'condition' => 'tag',
    'condition_type' => 'equals',
    'value' => 'İÇ',
  ),
  2 => 
  array (
    'condition' => 'variant_inventory',
    'condition_type' => 'greater_than',
    'value' => '0',
  ),
)

Chair

There are no products to list in this category.

Continue