SELECT * 
			FROM `oc_product` p
			LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
			LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
			LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id)
			LEFT JOIN `oc_category` c ON (c.category_id = p2c.category_id) 
			LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
			WHERE 
				c.category_id IN (113) 
				AND p.status = '1'
				AND p.date_available <= NOW()
				AND pd.language_id = '2'
				AND p2s.store_id = '0'
				AND c.status = '1'
				AND c2s.store_id = '0'
				AND p.product_id != '11320'
		<pre>Array
(
    [21198] => Array
        (
            [product_id] => 21198
            [name] => Air Filter (FR) Sherco Enduro 2-stroke 250/300 14-24, 4-stroke 12-24
            [description] => Air Filter (FR) Sherco Enduro 2-stroke 250/300 14-24, 4-stroke 12-24
            [meta_title] => Air Filter (FR) Sherco Enduro 2-stroke 250/300 14-24, 4-stroke 12-24
            [meta_description] => Air Filter (FR) Sherco Enduro 2-stroke 250/300 14-24, 4-stroke 12-24
            [meta_keyword] => Air Filter (FR) Sherco Enduro 2-stroke 250/300 14-24, 4-stroke 12-24
            [def_variant_id] => 0
            [quantity_total] => 3
            [tag] => Luftfilter Pre-Oiled
            [model] => ERTA156016FRX
            [sku] => TA156016FRX
            [upc] => 
            [ean] => 8720239713602
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 3
            [stock_status] => Slut i lager
            [image] => 
            [manufacturer_id] => 81
            [manufacturer] => Twin Air
            [price] => 239.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2025-02-12 14:27:20
            [date_modified] => 2025-02-12 14:27:20
            [viewed] => 376
            [special_date_end] => 
            [second_image] => 
        )

    [21189] => Array
        (
            [product_id] => 21189
            [name] => Air Filter Beta Enduro 2-str 125-300, 4-str 350/390/430/480 2020-25
            [description] => Air Filter Beta Enduro 2-str 125-300, 4-str 350/390/430/480 2020-25
            [meta_title] => Air Filter Beta Enduro 2-str 125-300, 4-str 350/390/430/480 2020-25
            [meta_description] => Air Filter Beta Enduro 2-str 125-300, 4-str 350/390/430/480 2020-25
            [meta_keyword] => Air Filter Beta Enduro 2-str 125-300, 4-str 350/390/430/480 2020-25
            [def_variant_id] => 0
            [quantity_total] => 3
            [tag] => Luftfilter
            [model] => ERTA158089
            [sku] => TA158089
            [upc] => 
            [ean] => 8720239717280
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 3
            [stock_status] => Slut i lager
            [image] => 
            [manufacturer_id] => 81
            [manufacturer] => Twin Air
            [price] => 191.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2025-02-12 14:27:20
            [date_modified] => 2025-02-12 14:27:20
            [viewed] => 346
            [special_date_end] => 
            [second_image] => 
        )

    [21190] => Array
        (
            [product_id] => 21190
            [name] => Air Filter Honda CRF250/450R/RX/RWE 2025
            [description] => Air Filter Honda CRF250/450R/RX/RWE 2025
            [meta_title] => Air Filter Honda CRF250/450R/RX/RWE 2025
            [meta_description] => Air Filter Honda CRF250/450R/RX/RWE 2025
            [meta_keyword] => Air Filter Honda CRF250/450R/RX/RWE 2025
            [def_variant_id] => 0
            [quantity_total] => 3
            [tag] => Luftfilter
            [model] => ERTA150233
            [sku] => TA150233
            [upc] => 
            [ean] => 8720239740387
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 3
            [stock_status] => Slut i lager
            [image] => catalog/manuell/emx/TA150233_t.jpg
            [manufacturer_id] => 81
            [manufacturer] => Twin Air
            [price] => 191.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2025-02-12 14:27:20
            [date_modified] => 2025-03-31 12:40:52
            [viewed] => 312
            [special_date_end] => 
            [second_image] => 
        )

    [21191] => Array
        (
            [product_id] => 21191
            [name] => Air Filter Kawasaki KX450/KX450X 24- KX250/KX250X 25
            [description] => Air Filter Kawasaki KX450/KX450X 24- KX250/KX250X 25
            [meta_title] => Air Filter Kawasaki KX450/KX450X 24- KX250/KX250X 25
            [meta_description] => Air Filter Kawasaki KX450/KX450X 24- KX250/KX250X 25
            [meta_keyword] => Air Filter Kawasaki KX450/KX450X 24- KX250/KX250X 25
            [def_variant_id] => 0
            [quantity_total] => 3
            [tag] => Luftfilter
            [model] => ERTA151128
            [sku] => TA151128
            [upc] => 
            [ean] => 8720239740431
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 3
            [stock_status] => Slut i lager
            [image] => 
            [manufacturer_id] => 81
            [manufacturer] => Twin Air
            [price] => 191.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2025-02-12 14:27:20
            [date_modified] => 2025-02-12 14:27:20
            [viewed] => 354
            [special_date_end] => 
            [second_image] => 
        )

    [21192] => Array
        (
            [product_id] => 21192
            [name] => Air Filter Kawasaki KX65 00-25
            [description] => Air Filter Kawasaki KX65 00-25
            [meta_title] => Air Filter Kawasaki KX65 00-25
            [meta_description] => Air Filter Kawasaki KX65 00-25
            [meta_keyword] => Air Filter Kawasaki KX65 00-25
            [def_variant_id] => 0
            [quantity_total] => 3
            [tag] => Luftfilter
            [model] => ERTA151010
            [sku] => TA151010
            [upc] => 
            [ean] => 8720239703436
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 3
            [stock_status] => Slut i lager
            [image] => 
            [manufacturer_id] => 81
            [manufacturer] => Twin Air
            [price] => 191.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2025-02-12 14:27:20
            [date_modified] => 2025-02-12 14:27:20
            [viewed] => 381
            [special_date_end] => 
            [second_image] => 
        )

    [21193] => Array
        (
            [product_id] => 21193
            [name] => Air Filter Kawasaki KX85 01-25, KX80 91-00
            [description] => Air Filter Kawasaki KX85 01-25, KX80 91-00
            [meta_title] => Air Filter Kawasaki KX85 01-25, KX80 91-00
            [meta_description] => Air Filter Kawasaki KX85 01-25, KX80 91-00
            [meta_keyword] => Air Filter Kawasaki KX85 01-25, KX80 91-00
            [def_variant_id] => 0
            [quantity_total] => 3
            [tag] => Luftfilter
            [model] => ERTA151009
            [sku] => TA151009
            [upc] => 
            [ean] => 8720239703399
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 3
            [stock_status] => Slut i lager
            [image] => 
            [manufacturer_id] => 81
            [manufacturer] => Twin Air
            [price] => 191.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2025-02-12 14:27:20
            [date_modified] => 2025-02-12 14:27:20
            [viewed] => 355
            [special_date_end] => 
            [second_image] => 
        )

    [21194] => Array
        (
            [product_id] => 21194
            [name] => Air Filter KTM/HQ/GasGas SX50 24- TC50 24- MC50 24-
            [description] => Air Filter KTM/HQ/GasGas SX50 24- TC50 24- MC50 24-
            [meta_title] => Air Filter KTM/HQ/GasGas SX50 24- TC50 24- MC50 24-
            [meta_description] => Air Filter KTM/HQ/GasGas SX50 24- TC50 24- MC50 24-
            [meta_keyword] => Air Filter KTM/HQ/GasGas SX50 24- TC50 24- MC50 24-
            [def_variant_id] => 0
            [quantity_total] => 3
            [tag] => Luftfilter
            [model] => ERTA154011
            [sku] => TA154011
            [upc] => 
            [ean] => 8720239739046
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 3
            [stock_status] => Slut i lager
            [image] => 
            [manufacturer_id] => 81
            [manufacturer] => Twin Air
            [price] => 191.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2025-02-12 14:27:20
            [date_modified] => 2025-02-12 14:27:20
            [viewed] => 337
            [special_date_end] => 
            [second_image] => 
        )

    [21199] => Array
        (
            [product_id] => 21199
            [name] => Air Filter Pre Oiled Honda CRF250/450R/RX/RWE 2025
            [description] => Air Filter Pre Oiled Honda CRF250/450R/RX/RWE 2025
            [meta_title] => Air Filter Pre Oiled Honda CRF250/450R/RX/RWE 2025
            [meta_description] => Air Filter Pre Oiled Honda CRF250/450R/RX/RWE 2025
            [meta_keyword] => Air Filter Pre Oiled Honda CRF250/450R/RX/RWE 2025
            [def_variant_id] => 0
            [quantity_total] => 3
            [tag] => Luftfilter Pre-Oiled
            [model] => ERTA150233X
            [sku] => TA150233X
            [upc] => 
            [ean] => 8720239740394
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 3
            [stock_status] => Slut i lager
            [image] => catalog/manuell/emx/TA150233X_t.jpg
            [manufacturer_id] => 81
            [manufacturer] => Twin Air
            [price] => 231.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2025-02-12 14:27:20
            [date_modified] => 2025-03-31 12:40:08
            [viewed] => 336
            [special_date_end] => 
            [second_image] => 
        )

)